/** * Method that retrieves one to many associated records * @param \Cake\ORM\Table $table Table object * @param \Cake\ORM\Association $association Association object * @return array associated records */ protected function _oneToManyAssociatedRecords(\Cake\ORM\Table $table, \Cake\ORM\Association $association) { $assocName = $association->name(); $assocTableName = $association->table(); $assocForeignKey = $association->foreignKey(); $recordId = $this->request->params['pass'][0]; // get associated index View csv fields $fields = $this->_getTableFields($association); $query = $table->{$assocName}->find('all', ['conditions' => [$assocForeignKey => $recordId], 'fields' => $fields]); $records = $query->all(); // store associated table records $result['records'] = $records; // store associated table fields $result['fields'] = $fields; // store associated table name $result['table_name'] = $assocTableName; return $result; }
/** * Method that retrieves one to many associated records * * @param \Cake\ORM\Association $association Association object * @param \Cake\Network\Request $request passed * @return array associated records */ protected function _oneToManyAssociatedRecords(Association $association, Request $request) { $result = []; $assocName = $association->name(); $assocTableName = $association->table(); $assocForeignKey = $association->foreignKey(); $recordId = $request->params['pass'][0]; $csvFields = $this->_getAssociationCsvFields($association, static::ASSOC_FIELDS_ACTION); if (empty($csvFields)) { return $result; } // get associated index View csv fields $fields = array_unique(array_merge([$association->displayField()], $csvFields)); $query = $this->_tableInstance->{$assocName}->find('all', ['conditions' => [$assocForeignKey => $recordId]]); $records = $query->all(); // store association name $result['assoc_name'] = $assocName; // store associated table name $result['table_name'] = $assocTableName; // store associated table class name $result['class_name'] = $association->className(); // store associated table display field $result['display_field'] = $association->displayField(); // store associated table primary key $result['primary_key'] = $association->primaryKey(); // store associated table foreign key $result['foreign_key'] = $association->foreignKey(); // store associated table fields $result['fields'] = $fields; // store associated table records $result['records'] = $records; return $result; }