public function GetCaveById(Gyuser_Model_OtherCaves $obj) { $table = $this->getDbTable(); $select = $table->select(); $select->setIntegrityCheck(false); $select->from(array('ocs' => 'other_caves'), array('id', 'name', 'email', 'balance', 'tasa_anual', 'impuesto_al_cheque', 'gastos_general', 'gastos_interior', 'gastos_denuncia', 'gastos_rechazo', 'acreditacion_capital', 'acreditacion_interior', 'gastos_menor_a_monto_1', 'gastos_menor_a_1', 'gastos_menor_a_monto_2', 'gastos_menor_a_2')); $select->joinLeft(array('ops' => 'operations'), 'ops.cave_id = ocs.id', array('cave_id', 'liquidacion_id')); $select->joinLeft(array('cqu' => 'cheques'), 'cqu.operation_id = ops.id ', array('sum(cqu.amount) as rej_amount', 'sum(cqu.rejected_cost) as rej_cost')); $select->where('cqu.status = ?', 3); $select->where('cqu.rejected_liquidacion_id is null'); $select->where('ocs.status = ?', true); $select->where('ocs.id = ?', $obj->getId()); $select->order('name ASC'); $row = $table->fetchRow($select); if ($row) { $entry = new Gyuser_Model_OtherCaves(); $entry->setId($row->id); $entry->setName($row->name); $entry->setEmail($row->email); $entry->setBalance($row->balance); $entry->setRej_check_amount(floatval($row->rej_amount) + floatval($row->rej_cost)); $entry->setTasa_anual($row->tasa_anual); $entry->setImpuesto_al_cheque($row->impuesto_al_cheque); $entry->setGastos_general($row->gastos_general); $entry->setGastos_interior($row->gastos_interior); $entry->setGastos_denuncia($row->gastos_denuncia); $entry->setGastos_rechazo($row->gastos_rechazo); $entry->setAcreditacion_capital($row->acreditacion_capital); $entry->setAcreditacion_interior($row->acreditacion_interior); $entry->setGastos_cheque_menor_a_1($row->gastos_menor_a_monto_1); $entry->setGastos_cheque_a_1($row->gastos_menor_a_1); $entry->setGastos_cheque_menor_a_2($row->gastos_menor_a_monto_2); $entry->setGastos_cheque_a_2($row->gastos_menor_a_2); $cMapper = new Gyuser_Model_ChequesDataMapper(); $cObj = new Gyuser_Model_Cheques(); $cObj->setStatus(4); $cObj->setCave_id($row->cave_id); if (@$row->cave_id) { $cAmount = $cMapper->GetTotalAmountByCave($cObj); $entry->setPassed_amount($cAmount); } return $entry; } else { return null; } }
public function getchequesbycaveidfilterajaxAction() { try { $request = $this->getRequest(); if ($this->getRequest()->isPost()) { $this->_helper->layout->disableLayout(); $this->_helper->viewRenderer->setNoRender(); $cave_id = (int) $request->cave_id; $pos = (int) $request->pos; $liqDate = $request->liqDate; if ($cave_id) { $cObj = new Gyuser_Model_Cheques(); $cObj->setCave_id($cave_id); $cMapper = new Gyuser_Model_ChequesDataMapper(); $result = $cMapper->GetChequeDetailsByCaveIdJson($cObj, $pos, $liqDate); if ($result) { echo json_encode($result); } else { echo 'f'; } } } } catch (Exception $e) { echo $e; } }
public function RejectedChequeByCaveId(Gyuser_Model_Cheques $obj) { $table = $this->getDbTable(); $select = $table->select(); $select->setIntegrityCheck(false); $select->from(array('cqu' => 'cheques'), array('id as cheque_id', 'operation_id', 'date as cheque_date', 'check_n', 'amount', 'local', 'liquidacion_id', 'status as cheque_status', 'credit_provider_id', 'rejected_cost', 'rejected_type')); $select->joinLeft(array('lqs' => 'liquidaciones'), 'lqs.id = cqu.liquidacion_id'); $select->joinLeft(array('ops' => 'operations'), 'cqu.operation_id = ops.id', array('client_id', 'bank_account_id')); $select->joinLeft(array('bas' => 'bank_accounts'), 'ops.bank_account_id = bas.id', array('bank_name')); $select->joinLeft(array('cls' => 'clients'), 'ops.client_id = cls.id', array('first_name', 'last_name')); $select->joinLeft(array('chqs' => 'cheques_status'), 'cqu.status = chqs.id', array('id as cheque_state_id', 'status_list')); $select->where('lqs.cave_id = ?', $obj->getCave_id()); $select->where('cqu.liquidacion_id IS NOT NULL'); $select->where('cqu.credit_provider_id IS NULL'); //passed to lavalle $select->where('cqu.rejected_liquidacion_id IS NULL'); $select->where('cqu.status = ?', 3); //$select->where('cqu.local = ?', 1); //$select->where('cqu.date <= ?', date("Y-m-d")); //$select->where('cqu.liquidacion_id IS NULL'); //$select->where('cqu.status = ?', ''); $select->order('cqu.id ASC'); $resultSet = $table->fetchAll($select); $entries = array(); foreach ($resultSet as $row) { $entry = new Gyuser_Model_Cheques(); $entry->setId($row->cheque_id); $entry->setOperation_id($row->operation_id); $entry->setDate(date("d/m/Y", strtotime($row->date))); $entry->setCheck_n($row->check_n); $entry->setAmount($row->amount); $entry->setStatus($row->cheque_status); $entry->setRejected_gastos($row->rejected_cost); $entry->setRejected_type($row->rejected_type); $entry->setLiquidacion_id($row->liquidacion_id); $entry->setCave_id($row->credit_provider_id); $clientObj = new Gyuser_Model_User(); $clientObj->setFirst_name($row->first_name); $clientObj->setLast_name($row->last_name); $entry->setClients_obj($clientObj); $cheques_state_obj = new Gyuser_Model_ChequesStatus(); $cheques_state_obj->setId($row->cheque_state_id); $cheques_state_obj->setStatus_list($row->status_list); $entry->setCheques_status_obj($cheques_state_obj); $_bank_accounts_obj = new Gyuser_Model_BankAccounts(); $_bank_accounts_obj->setBank_name($row->bank_name); $entry->setBank_accounts_obj($_bank_accounts_obj); $entries[] = $entry; } return $entries; }