| 22 | | $c = new Criteria(); |
|---|
| 23 | | $c->clearSelectColumns(); |
|---|
| 24 | | $c->addSelectColumn('SUM('.Lease_eventPeer::AMOUNT.')'); |
|---|
| 25 | | $c->addAsColumn('total','SUM(IF(STRCMP('.Lease_eventPeer::TYPE_ID.',1),-'.Lease_eventPeer::AMOUNT.','.Lease_eventPeer::AMOUNT.'))'); |
|---|
| 26 | | // du même bail |
|---|
| 27 | | $c->add(Lease_eventPeer::LEASE_ID, $this->getRequestParameter('lease_id')); |
|---|
| 28 | | // uniquement appels et encaissements |
|---|
| 29 | | $c->add(Lease_eventPeer::TYPE_ID, array(1,2,9), Criteria::IN); |
|---|
| 30 | | $rs = Lease_eventPeer::doSelectRS($c); |
|---|
| 31 | | $rs->next(); |
|---|
| 32 | | $this->lease_reminder->setAmount($rs->get(2)); |
|---|
| | 22 | $lease = LeasePeer::retrieveByPK($this->getRequestParameter('lease_id')); |
|---|
| | 23 | $this->lease_reminder->setAmount($lease->getLesseeSolde()); |
|---|
