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;
}
