本文整理汇总了PHP中type::getSelect方法的典型用法代码示例。如果您正苦于以下问题:PHP type::getSelect方法的具体用法?PHP type::getSelect怎么用?PHP type::getSelect使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类type
的用法示例。
在下文中一共展示了type::getSelect方法的6个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: filterToptierAffiliateAccount
/**
*
* @param type $collection
* @param type $column
* @return type
*/
public function filterToptierAffiliateAccount(&$collection, $column)
{
$accountTable = Mage::getModel('core/resource')->getTableName('affiliateplus_account');
$value = $column->getFilter()->getValue();
if (!isset($value)) {
return;
}
if ($value == 'N/A') {
$collection->getSelect()->where("{$accountTable}.name IS NULL");
return;
}
$collection->getSelect()->where("{$accountTable}.name = '{$value}'");
}
示例2: filterCallback
/**
* Callback filter for Warehouse
*
* @param type $collection
* @param type $column
* @return type
*/
public function filterCallback($collection, $column)
{
$value = $column->getFilter()->getValue();
if (!is_null(@$value)) {
$collection->getSelect()->where('inventory_shipment.warehouse_id = ?', $value);
}
return $this;
}
示例3: getCustomerChartPieData
/**
* Get chart pie data for customer report
*
* @param type $collection
* @param type $requestData
* @return string
*/
public function getCustomerChartPieData($collection, $requestData)
{
$collection->getSelect()->order('IFNULL(SUM(main_table.grand_total),0) DESC')->limit(20);
$reportcode = $requestData['report_radio_select'];
$i = 0;
$series = '';
foreach ($collection as $col) {
if ($i != 0) {
$series .= ',';
}
$series .= '{name:\'' . $col->getData('customer_firstname') . " " . $col->getData('customer_lastname') . ' (' . $col->getData('telephone') . ')' . '\',y:' . abs($col->getData('sum_grand_total')) . '}';
$i++;
}
$data['series'] = $series;
return $data;
}
示例4: _filterNumberCallback
/**
* Filter number field
*
* @param type $collection
* @param type $column
* @return collection
*/
protected function _filterNumberCallback($collection, $column)
{
$filter = $column->getFilter()->getValue();
$field = $this->_getRealFieldFromAlias($column->getIndex());
if (isset($filter['from']) && $filter['from'] != '') {
$collection->getSelect()->having($field . ' >= ' . $filter['from']);
}
if (isset($filter['to']) && $filter['to'] != '') {
$collection->getSelect()->having($field . ' <= ' . $filter['to']);
}
$collection->setIsGroupCountSql(true);
$collection->setResetHaving(true);
return $collection;
}
示例5: _filterNumberCallback
/**
* Filter number field
*
* @param type $collection
* @param type $column
* @return collection
*/
protected function _filterNumberCallback($collection, $column)
{
$filter = $column->getFilter()->getValue();
$field = $this->_getRealFieldFromAlias($column->getIndex());
if (isset($filter['from'])) {
$collection->getSelect()->having($field . ' >= \'' . $filter['from'] . '\'');
}
if (isset($filter['to'])) {
$collection->getSelect()->having($field . ' <= \'' . $filter['to'] . '\'');
}
return $collection;
}
示例6: _filterDateCallback
/**
* Filter datetime field
*
* @param type $collection
* @param type $column
* @return type
*/
protected function _filterDateCallback($collection, $column)
{
$filter = $column->getFilter()->getValue();
$field = $this->_getRealFieldFromAlias($column->getIndex());
if (isset($filter['orig_from'])) {
$from = date('Y-m-d H:i:s', strtotime($filter['orig_from']));
$collection->getSelect()->having($field . ' >= \'' . $from . '\'');
}
if (isset($filter['orig_to'])) {
$to = date('Y-m-d H:i:s', strtotime($filter['orig_to']));
$collection->getSelect()->having($field . ' <= \'' . $to . '\'');
}
return $collection;
}