当前位置: 首页>>代码示例>>PHP>>正文


PHP mslib_fe::getOrdersPageSet方法代码示例

本文整理汇总了PHP中mslib_fe::getOrdersPageSet方法的典型用法代码示例。如果您正苦于以下问题:PHP mslib_fe::getOrdersPageSet方法的具体用法?PHP mslib_fe::getOrdersPageSet怎么用?PHP mslib_fe::getOrdersPageSet使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在mslib_fe的用法示例。


在下文中一共展示了mslib_fe::getOrdersPageSet方法的5个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: array

     $orderby = array();
     $where = array();
     $orderby = array();
     $select = array();
     if (strlen($this->get['q']) > 0) {
         $items = array();
         $items[] = "orders_id='" . addslashes($this->get['q']) . "'";
         $items[] = "customer_id LIKE '%" . addslashes($this->get['q']) . "%'";
         $filter[] = '(' . implode(" or ", $items) . ')';
     }
     if (!$this->masterShop) {
         $filter[] = 'o.page_uid=' . $this->showCatalogFromPage;
     }
     $select[] = 'o.*, osd.name as orders_status';
     $orderby[] = 'o.orders_id desc';
     $pageset = mslib_fe::getOrdersPageSet($filter, $offset, $this->get['limit'], $orderby, $having, $select, $where, $from);
     $resultset['orders'] = $pageset;
     $max_page = ceil($pageset['total_rows'] / $limit);
     if ($max_page > $global_max_page) {
         $global_max_page = $max_page;
     }
     if ($pageset['total_rows'] > $limit && $p + 1 < $max_page) {
         $have_paging = true;
     }
     if ($pageset['total_rows'] > 0) {
         $results_counter++;
     }
 }
 // orders search eof
 // invoices search
 if ($modules['invoices']) {
开发者ID:bvbmedia,项目名称:multishop,代码行数:31,代码来源:admin_search.php

示例2: implode

//$orderby[]='orders_id desc';
$select[] = 'o.*, osd.name as orders_status';
$orderby[] = 'o.orders_id desc';
if ($this->post['tx_multishop_pi1']['by_phone']) {
    $filter[] = 'o.by_phone=1';
}
if ($this->post['tx_multishop_pi1']['is_proposal']) {
    $filter[] = 'o.is_proposal=1';
} else {
    $filter[] = 'o.is_proposal=0';
}
if (isset($this->post['selected_orders'])) {
    $selected_orders = '(o.orders_id=' . implode(" or o.orders_id=", $this->post['selected_orders']) . ')';
    $filter[] = $selected_orders;
}
$pageset = mslib_fe::getOrdersPageSet($filter, $offset, 500000, $orderby, $having, $select, $where, $from);
$tmporders = $pageset['orders'];
$filename = 'orders_listing_' . time() . '.xls';
$dir = $this->DOCUMENT_ROOT;
$export_file = $dir . "uploads/tx_multishop/tmp/" . $filename;
// Creating a workbook
$phpexcel = new PHPExcel();
$phpexcel->getActiveSheet()->setTitle('orders listing');
$phpexcel->setActiveSheetIndex(0);
$header_style['font'] = array('bold' => true);
// write the header
$sheet_header[] = $this->pi_getLL('orders_id');
$sheet_header[] = $this->pi_getLL('store');
$sheet_header[] = $this->pi_getLL('customer');
$sheet_header[] = $this->pi_getLL('order_date');
$sheet_header[] = $this->pi_getLL('amount');
开发者ID:bvbmedia,项目名称:multishop,代码行数:31,代码来源:orders_xls_export.php

示例3: array

if (!$this->masterShop) {
    $data_query['filter'][] = 'o.page_uid=' . $this->shop_pid;
}
$data_query['select'][] = 'o.*, osd.name as orders_status';
$order_by = 'o.billing_name';
$order = 'desc';
$order_link = 'a';
$data_query['order_by'][] = $order_by . ' ' . $order;
// hook
if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/scripts/admin_pages/admin_stats_user_agent.php']['statsUseragentQueryHookPreProc'])) {
    $params = array('data_query' => &$data_query);
    foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/scripts/admin_pages/admin_stats_user_agent.php']['statsUseragentQueryHookPreProc'] as $funcRef) {
        \TYPO3\CMS\Core\Utility\GeneralUtility::callUserFunction($funcRef, $params, $this);
    }
}
$pageset = mslib_fe::getOrdersPageSet($data_query['filter'], $offset, $this->post['limit'], $data_query['order_by'], $having, $data_query['select'], $data_query['where'], $data_query['from']);
$tmporders = $pageset['orders'];
if ($pageset['total_rows'] > 0) {
    require \TYPO3\CMS\Core\Utility\ExtensionManagementUtility::extPath('multishop') . 'scripts/admin_pages/includes/user-agent_listing_table.php';
} else {
    $subpartArray = array();
    $subpartArray['###LABEL_NO_RESULTS###'] = $this->pi_getLL('no_records_found') . '.';
    $no_results = $this->cObj->substituteMarkerArrayCached($subparts['useragents_noresults'], array(), $subpartArray);
}
$subpartArray = array();
$subpartArray['###FORM_SEARCH_ACTION_URL###'] = mslib_fe::typolink($this->shop_pid . ',2003', 'tx_multishop_pi1[page_section]=admin_stats_user_agent');
$subpartArray['###SHOP_PID###'] = $this->shop_pid;
$subpartArray['###LABEL_KEYWORD###'] = ucfirst($this->pi_getLL('keyword'));
$subpartArray['###VALUE_KEYWORD###'] = $this->post['skeyword'] ? $this->post['skeyword'] : "";
$subpartArray['###VALUE_SEARCH###'] = htmlspecialchars($this->pi_getLL('search'));
$subpartArray['###LABEL_RESULTS_LIMIT_SELECTBOX###'] = $this->pi_getLL('limit_number_of_records_to');
开发者ID:bvbmedia,项目名称:multishop,代码行数:31,代码来源:admin_stats_user_agent.php

