public function createTercerosOp(Gyuser_Model_Operations $obj, $chequesList = null) { try { //1. create operation $data = array('type' => 2, 'client_id' => $obj->getClient_id(), 'date' => $obj->getDate(), 'amount' => $obj->getAmount(), 'state_order_id' => 2, 'tasa_porcentual' => $obj->getTasa_porcentual(), 'date_added' => date('Y-m-d H:i:s')); $opId = $this->getDbTable()->insert($data); if (!$opId) { throw Exception("Hubo un error al crear la operación de cheques de terceros."); } //2. insert checks $chequesMapper = new Gyuser_Model_ChequesDataMapper(); $chequesMapper->addChequesTerceros($opId, $chequesList); //3. set client to active $clientMapper = new Gyuser_Model_UserDataMapper(); $clientObj = new Gyuser_Model_User(); $clientObj->setId($obj->getClient_id()); $clientObj->setClient_type(3); //active $clientMapper->UpdateUserType($clientObj); return $opId; //********************************************************************** /* $cheques = new Gyuser_Model_Cheques(); $cheques->setOperation_id($obj->getId()); $cheques->setCheques_list($chequesList); $mapper = new Gyuser_Model_OperationsDataMapper(); $arc_hrs = $mapper->GetAcreditacionHrsByOperationId($obj); $result = $chequesMapper->SaveCheques($cheques); $iMapper = new Gyuser_Model_InterestsDataMapper(); $interests = new Gyuser_Model_Interests(); $interests = $iMapper->getInterestRate($obj->getInterests_id()); $data = array( 'state_order_id' => $obj->getState(), 'amount' => $obj->getAmount(), 'plan_id' => $obj->getPlan_id(), 'interests_id' => $obj->getInterests_id(), 'tasa_porcentual' => $interests->getRate() ); */ /* $id = (int) $obj->getId(); if (!$id) { unset($data['id']); } else { $id = $this->getDbTable()->update($data, array('id = ?' => $id)); return $id; } * */ } catch (Exception $e) { } }
public function operationsformajaxAction() { try { $this->_helper->layout->disableLayout(); $this->_helper->viewRenderer->setNoRender(); $request = $this->getRequest(); if ($this->getRequest()->isPost()) { $mapper = new Gyuser_Model_OperationsDataMapper(); $Obj = new Gyuser_Model_Operations(); $Obj->setClient_id($request->client_id); date_default_timezone_set('Europe/Vienna'); list($Day, $Month, $Year) = explode('/', $request->date); $stampeddate = mktime(12, 0, 0, $Month, $Day, $Year); $realDate = date("Y-m-d", $stampeddate); $Obj->setDate($realDate); $Obj->setAmount($request->amount); $Obj->setState($request->state); $Obj->setObservations($request->observations); $Obj->setCave_id($request->cave); $Obj->setBank_account_id($request->bank_account_id); if ($request->id) { $Obj->setId($request->id); } $id = $mapper->save($Obj); if ($id) { //set client type to active $clientMapper = new Gyuser_Model_UserDataMapper(); $clientObj = new Gyuser_Model_User(); $clientObj->setId($request->client_id); $clientObj->setClient_type(3); //active $clientMapper->UpdateUserType($clientObj); echo $id; } else { echo "f"; } } } catch (Exception $e) { echo $e; } }
public function RejectChequeWithGastos(Gyuser_Model_Cheques $obj) { try { $chequeDetails = $this->FindWithOperationNames($obj); $amount = (int) $this->GetAmounByChequeId($obj); $gastos = (int) $obj->getRejected_gastos(); $gastos_type = $obj->getRejected_type(); $rejectedCostProv = 'null'; if ($chequeDetails->getLiquidacion_id()) { //the cheque has been passed to a provider $provMapper = new Gyuser_Model_ProvidersDataMapper(); $prov = $provMapper->GetProviderByIdSimple($chequeDetails->getProvider_id()); if ($gastos_type == "Denuncia") { $rejectedCostProv = $prov->getGastos_denuncia(); } elseif ($gastos_type == "Sin Fondos") { $rejectedCostProv = $prov->getGastos_rechazo(); } /* if ($chequeDetails->getCave_id()) { //the cave id property checks the provider_id field on DB, if it's not null then it's from a provider. $supMapper = new Gyuser_Model_SupplierOperationsDataMapper(); $supObj = new Gyuser_Model_SupplierOperations(); $supObj->setId($chequeDetails->getCave_id()); $supList = $supMapper->GetCaveById($supObj); //looks for provider id (not cave) if ($gastos_type == "Denuncia") $rejectedCostProv = $supList->getGastos_denuncia(); elseif ($gastos_type == "Sin Fondos") $rejectedCostProv = $supList->getGastos_rechazo(); } else { //it's from lavalle $caveMapper = new Gyuser_Model_OtherCavesDataMapper(); $caves = new Gyuser_Model_OtherCaves(); $caves->setId('1'); //lavalle $lavalle = $caveMapper->GetCaveById($caves); $x = 1; if ($gastos_type == "Denuncia") { $x = 1; $rejectedCostProv = $lavalle->getGastos_denuncia(); } elseif ($gastos_type == "Sin Fondos") { $rejectedCostProv = $lavalle->getGastos_rechazo(); } } * */ } $amount = $amount + $gastos; $data = array('status' => 3, 'balance' => $amount, 'rejected_cost' => $gastos, 'rejected_type' => $gastos_type, 'rejected_cost_prov' => $rejectedCostProv); $success = $this->getDbTable()->update($data, array('id = ?' => $obj->getId())); if ($success) { $opId = $this->GetChequeOpId($obj->getId()); //update op status to 11 = 'En Cobranza' $opMapper = new Gyuser_Model_OperationsDataMapper(); $opMapper->setOperationEnCobranza($opId); $clientMapper = new Gyuser_Model_UserDataMapper(); $clientId = $clientMapper->getClientByChequeId($obj->getId()); if ($clientId) { $client = new Gyuser_Model_User(); $client->setId($clientId); $client->setClient_type(4); $clientMapper->UpdateUserType($client); } else { throw new Exception('The cheque status was updated to rejected but the client type could not be updated (to 4 = cobranza)'); } //$chequeDetails = $this->FindWithOperationNames($obj); $mapper = new Gyuser_Model_NotificationsDataMapper(); $obj = new Gyuser_Model_Notifications(); $obj->setTitle('Cheque rechazado'); $Operation_id = $chequeDetails->getOperation_id(); $check_n = $chequeDetails->getCheck_n(); $check_date = $chequeDetails->getDate(); $operator_id = $request->operator_id; $obj->setOperator_id($Operation_id); $obj->setComment("El cheque {$check_n} con fecha {$check_date} op.{$Operation_id} fue rechazado por {$gastos_type}"); $obj->setAction_date(date('Y-m-d h:i:s')); $result = $mapper->SaveWhenRejected($obj); } else { throw new Exception('There was an error updating the cheques table'); } return $result; } catch (Exception $e) { echo $e; } }
public function findClient(Gyuser_Model_User $obj) { /*$table = $this->getDbTable(); $row = $table->fetchRow( $table->select() ->join(array('client_types' => 'CT'),'clients.client_type = CT.id') ->where('id = ?', $obj->getId()) );*/ /* * TRY THIS * $select->from(array('opr' => 'operations'), array('*')); $select->joinLeft(array('ocvs' => 'other_caves'), 'opr.cave_id = ocvs.id', array('name as cave_name')); */ $db = Zend_Db_Table::getDefaultAdapter(); $stmt = $db->query("SELECT C.*, CT.name AS client_type_name FROM clients C JOIN client_types CT on C.client_type = CT.id WHERE C.id =" . $obj->getId()); $rows = $stmt->fetchAll(); if ($rows) { $row = $rows[0]; $CUIL = $row['CUIL']; if ($CUIL) { $CUIL1 = substr($CUIL, 0, 2); $CUIL2 = substr($CUIL, 2, 8); $CUIL3 = substr($CUIL, 10, 1); $CUIL = $CUIL1 . '-' . $CUIL2 . '-' . $CUIL3; } $tel_cell = $this->LandPhoneFormat($row['tel_cell']); $tel_otro = $this->LandPhoneFormat($row['tel_otro']); $tel_lab = $this->LandPhoneFormat($row['tel_lab']); $tel_part = $this->LandPhoneFormat($row['tel_part']); //$tel_cell_code = $this->CellPhoneAreaCodeFormat($row['tel_cell_code']; $tel_otro_code = $this->areaCodeOut($row['tel_otro_code, $tel_otro']); $tel_lab_code = $this->areaCodeOut($row['tel_lab_code, $tel_lab']); $tel_part_code = $this->areaCodeOut($row['tel_part_code, $tel_part']); $entry = new Gyuser_Model_User(); $entry->setId($row['id']); $entry->setClient_type($row['client_type']); //$entry->setClient_type_name($row['client_type_name']); $entry->setFirst_name($row['first_name']); $entry->setLast_name($row['last_name']); $entry->setDNI($row['DNI']); $entry->setCUIL($CUIL); $entry->setTel_cell($tel_cell); $entry->setTel_lab($tel_lab); $entry->setTel_otro($tel_otro); $entry->setTel_part($tel_part); //$entry->setTel_cell_code($tel_cell_code']); $entry->setTel_lab_code($tel_lab_code); $entry->setTel_otro_code($tel_otro_code); $entry->setTel_part_code($tel_part_code); $entry->setEmail($row['email']); $entry->setActivity($row['activity']); $entry->setDate_added(date("d/m/Y", strtotime($row['date_added']))); $entry->setOperator($row['operator']); $entry->setContact_point($row['contact_point']); $entry->setExtra_info($row['extra_info']); $entry->setBusiness($row['business']); $entry->setBusiness_CUIT($row['business_CUIT']); $entry->setType_change($row['type_change']); } return $entry; }