public static function showRecurrentIncomeDashboardbyDate($from = '', $to = '') { $resultInfo = array(); $idUser = Zend_Registry::get('user')->getId(); $expenses = new Default_Model_RecurrentExpenses(); $select = $expenses->getMapper()->getDbTable()->select()->from(array('p' => 'recurrent_expenses'), array('price' => 'SUM(p.price)'))->where('NOT p.deleted')->where('p.idMember = ? ', $idUser)->where('p.type=?', 1); if ($from != '') { $select->where('p.date>=?', date('Y-m-d', strtotime($from))); } if ($to != '') { $select->where('p.date<=?', date('Y-m-d', strtotime($to))); } $result = $expenses->fetchRow($select); $amount = $result->getPrice(); return $amount; }