示例4: array

    case 'admin_home':
        break;
    case 'admin_edit_customer':
        if ($this->get['tx_multishop_pi1']['cid'] && is_numeric($this->get['tx_multishop_pi1']['cid'])) {
            $data_query['filter'][] = '(o.customer_id=' . $this->get['tx_multishop_pi1']['cid'] . ')';
        }
        break;
}
// hook
if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/scripts/admin_pages/includes/admin_home/ordersLatest.php']['ordersLatestHomeStatsQueryHookPreProc'])) {
    $params = array('data_query' => &$data_query);
    foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/scripts/admin_pages/includes/admin_home/ordersLatest.php']['ordersLatestHomeStatsQueryHookPreProc'] as $funcRef) {
        \TYPO3\CMS\Core\Utility\GeneralUtility::callUserFunction($funcRef, $params, $this);
    }
}
$pageset = mslib_fe::getOrdersPageSet($data_query['filter'], $offset, 20, $data_query['order_by'], $data_query['having'], $data_query['select'], $data_query['where'], $data_query['from']);
$tmporders = $pageset['orders'];
if ($pageset['total_rows'] > 0) {
    $data = array();
    $data[] = array($this->pi_getLL('admin_label_order_number'), $this->pi_getLL('admin_label_amount'), $this->pi_getLL('date'), $this->pi_getLL('admin_paid'), $this->pi_getLL('admin_payment_method'));
    foreach ($tmporders as $order) {
        $edit_order_popup_width = 980;
        if ($this->ms['MODULES']['ADMIN_EDIT_ORDER_DISPLAY_ORDERS_PRODUCTS_STATUS'] > 0) {
            $edit_order_popup_width += 70;
        }
        if ($this->ms['MODULES']['ORDER_EDIT'] && !$order['is_locked']) {
            if ($edit_order_popup_width > 980) {
                $edit_order_popup_width += 155;
            } else {
                $edit_order_popup_width += 70;
            }
开发者ID:bvbmedia,项目名称:multishop,代码行数:31,代码来源:ordersLatest.php

示例5: array

            $markerArray['ADMIN_LABEL_BILLING_ADDRESS'] = $this->pi_getLL('admin_label_billing_address');
            $markerArray['ADMIN_LABEL_DELIVERY_ADDRESS'] = $this->pi_getLL('admin_label_delivery_address');
            // customers related orders listings
            $filter = array();
            $from = array();
            $having = array();
            $match = array();
            $orderby = array();
            $where = array();
            $select = array();
            $select[] = 'o.*';
            $filter[] = 'o.customer_id=' . $user['uid'];
            if (!$this->masterShop) {
                $filter[] = 'o.page_uid=' . $this->shop_pid;
            }
            $orders_pageset = mslib_fe::getOrdersPageSet($filter, 0, 10000, array('orders_id desc'), $having, $select, $where, $from);
            $order_listing = $this->pi_getLL('no_orders_found');
            if ($orders_pageset['total_rows'] > 0) {
                $all_orders_status = mslib_fe::getAllOrderStatus($GLOBALS['TSFE']->sys_language_uid);
                $order_listing = '<div class="table-responsive">
				<table id="product_import_table" class="table table-striped table-bordered no-mb msadmin_orders_listing">
					<thead><tr>
						<th width="50" align="right" class="cellID">' . $this->pi_getLL('orders_id') . '</th>
						<th width="110" class="cellDate">' . $this->pi_getLL('order_date') . '</th>
						<th width="50" class="cellPrice">' . $this->pi_getLL('amount') . '</th>
						<th width="50" class="cell_shipping_method">' . $this->pi_getLL('shipping_method') . '</th>
						<th width="50" class="cell_payment_method">' . $this->pi_getLL('payment_method') . '</th>
						<th width="100" class="cell_status">' . $this->pi_getLL('order_status') . '</th>
						<th width="110" class="cellDate">' . $this->pi_getLL('modified_on', 'Modified on') . '</th>
						<th width="50" class="cellStatus">' . $this->pi_getLL('admin_paid') . '</th>
					</tr></thead><tbody>';
开发者ID:bvbmedia,项目名称:multishop,代码行数:31,代码来源:admin_edit_customer.php


注:本文中的mslib_fe::getOrdersPageSet方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。