PHP DataObject::getAll方法代码示例

 function getRefByType($type)
 {
     $select = parent::getAll(null, false);
     $select->where('R_TypeRef = ?', $type);
     $result = $this->_db->fetchAll($select);
     return $result;
 }

 public static function usedBy($search_data = null, &$errors = array(), $defaults = null, $params = array())
 {
     $search = new SelectorItemSearch($defaults);
     $search->addSearchField('target_id', 'Target', 'hidden', '', 'hidden');
     // Search by Product
     $config = SelectorCollection::getTypeDetails($params['type']);
     $search->addSearchField('parent_id', implode('/', $config['itemFields']), 'treesearch', -1, 'basic');
     if (empty($search_data)) {
         $search_data = null;
     }
     $search->setSearchData($search_data, $errors, 'selectProduct');
     // Populate the parent_id field using the last selected value
     // it will be -1 if no previous selected value
     $parent_id = $search->getValue('parent_id');
     $cc = new ConstraintChain();
     if ($parent_id != '-1') {
         $cc->add(new Constraint('parent_id', '=', $parent_id));
     } else {
         $cc->add(new Constraint('parent_id', 'IS', 'NULL'));
     }
     $model = new DataObject('so_product_selector');
     $options = array($parent_id => 'Select an option');
     $options += $model->getAll($cc);
     $search->setOptions('parent_id', $options);
     if ($parent_id != '-1') {
         $data = array('target_id' => $search->getValue('target_id'));
         $search->setBreadcrumbs('parent_id', $model, 'parent_id', $parent_id, 'name', 'description', $data);
     }
     return $search;
 }

 /**
  * Fetches data of the files to import and filter according to the file type
  *
  * @param int    $langId Language id
  * @param string $type   Value defining the section where files are used.
  *
  * @return array
  */
 public function getAllByType($langId, $type = null)
 {
     $select = parent::getAll($langId, false);
     if (!is_null($type)) {
         $select->where('FI_Type = ?', $type);
     }
     return $select;
 }

 public function getData($langId = null, $bannerId = null)
 {
     $select = parent::getAll($langId, false);
     $select->order('IF_ImgID ASC');
     if ($bannerId) {
         $select->where('IF_DataID = ?', $bannerId);
     }
     $data = $this->_db->fetchAll($select);
     return $data;
 }

 public function getVideosList()
 {
     $select = parent::getAll(null, false);
     $select->where('VI_LanguageID = ?', Cible_Controller_Action::getDefaultEditLanguage());
     $select->order('V_Alias ASC');
     //echo $select;
     //  exit;
     $data = $this->_db->fetchAll($select);
     return $data;
 }

 public function getData($langId = null, $bannerId = null)
 {
     $select = parent::getAll($langId, false);
     $select->order('IF_ImgID ASC');
     $select->join('Videos', 'Videos.V_ID = IFI_Video');
     $select->join('VideosIndex', 'Videos.V_ID = VideosIndex.VI_ID');
     $select->where('VI_LanguageID = ?', $langId);
     if ($bannerId) {
         $select->where('IF_DataID = ?', $bannerId);
     }
     // echo $select;
     $data = $this->_db->fetchAll($select);
     return $data;
 }

 public static function selectProduct($search_data = null, &$errors = array(), $defaults = null)
 {
     $search = new sordersSearch($defaults);
     // Search by Customer
     $customer = DataObjectFactory::Factory('SLCustomer');
     $customers = $customer->getAll(null, false, true, '', '');
     $options = array('NULL' => 'None');
     $options += $customers;
     if (!isset($search->defaults['slmaster_id'])) {
         $search->defaults['slmaster_id'] = key($options);
     }
     $search->addSearchField('slmaster_id', 'Customer', 'select', $search->defaults['slmaster_id'], 'basic');
     $search->setOptions('slmaster_id', $options);
     // Search by Product Group
     $prod_group = DataObjectFactory::Factory('STProductgroup');
     $prod_group_list = $prod_group->getAll();
     $search->addSearchField('prod_group_id', 'Product Group', 'select', '', 'basic');
     $options = array('' => 'None');
     $options += $prod_group_list;
     $search->setOptions('prod_group_id', $options);
     // Search by Description
     $search->addSearchField('description', 'description contains', 'contains', '', 'basic');
     // Search by Product
     $config = SelectorCollection::getTypeDetails('sales_order');
     $search->addSearchField('parent_id', implode('/', $config['itemFields']), 'treesearch', -1, 'basic');
     if (empty($search_data)) {
         $search_data = null;
     }
     $search->setSearchData($search_data, $errors, 'selectProduct');
     // Populate the parent_id field using the last selected value
     // it will be -1 if no previous selected value
     $parent_id = $search->getValue('parent_id');
     $cc = new ConstraintChain();
     if ($parent_id != '-1') {
         $cc->add(new Constraint('parent_id', '=', $parent_id));
     } else {
         $cc->add(new Constraint('parent_id', 'IS', 'NULL'));
     }
     $model = new DataObject('so_product_selector');
     $options = array($parent_id => 'Select an option');
     $options += $model->getAll($cc);
     $search->setOptions('parent_id', $options);
     if ($parent_id != '-1') {
         $data = array('slmaster_id' => $search->getValue('slmaster_id'));
         $search->setBreadcrumbs('parent_id', $model, 'parent_id', $parent_id, 'name', 'description', $data);
     }
     return $search;
 }

 function getAll(ConstraintChain $cc = null, $ignore_tree = FALSE, $use_collection = FALSE, $limit = '')
 {
     return parent::getAll($cc, $ignore_tree, TRUE, $limit);
 }

 public function getAll(ConstraintChain $cc = null, $ignore_tree = false, $use_collection = false, $limit = '')
 {
     return parent::getAll($cc, $ignore_tree, true, $limit);
 }

 /**
  * Set filters for search by keywords.
  *
  * @param Zend_Db_Select $select The begining of the query to complete.
  *
  * @return void
  */
 public function autocompleteSearch($value, $langId = 1)
 {
     $select = parent::getAll($langId, false);
     //        $select->where('P_Type = ?', 'catalog');
     $this->keywordExist(array($value), $select, $langId);
     $products = $this->_db->fetchAll($select);
     return $products;
 }

