public function consolidateAction() { try { $request = $this->getRequest(); if ($this->getRequest()->isPost()) { $lMapper = new Gyuser_Model_LiquidacionesDataMapper(); $pdlObj = new Gyuser_Model_Liquidaciones(); $liquidaciones_id = (int) $request->id; if ($liquidaciones_id) { $cMapper = new Gyuser_Model_ChequesDataMapper(); $cObj = new Gyuser_Model_Cheques(); $cObj->setLiquidacion_id($liquidaciones_id); $chequesList = $cMapper->UpdateLiquidacionDeleted($cObj); $cMapper = new Gyuser_Model_OperationsDataMapper(); $pObj = new Gyuser_Model_Operations(); $pObj->setLiquidacion_id($liquidaciones_id); $opertationsList = $cMapper->UpdateLiquidacionDeleted($pObj); } $pdlObj->setId($liquidaciones_id); $pdlObj->setDate($request->date); $pdlObj->setCurrent_account_balance($request->current_account_balance); $pdlObj->setAmount_payed($request->amount_payed); $pdlObj->setPrevious_account_balance(floatval($request->previous_account_balance)); $pdlObj->setProvider_id($request->provider_id); $pdlObj->setCheques_json($request->cheques_json); $pdlObj->setOperations_json($request->operations_json); $pdlObj->setRejected_cheques_json($request->rejected_cheques_json); $pdlObj->setAcreditacion($request->acreditacion); $pdlObj->setTasa_anual($request->tasa_anual); $pdlObj->setImpuesto_al_cheque($request->impuesto_al_cheque); $pdlObj->setAcreditacion_capital($request->acreditacion_capital); $pdlObj->setAcreditacion_interior($request->acreditacion_interior); $pdlObj->setGastos_general($request->gastos_general); $pdlObj->setGastos_interior($request->gastos_interior); if ($request->committed) { $pdlObj->setCommitted($request->committed); } $lMapper->consolidate($pdlObj); $this->_helper->redirector('index', 'liquidaciones', 'gyuser', array('cave_id' => $request->cave_id)); } } catch (Exception $e) { echo $e; } }
public function GetLiquidacionesByProvId($provider_id) { $table = $this->getDbTable(); $select = $table->select(); $select->from($table, array('id', 'date', 'previous_account_balance', 'amount_debt', 'acreditacion', 'amount_payed', 'current_account_balance', 'committed')); $select->where('status = ?', true); $select->where('provider_id = ?', $provider_id); $select->order('date DESC'); $resultSet = $table->fetchAll($select); $entries = array(); foreach ($resultSet as $row) { $entry = new Gyuser_Model_Liquidaciones(); $entry->setId($row->id); $entry->setDate(date("d/m/Y", strtotime($row->date))); $entry->setPrevious_account_balance($row->previous_account_balance); $entry->setAmount_debt($row->amount_debt); $entry->setAcreditacion($row->acreditacion); $entry->setAmount_payed($row->amount_payed); $entry->setCurrent_account_balance($row->current_account_balance); $entry->setCommitted($row->committed); $entries[] = $entry; } return $entries; }