So, I needed to update a magento adminhtml grid.\u00a0 I took a look at the database and it seemed pretty simple.\u00a0 There is a table with all of the main information, and a history table that is referenced when an addHistory function is called on the collection.<\/p>\n
The old add history function looked like this.<\/p>\n
[sourcecode language=”php”]
\npublic function addHistory()
\n {
\n if ($this->_hasHistory) {
\n return $this;
\n }
\n $this->_hasHistory = true;
\n\t$this->getSelect()->join(array(‘h’=>$this->getTable(‘ugiftcert\/history’)), ‘h.cert_id=main_table.cert_id’, array(‘ts’, ‘amount’, ‘customer_id’, ‘customer_email’, ‘order_id’, ‘order_increment_id’, ‘order_item_id’, ‘user_id’, ‘username’))
\n ->where("h.action_code=’create’");
\n return $this;
\n }
\n[\/sourcecode]<\/p>\n
The history table had action_code of create and update, and I needed to bring in the date for the update actions where they existed. Since updates always happen after create, I figured I could take the max of the ts column, which is the date column, where action code is create or update.<\/p>\n
I did some documentation searching and found several magento collection functions that kept throwing “method not found” errors including groupByAttribute to name one. I was close, but it wasn’t quite working right. Then after consulting a colleague, Joseph Piche, he noticed that it was not a magento collection object I was trying to change, but a Zend_Db object. I had the function mostly working, but couldn’t get the group by in my sql to work correctly. Turns out, the method I wanted was named simply “group.” With this information, the update became quite trivial and my final function looks like this:<\/p>\n
[sourcecode language=”php”]
\npublic function addHistory()
\n {
\n if ($this->_hasHistory) {
\n return $this;
\n }
\n $this->_hasHistory = true;
\n\t$this->getSelect()->join(array(‘h’=>$this->getTable(‘ugiftcert\/history’)), ‘h.cert_id=main_table.cert_id’, array(‘amount’, ‘customer_id’, ‘customer_email’, ‘order_id’, ‘order_increment_id’, ‘order_item_id’, ‘user_id’, ‘username’))
\n ->from(null, array(‘ts’ => ‘MAX(ts)’))
\n\t ->group(array(‘main_table.cert_id’))
\n ->where("h.action_code=’create’ or h.action_code=’update’");
\n return $this;
\n }
\n[\/sourcecode]<\/p>\n
Lesson learned: Know the object you’re trying to modify before using methods on it. A simple look at the class inheritance which shows:<\/p>\n
[sourcecode language=”php”]
\nclass Unirgy_GiftCert_Model_Mysql4_Cert_Collection extends Mage_Core_Model_Mysql4_Collection_Abstract
\n[\/sourcecode]<\/p>\n
and I would have known where to search for methods to make my life a lot easier while searching for the group by method.<\/p>\n","protected":false},"excerpt":{"rendered":"
So, I needed to update a magento adminhtml grid.\u00a0 I took a look at the database and it seemed pretty simple.\u00a0 There is a table with all of the main… Read more »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[28,22],"tags":[],"_links":{"self":[{"href":"https:\/\/www.evermoretechnologies.com\/blog\/wp-json\/wp\/v2\/posts\/70"}],"collection":[{"href":"https:\/\/www.evermoretechnologies.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.evermoretechnologies.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.evermoretechnologies.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.evermoretechnologies.com\/blog\/wp-json\/wp\/v2\/comments?post=70"}],"version-history":[{"count":0,"href":"https:\/\/www.evermoretechnologies.com\/blog\/wp-json\/wp\/v2\/posts\/70\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.evermoretechnologies.com\/blog\/wp-json\/wp\/v2\/media?parent=70"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.evermoretechnologies.com\/blog\/wp-json\/wp\/v2\/categories?post=70"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.evermoretechnologies.com\/blog\/wp-json\/wp\/v2\/tags?post=70"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}