public function render(Varien_Object $row) { $id = $row->getdailydeals_id(); $coll = Mage::getModel('dailydeals/dailydeals')->load($id); $date_start = $coll->getdate_start(); $date_end = $coll->getdate_end(); $deal_status = $coll->getstatus(); $read = Mage::getSingleton('core/resource')->getConnection('core_read'); $write = Mage::getSingleton('core/resource')->getConnection('core_write'); $query = $read->fetchAll("SELECT TIMEDIFF( NOW( ) , '" . $date_start . "') AS diff"); $query1 = $read->fetchAll("SELECT TIMEDIFF('" . $date_end . "', NOW( )) AS diffend"); $compdate = $query[0]['diff']; $compdateend = $query1[0]['diffend']; if ($deal_status == 0) { $status = 'Disabled'; } elseif ($compdate < 0) { $status = 'Queued'; } elseif ($compdate >= 0 && $compdateend > 0) { $status = 'Running'; } elseif ($compdateend < 0) { $status = 'Ended'; } //$data['deal_status']=$status; //$model = Mage::getModel('dailydeals/dailydeals'); //$model->setData($data) //->setId(2); //$model->save(); return $status; }
public function render(Varien_Object $row) { $deal_id = $row->getdailydeals_id(); //$media=Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_MEDIA); //$file=$media.$value; $coll = Mage::getModel('dailydeals/dealviewer')->getCollection()->addFieldToFilter('deal_id', $deal_id)->getData(); $count = count($coll); if ($count != "") { return $count; } else { return '0'; } }