public function indexAction() { try { $cMapper = new Gyuser_Model_ClientTypesDataMapper(); $cList = $cMapper->fetchAll(); $adminObj = new Gyuser_Model_Admin(); $adminObj->setId(1); $adminMapper = new Gyuser_Model_AdminDataMapper(); $adminObj = $adminMapper->find($adminObj); $userType = new Gyuser_Model_UserType(); $this->view->admin = $adminObj; $this->view->authDetail = $this->authDetail; } catch (Exception $e) { echo $e; } }
public function addChequesTerceros($opId, $chequesListJson) { try { //$chequesList = utf8_encode($chequesList);//html_entity_decode($chequesList); $chequesList = json_decode($chequesListJson); $chequesFlag = false; $adminMapper = new Gyuser_Model_AdminDataMapper(); $adminSettings = $adminMapper->getAdminSettings(); foreach ($chequesList as $cheque) { unset($clientId); unset($bankId); unset($chequeId); //1. add client $clientMapper = new Gyuser_Model_UserDataMapper(); $client = new Gyuser_Model_User(); $client->setFirst_name($cheque->first_name); $client->setLast_name($cheque->last_name); $client->setDNI($cheque->DNI); $client->setCUIL($cheque->CUIL); $clientId = $clientMapper->createTerceroClient($client); if (!$clientId) { throw Exception('Error creating cheque tercero client on DB'); } //2. add bank account $bankMapper = new Gyuser_Model_BankAccountsDataMapper(); $bank = new Gyuser_Model_BankAccounts(); $bank->setUser_id($clientId); $bank->setBank_name($cheque->bank_name); $bank->setAccount_n($cheque->account_n); $bank->setBranch($cheque->branch); $bank->setZip_code($cheque->zip_code); $bank->setLocation_capital($cheque->location_capital); $bank->setOpening_date($cheque->account_date); $bankId = $bankMapper->save($bank); if (!$bankId) { throw Exception('Error inserting bank account for cheque tercero on DB'); } //3. add cheque list($Day, $Month, $Year) = explode('/', $cheque->check_date); $stampeddate = mktime(12, 0, 0, $Month, $Day, $Year); $date = date("Y-m-d", $stampeddate); $amount = floatval($cheque->check_amount); if ($cheque->location_capital == '1') { $acreditacionHrs = $adminSettings->getTiempo_ac_capital(); } else { $acreditacionHrs = $adminSettings->getTiempo_ac_interior(); } $data = array('operation_id' => $opId, 'client_id' => $clientId, 'bank_account_id' => $bankId, 'date' => $date, 'check_n' => $cheque->check_n, 'amount' => $amount, 'acreditacion_hrs' => $acreditacionHrs, 'local' => 1, 'status' => 6); $chequeId = $this->getDbTable()->insert($data); if (!$chequeId) { throw Exception('Error inserting cheque tercero on DB'); } } return $opId; } catch (Exception $e) { } }
public function createtercerosopajaxAction() { try { $this->_helper->layout->disableLayout(); $this->_helper->viewRenderer->setNoRender(); $request = $this->getRequest(); if ($this->getRequest()->isPost()) { //1. create operation $mapper = new Gyuser_Model_OperationsDataMapper(); $Obj = new Gyuser_Model_Operations(); $Obj->setClient_id($request->client_id); //format date to yyyy-mm-dd 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->total_amount); $Obj->setTasa_porcentual($request->tasa_anual); /* $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); * */ $chequesList = $request->cheques_list; $opId = $mapper->createTercerosOp($Obj, $chequesList); $mapper = new Gyuser_Model_AdminDataMapper(); $mapper->sendPedidoInformesOpTerceros($opId); if (!$opId) { throw Exception("Hubo un error al crear la operación de cheques de terceros."); } echo $opId; // return op id so that it counts as success } else { throw Exception("Hubo un error al enviar el formulario."); } } catch (Exception $e) { echo $e; } }
public function GetAcreditacionHrsByOperationId(Gyuser_Model_Operations $obj) { $arc_hrs = 0; $table = $this->getDbTable(); $select = $table->select(); $select->setIntegrityCheck(false); $select->from(array('ops' => 'operations'), array('id', 'bank_account_id')); $select->joinInner(array('bks' => 'bank_accounts'), 'ops.bank_account_id = bks.id', array('location_capital')); $select->where('ops.id = ?', $obj->getId()); $row = $table->fetchRow($select); $location_capital = $row->location_capital; $adminMapper = new Gyuser_Model_AdminDataMapper(); $adminObj = new Gyuser_Model_Admin(); $adminObj->setId(1); $adminObj = $adminMapper->find($adminObj); if ($location_capital == 1) { $arc_hrs = $adminObj->getTiempo_ac_capital(); } else { if ($location_capital == 2) { $arc_hrs = $adminObj->getTiempo_ac_interior(); } } return $arc_hrs; }