drillCols as $sqlAlias => $uiName) { $classSuffix = in_array($sqlAlias, array('BILLTO','SHIPTO'))?'2':''; ?> drillCols as $sqlAlias => $uiName) { // SORTING $this->newFilters = array_merge($this->filters, array( 'page' => 0, 'sort' => $sqlAlias, 'order' => $this->filters['sort'] == $sqlAlias && $this->filters['order'] == 'asc' ? 'desc' : 'asc' )) ?> plainCols as $uiName => $sqlAlias) { // SORTING $alias = is_array($sqlAlias) ? reset($sqlAlias) : $sqlAlias; $this->newFilters = array_merge($this->filters, array( 'page' => 0, 'sort' => $alias, 'order' => ($this->filters['sort'] == $alias && $this->filters['order'] == 'asc') ? 'desc' : 'asc' )) ?> breakdown as $tableData) { ?> drillCols) as $sqlAlias) { // drill in $this->newFilters = array_merge($this->filters, array( // 'drill' => $sqlAlias, 'page' => 0, 'order' => 'asc', $sqlAlias => $tableData[$sqlAlias], )); // grouping $group = array( 'IMPRINT' => 'ARTIST', 'ARTIST' => 'RELEASE_NAME', 'RELEASE_NAME' => 'SKU', 'SKU' => 'BILLTO', 'BILLTO' => 'SHIPTO', 'SHIPTO' => 'SHIPTO', ); if (isset($this->filters['drill2'])) { $group['SKU'] = $this->filters['drill2'] == 'SHIPTO' ? 'SKU' : 'SHIPTO'; } $group['SHIPTO'] = isset($this->filters['drill1']) ? $group[ $this->filters['drill1'] ] : 'IMPRINT'; $this->newFilters['group'] = $group[$sqlAlias]; $this->newFilters['sort'] = $group[$sqlAlias]; // for breadcrumbs $plainText = ''; switch ($sqlAlias) { case 'SHIPTO': $this->newFilters['PRSTADCD'] = $tableData['PRSTADCD']; $separator = Model_B2bPhysicalView::SHIPTONAME_SEPARATOR; $textParts = explode($separator, $tableData['SHIPTO']); $linkText = array_shift($textParts); $plainText = ' - '.implode($separator, $textParts); // no break case 'BILLTO': $this->newFilters['CUSTNMBR'] = $tableData['CUSTNMBR']; $this->newFilters['BILLTO'] = $tableData['BILLTO']; $this->newFilters['drill2'] = $sqlAlias; if ($sqlAlias == 'BILLTO') { $linkText = $tableData['BILLTO']; } break; case 'SKU': $this->newFilters['RELEASE_NAME'] = $tableData['RELEASE_NAME']; // no break case 'RELEASE_NAME': $this->newFilters['ARTIST'] = $tableData['ARTIST']; // no break case 'ARTIST': $this->newFilters['IMPRINT'] = $tableData['IMPRINT']; // no break case 'IMPRINT': // drilling into blue tabs $this->newFilters['drill1'] = $sqlAlias; $linkText = !empty($tableData[$sqlAlias]) ? $tableData[$sqlAlias] : ' (N/A) '; break; } ?> plainCols as $sqlAlias) { ?> 'SHIP_QTY', 'price'=>'SHIP_PRCE'), array( 'unit' =>'RTN_QTY', 'price'=>'RTN_PRCE'), array( 'unit' =>'NET', 'price'=>'NET_PRCE'), 'RTN_PER'); foreach ($historyColumns as $sqlAlias) { ?>

	Current		Order history since intervals[$this->filters['period']] ?>
			SHIP	RTN	NET	RTN %
	$alias) { ?>		$alias) { ?>