// | checknum    | varchar(25)  |      |     |            |                |
// +-------------+--------------+------+-----+------------+----------------+
// mysql> desc expense_import;
// +------------------+--------------+------+-----+------------+----------------+
// | Field            | Type         | Null | Key | Default    | Extra          |
// +------------------+--------------+------+-----+------------+----------------+
// | idexpense_import | int(10)      |      | PRI | NULL       | auto_increment |
// | category         | varchar(60)  |      |     |            |                |
// | debit_date       | date         |      |     | 0000-00-00 |                |
// | description      | varchar(250) |      |     |            |                |
// | payment_method   | varchar(60)  |      |     |            |                |
// | amount           | float(10,2)  |      |     | 0.00       |                |
// +------------------+--------------+------+-----+------------+----------------+
$do_import_expense = new DataObject($this->getDbCon());
$do_import_expense->setTable("expense_import");
$do_import_expense->getAll();
$do_expense = new DataObject($this->getDbCon());
$do_expense->setTable("expense");
while ($do_import_expense->next()) {
    $category = 0;
    $suplier = 0;
    if ($do_import_expense->category == "Airlines / Transportation") {
        $category = 10;
    }
    if ($do_import_expense->category == "ATM Withdrawals") {
        $category = 46;
    }
    if ($do_import_expense->category == "Auto / Gas") {
        $category = 8;
    }
    if ($do_import_expense->category == "Building Supply / Wholesale") {

 static function copyItems($_data = '', &$errors = array())
 {
     if (empty($_data['tablename'])) {
         $errors[] = 'No table name provided';
     }
     if (empty($_data['from_item_id'])) {
         $errors[] = 'From item not provided';
     }
     if (empty($_data['to_item_id'])) {
         $errors[] = 'To item not provided';
     }
     if (count($errors) > 0) {
         return false;
     }
     $do = new DataObject($_data['tablename']);
     $do->identifierField = 'target_id';
     $cc = new ConstraintChain();
     $cc->add(new Constraint('item_id', '=', $_data['from_item_id']));
     $copyitems = $do->getAll($cc);
     foreach ($copyitems as $target_id) {
         $link_data[] = array('item_id' => $_data['to_item_id'], 'target_id' => $target_id);
     }
     return self::saveAssociations($link_data, $_data['tablename'], $errors);
 }

 public function getAll(ConstraintChain $cc = null, $ignore_tree = false, $use_collection = true, $limit = '', $active = true)
 {
     if (!$cc instanceof ConstraintChain) {
         $cc = new ConstraintChain();
     }
     if ($active === TRUE) {
         $cc->add(new Constraint('date_inactive', 'IS', 'NULL'));
     } elseif ($active === FALSE) {
         $cc->add(new Constraint('date_inactive', 'IS NOT', 'NULL'));
     }
     return parent::getAll($cc, $ignore_tree, TRUE, $limit);
 }

 /**
  * @see DataObject::getAll()
  *
  * @param type $langId
  * @param type $array
  * @param type $id
  *
  * @return Zend_Db_Select
  */
 public function getAll($langId = null, $array = true, $id = null)
 {
     $select = parent::getAll($langId, $array, $id);
     if ($select instanceof Zend_Db_Select && $this->_moduleId > 0) {
         $select->where('L_ModuleID = ?', $this->_moduleId);
     }
     return $select;
 }

 public function print_component_list($status = 'generate')
 {
     // build options array
     $options = array('type' => array('pdf' => '', 'xml' => ''), 'output' => array('print' => '', 'save' => '', 'email' => '', 'view' => ''), 'filename' => 'Component_list_' . fix_date(date(DATE_FORMAT)), 'report' => 'selector_components');
     // simply return the options if we're only at the dialog stage
     if (strtolower($status) === "dialog") {
         return $options;
     }
     $errors = array();
     $messages = array();
     if (!isset($this->_data) || !$this->loadData()) {
         // we are viewing data, but either no id has been provided
         // or the data for the supplied id does not exist
         $this->dataError();
         sendBack();
     }
     $current = $this->_uses[$this->modeltype];
     $parent = $this->getHierarchy($current->parent_id, $current->description);
     $title_template = '<fo:table-row>' . "\r\n";
     $title_template .= '	<fo:table-cell padding="1mm" width="%s" text-align="%s">' . "\r\n";
     $title_template .= '    	<fo:block >%s</fo:block>' . "\r\n";
     $title_template .= '	</fo:table-cell>' . "\r\n";
     $title_template .= '	<fo:table-cell padding="1mm" text-align="%s" >' . "\r\n";
     $title_template .= '    	<fo:block font-weight="bold">%s</fo:block>' . "\r\n";
     $title_template .= '	</fo:table-cell>' . "\r\n";
     $title_template .= '</fo:table-row>' . "\r\n";
     // load the model
     $link = new DataObject($this->linkTableName);
     $link->idField = $link->identifierField = 'target_id';
     $cc = new ConstraintChain();
     $cc->add(new Constraint('item_id', '=', $current->id));
     $selected_ids = $link->getAll($cc);
     $selectorobjects = $this->getComponents($selected_ids);
     $width = strlen($current->description);
     foreach ($parent as $item_detail) {
         $width = strlen($item_detail['description']) > $width ? strlen($item_detail['description']) : $width;
     }
     $item_list = '';
     foreach (array_reverse($parent) as $item_detail) {
         $item_list .= sprintf($title_template, $width * 2 . 'mm', 'left', prettify($item_detail['description']), 'left', $item_detail['name']);
     }
     $item_list .= sprintf($title_template, $width * 2 . 'mm', 'left', prettify($current->description), 'left', $current->name);
     $headings = $selectorobjects->getheadings();
     $targetHeadings = array();
     foreach ($this->targetFields as $key => $field) {
         if (isset($headings[$field])) {
             $targetHeadings[$field] = $headings[$field];
         }
     }
     $report_title = 'List of Component ' . (empty($title) ? prettify($this->getPageName('', '')) : 'items') . ' for Item, Printed on ' . date(DATE_TIME_FORMAT);
     // build the custom XSL
     $xsl = $this->build_custom_xsl($selectorobjects, 'selector_components', $report_title, $targetHeadings, '', array());
     if ($xsl === FALSE) {
         return FALSE;
     }
     $xsl = $this->process_xsl($xsl, array('ITEM_LIST' => $item_list));
     $options['xslSource'] = $xsl;
     $options['xmlSource'] = $this->generate_xml(array('model' => $selectorobjects, 'extra' => $extra, 'load_relationships' => FALSE));
     // execute the print output function, echo the returned json for jquery
     echo $this->generate_output($this->_data['print'], $options);
     exit;
 }