Example #1
0
 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';
     }
 }