PHP mslib_fe::getRecordsPageSet方法代码示例

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

//.........这里部分代码省略.........
        }
        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">

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