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;
}
}
}
if ($this->ms['MODULES']['CACHE_FRONT_END'] and !$this->ms['MODULES']['CACHE_TIME_OUT_SEARCH_PAGES']) {
$this->ms['MODULES']['CACHE_FRONT_END'] = 0;
}
if ($this->ms['MODULES']['CACHE_FRONT_END']) {
$options = array('caching' => true, 'cacheDir' => $this->DOCUMENT_ROOT . 'uploads/tx_multishop/tmp/cache/', 'lifeTime' => $this->ms['MODULES']['CACHE_TIME_OUT_SEARCH_PAGES']);
$Cache_Lite = new Cache_Lite($options);
$string = md5('admin_search_' . $this->showCatalogFromPage . '_' . $this->get['ms_admin_skeyword'] . '_' . $this->get['page']);
}
if (!$this->ms['MODULES']['CACHE_FRONT_END'] or $this->ms['MODULES']['CACHE_FRONT_END'] and !($content = $Cache_Lite->get($string))) {
$data = array();
if ($this->get['ms_admin_skeyword']) {
$this->get['q'] = $this->get['ms_admin_skeyword'];
$this->get['q'] = trim($this->get['q']);
$this->get['q'] = $GLOBALS['TSFE']->csConvObj->utf8_encode($this->get['q'], $GLOBALS['TSFE']->metaCharset);
$this->get['q'] = $GLOBALS['TSFE']->csConvObj->entities_to_utf8($this->get['q'], true);
$this->get['q'] = mslib_fe::RemoveXSS($this->get['q']);
}
/**
* Perform a simple text replace
* This should be used when the string does not contain HTML
* (off by default)
*/
define('STR_HIGHLIGHT_SIMPLE', 1);
/**
* Only match whole words in the string
* (off by default)
*/
define('STR_HIGHLIGHT_WHOLEWD', 2);
/**
* Case sensitive matching
* (on by default)
}
// custom page hook that can be controlled by third-party plugin eof
$query = $GLOBALS['TYPO3_DB']->INSERTquery('fe_groups', $insertArray);
$res = $GLOBALS['TYPO3_DB']->sql_query($query);
}
}
$this->cObj->data['header'] = $this->pi_getLL('groups');
$this->hideHeader = 1;
$this->ms['MODULES']['ADMIN_CUSTOMERS_LISTING_LIMIT'] = 25;
if ($_REQUEST['skeyword']) {
// using $_REQUEST cause TYPO3 converts "Command & Conquer" to "Conquer" (the & sign sucks ass)
$this->get['skeyword'] = $_REQUEST['skeyword'];
$this->get['skeyword'] = trim($this->get['skeyword']);
$this->get['skeyword'] = $GLOBALS['TSFE']->csConvObj->utf8_encode($this->get['skeyword'], $GLOBALS['TSFE']->metaCharset);
$this->get['skeyword'] = $GLOBALS['TSFE']->csConvObj->entities_to_utf8($this->get['skeyword'], true);
$this->get['skeyword'] = mslib_fe::RemoveXSS($this->get['skeyword']);
}
if (is_numeric($this->get['p'])) {
$p = $this->get['p'];
}
if ($p > 0) {
$offset = $p * $this->ms['MODULES']['ADMIN_CUSTOMERS_LISTING_LIMIT'];
} else {
$p = 0;
$offset = 0;
}
$user = $GLOBALS['TSFE']->fe_user->user;
$content = '<div class="panel panel-default">
<div class="panel-heading"><h3>' . $this->pi_getLL('add_new_group') . '</h3></div>
<div class="panel-body">
<form id="form1" class="form-horizontal" name="form1" method="post" action="' . mslib_fe::typolink($this->shop_pid . ',2003', 'tx_multishop_pi1[page_section]=admin_customer_groups') . '">
}
}
}
}
exit;
break;
case 'product':
if ($this->ADMIN_USER) {
// custom page hook that can be controlled by third-party plugin
if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/scripts/ajax_pages/core.php']['ajaxSortingProducts'])) {
$params = array();
foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/scripts/ajax_pages/core.php']['ajaxSortingProducts'] as $funcRef) {
\TYPO3\CMS\Core\Utility\GeneralUtility::callUserFunction($funcRef, $params, $this);
}
} else {
$cat_id = mslib_fe::RemoveXSS(\TYPO3\CMS\Core\Utility\GeneralUtility::_GET('catid'));
$getPost = $this->post['productlisting'];
$sort_type = $this->ms['MODULES']['PRODUCTS_LISTING_SORT_ORDER_OPTION'];
if ($sort_type == 'desc') {
$no = time();
} else {
$no = 1;
}
foreach ($getPost as $prod_id) {
if (is_numeric($prod_id) and is_numeric($cat_id)) {
$where = 'categories_id = ' . $cat_id . ' and products_id = ' . $prod_id;
$updateArray = array('sort_order' => $no);
$query = $GLOBALS['TYPO3_DB']->UPDATEquery('tx_multishop_products_to_categories', $where, $updateArray);
$res = $GLOBALS['TYPO3_DB']->sql_query($query);
$query = $GLOBALS['TYPO3_DB']->UPDATEquery('tx_multishop_products', "products_id = {$prod_id}", $updateArray);
$res = $GLOBALS['TYPO3_DB']->sql_query($query);
<?php
// deprecated, missing too much functionality
require_once PATH_tslib . 'class.tslib_pibase.php';
require_once PATH_tslib . 'class.tslib_eidtools.php';
tslib_eidtools::connectDB();
$GLOBALS['TSFE']->fe_user = tslib_eidtools::initFeUser();
$this->ms['eID'] = 1;
include_once \TYPO3\CMS\Core\Utility\ExtensionManagementUtility::extPath('multishop') . 'pi1/classes/class.mslib_fe.php';
include_once \TYPO3\CMS\Core\Utility\ExtensionManagementUtility::extPath('multishop') . 'pi1/classes/class.mslib_befe.php';
//require_once(\TYPO3\CMS\Core\Utility\ExtensionManagementUtility::extPath('pagepath').'class.tx_pagepath_api.php');
$typeGet = mslib_fe::RemoveXSS(\TYPO3\CMS\Core\Utility\GeneralUtility::_GET('type'));
// pagepath plugin must be added soon to support cooluri urls when working in eID
/*
function typolink ($page_id='', $vars='')
{
if (!$page_id) $page_id=$GLOBALS["TSFE"]->id;
$conf=array();
$conf['parameter']=$page_id;
if ($vars) $conf['additionalParams']='&'.$vars;
$conf['returnLast'] = 'url'; // get it as URL
// $url = htmlspecialchars($GLOBALS["TSFE"]->cObj->typolink(NULL, $conf));
$url = tx_pagepath_api::getPagePath($page_id, $conf);
// $url = $GLOBALS["TSFE"]->cObj->typolink(NULL, $conf);
return $url;
}
*/
//print_r($fields);
foreach ($fields as $field) {
if (strstr($field, ":")) {
$array = explode(":", $field);
$key = $array[0];
} else {
$key = $field;
}
//echo $key;
if ($key == 'input_keywords') {
$content .= '<div class="input_keywords">
<input name="id" type="hidden" value="' . $this->conf['search_page_pid'] . '" />
<input name="tx_multishop_pi1[page_section]" type="hidden" value="products_search" />
<div class="form-fieldset">
<label for="skeyword">' . ucfirst($this->pi_getLL('keyword')) . ':</label>
<input name="skeyword" type="text" value="' . htmlspecialchars(mslib_fe::RemoveXSS($this->get['skeyword'])) . '" id="skeyword" class="option-attributes"/>
<input name="Submit" type="button" value="' . htmlspecialchars($this->pi_getLL('search')) . '" class="option-attributes"/>
</div>
</div>
';
continue;
} elseif ($key == 'option_slider') {
$array = explode(":", $field);
// $ids=explode("-",$array[1]);
// get lowest left side
/*
$str="SELECT po.products_options_name, pov.products_options_values_id,pov.products_options_values_name from tx_multishop_products_options_values pov, tx_multishop_products_attributes pa, tx_multishop_products_options po where pa.options_id='".$array[1]."' and pa.options_id=po.products_options_id and po.language_id ='".$this->sys_language_uid."' and pov.products_options_values_id=pa.options_values_id order by products_options_values_name asc limit 1";
$res=$GLOBALS['TYPO3_DB']->sql_query($str);
if($GLOBALS['TYPO3_DB']->sql_num_rows($res) > 0)
{
$row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res);
if ($this->cookie['cmsLimit']) {
$this->get['cmsLimit'] = $this->cookie['cmsLimit'];
} else {
$this->get['cmsLimit'] = 30;
}
$this->ms['MODULES']['PAGESET_LIMIT'] = $this->get['cmsLimit'];
if (is_numeric($this->get['p'])) {
$p = $this->get['p'];
}
$this->searchKeywords = array();
if ($this->get['tx_multishop_pi1']['keyword']) {
// using $_REQUEST cause TYPO3 converts "Command & Conquer" to "Conquer" (the & sign sucks ass)
$this->get['tx_multishop_pi1']['keyword'] = trim($this->get['tx_multishop_pi1']['keyword']);
$this->get['tx_multishop_pi1']['keyword'] = $GLOBALS['TSFE']->csConvObj->utf8_encode($this->get['tx_multishop_pi1']['keyword'], $GLOBALS['TSFE']->metaCharset);
$this->get['tx_multishop_pi1']['keyword'] = $GLOBALS['TSFE']->csConvObj->entities_to_utf8($this->get['tx_multishop_pi1']['keyword'], true);
$this->get['tx_multishop_pi1']['keyword'] = mslib_fe::RemoveXSS($this->get['tx_multishop_pi1']['keyword']);
$this->searchKeywords[] = $this->get['tx_multishop_pi1']['keyword'];
$this->searchMode = '%keyword%';
}
$limit_search_result_selectbox = '<div class="form-inline"><div class="form-group"><label>' . $this->pi_getLL('limit_number_of_records_to') . ':</label><select name="cmsLimit" 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';
$array2[] = $this->ms['MODULES']['STORE_NAME'];
$array1[] = '###CUSTOMER_ID###';
$array2[] = $customer_id;
if ($page[0]['name']) {
$page[0]['name'] = str_replace($array1, $array2, $page[0]['name']);
$content .= '<div class="main-heading"><h3>' . $page[0]['name'] . '</h3></div>';
}
if ($page[0]['content']) {
$page[0]['content'] = str_replace($array1, $array2, $page[0]['content']);
$content .= $page[0]['content'];
}
}
} else {
$erno = array();
if ($this->post) {
$this->post['email'] = mslib_fe::RemoveXSS($this->post['email']);
$mslib_user = \TYPO3\CMS\Core\Utility\GeneralUtility::makeInstance('tx_mslib_user');
$mslib_user->init($this);
if ($this->ms['MODULES']['CREATE_ACCOUNT_REGULAR_USERNAME'] && isset($this->post['username']) && !empty($this->post['username'])) {
$mslib_user->setUsername($this->post['username']);
} else {
$mslib_user->setUsername($this->post['email']);
}
$mslib_user->setEmail($this->post['email']);
$mslib_user->setConfirmation_email($this->post['email_confirm']);
$mslib_user->setGender($this->post['gender']);
$mslib_user->setPassword($this->post['password']);
$mslib_user->setConfirmation_password($this->post['password_confirm']);
$mslib_user->setFirst_name($this->post['first_name']);
$mslib_user->setMiddle_name($this->post['middle_name']);
$mslib_user->setLast_name($this->post['last_name']);
} else {
jQuery("#skeyword").autocomplete("search");
}
},
focus: function(event, ui) {
jQuery("#skeyword").val(ui.item.skeyword);
jQuery("#page").val(0);
return false;
}
}).data(\'ui-autocomplete\')._renderItem = function (ul, item) {
return jQuery("<li></li>").data("item.autocomplete", item).append(jQuery("<a></a>").html(item.label)).appendTo(ul);
};
});
</script>';
}
// fill the row marker with the expanded rows
$subpartArray['###SEARCH_PAGE_PID###'] = $this->conf['search_page_pid'];
$subpartArray['###LABEL_KEYWORD###'] = $this->pi_getLL('keyword');
$subpartArray['###LABEL_PLACEHOLDER_KEYWORD###'] = $this->pi_getLL('keyword');
$subpartArray['###LANGUAGE_UID###'] = $this->sys_language_uid;
$subpartArray['###KEYWORD_VALUE###'] = htmlspecialchars(mslib_fe::RemoveXSS($this->get['skeyword']));
$subpartArray['###LABEL_SUBMIT_BUTTON###'] = htmlspecialchars($this->pi_getLL('search'));
// custom hook that can be controlled by third-party plugin
if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/scripts/front_pages/includes/content_elements/searchform.php']['searchFormCEPostHook'])) {
$params = array('subpartArray' => &$subpartArray);
foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/scripts/front_pages/includes/content_elements/searchform.php']['searchFormCEPostHook'] as $funcRef) {
\TYPO3\CMS\Core\Utility\GeneralUtility::callUserFunction($funcRef, $params, $this);
}
}
// completed the template expansion by replacing the "item" marker in the template
$content = $this->cObj->substituteMarkerArrayCached($subparts['template'], null, $subpartArray);
if ($discount_percentage) {
$mslib_cart = \TYPO3\CMS\Core\Utility\GeneralUtility::makeInstance('tx_mslib_cart');
$mslib_cart->init($this);
$cart = $mslib_cart->getCart();
$cart['coupon_code'] = '';
$cart['discount'] = $discount_percentage;
$cart['discount_type'] = 'percentage';
//$GLOBALS['TSFE']->fe_user->setKey('ses', $this->cart_page_uid, $cart);
//$GLOBALS['TSFE']->fe_user->storeSessionData();
tx_mslib_cart::storeCart($cart);
$content = number_format($discount_percentage) . '%';
}
}
//if(!$discount_percentage)
if (!empty($_POST['code']) && $_POST['code'] != 'undefined') {
$code = mslib_fe::RemoveXSS(mslib_befe::strtolower($_POST['code']));
$time = time();
$str = "SELECT * from tx_multishop_coupons where code = '" . addslashes($code) . "' and status = 1 and (page_uid=0 or page_uid='" . $this->showCatalogFromPage . "') and (startdate <= '" . $time . "' and enddate >= '" . $time . "')";
$qry = $GLOBALS['TYPO3_DB']->sql_query($str);
if ($GLOBALS['TYPO3_DB']->sql_num_rows($qry) > 0) {
$row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($qry);
$continue_calculate_discount = true;
if ($row['max_usage'] > 0) {
if ($row['times_used'] >= $row['max_usage']) {
$content = "0%";
$continue_calculate_discount = false;
}
}
if ($continue_calculate_discount) {
switch ($row['discount_type']) {
case 'percentage':
