public function parseCategory(RM_Category_Object $obCategory, array $period = array()) { $this->_command->reset(); $this->_mine->addHolder('category_table', $obCategory->getCategoryTableName()); if ($period) { $this->_mine->addHolder('period', array("c.bdate>='" . $period[0] . "'", "c.bdate<'" . $period[1] . "'")); } $this->_command->execute(); }
public function prepareMine(RM_ReportScript_iMine $mine) { $mine->addHolder('datail_level_unique_names', qw2('generaltype_id, brand_id generaltype_name brand_name')); $mine->addHolder('datail_level_unique', qw2('generaltype_id brand_id')); $mine->addHolder('detail_id_sequence_init', $this->_object->detail()->uniqFields()); $mine->addHolder('detail_id_sequence', qw2('generaltype_id brand_id')); $mine->addHolder('detail_id_a_leading_sequence', qw2('generaltype_id brand_id')); $mine->addHolder('detail_name_sequence_init', $this->_object->detail()->uniqNamesFields()); $mine->addHolder('detail_full_a_leading_sequence', qw2('generaltype_id brand_id generaltype_name brand_name')); $mine->addHolder('detail_id_a_leading_sequence', qw2('generaltype_id brand_id')); $mine->addHolder('detail_full_sequence', qw2('generaltype_id brand_id generaltype_name brand_name')); $mineItem = array(); foreach (qw2('generaltype_id brand_id') as $field) { $mineItem[] = "a.{$field}=b.{$field}"; } $mine->addHolder('detail_a_b_full_comparing_sequence', $mineItem); }