public function savepaymentforrejectedchequeajaxAction()
{
try {
$this->_helper->layout->disableLayout();
$this->_helper->viewRenderer->setNoRender();
$request = $this->getRequest();
if ($this->getRequest()->isPost()) {
$paymentType = $request->payment_type;
switch ($paymentType) {
case 1:
$Obj = new Gyuser_Model_Cobranzas();
$Obj->setClient_id($request->client_id);
$Obj->setOperation_id($request->operation_id);
$Obj->setCheque_id($request->cheque_id);
$Obj->setDate_paid($request->date_paid);
$Obj->setPaid_amount($request->paid_amount);
$Obj->setPrevious_balance($request->previous_balance);
$Obj->setCurrent_balance($request->current_balance);
$Obj->setPayment_type($request->payment_type);
break;
case 2:
$Obj = new Gyuser_Model_Cobranzas();
$Obj->setClient_id($request->client_id);
$Obj->setOperation_id($request->operation_id);
$Obj->setCheque_id($request->cheque_id);
$Obj->setDate_paid($request->date_paid);
$Obj->setPaid_amount($request->paid_amount);
$Obj->setPrevious_balance($request->previous_balance);
$Obj->setCurrent_balance($request->current_balance);
$Obj->setPayment_type($request->payment_type);
$chqObj = new Gyuser_Model_Cheques();
$chqObj->setAmount($request->paid_amount);
$chqObj->setStatus(1);
$chqObj->setRejected_bank_id($request->rejected_bank_id);
$chqObj->setOperation_id($request->operation_id);
$chqObj->setClient_id($request->client_id);
$chqObj->setCheck_n($request->new_cheque_n);
$chqObj->setDate($request->cheque_date);
$chqObj->setRejected_check_payment(1);
$Obj->setCheques_obj($chqObj);
break;
case 3:
$Obj = new Gyuser_Model_Cobranzas();
$Obj->setClient_id($request->client_id);
$Obj->setOperation_id($request->operation_id);
$Obj->setCheque_id($request->cheque_id);
$Obj->setDate_paid($request->date_paid);
$Obj->setPaid_amount($request->paid_amount);
$Obj->setPrevious_balance($request->previous_balance);
$Obj->setCurrent_balance($request->current_balance);
$Obj->setPayment_type($request->payment_type);
$chqObj = new Gyuser_Model_Cheques();
$chqObj->setAmount($request->paid_amount);
$chqObj->setStatus(1);
$chqObj->setOperation_id($request->operation_id);
$chqObj->setClient_id($request->client_id);
$chqObj->setCheck_n($request->new_cheque_n);
$chqObj->setDate($request->cheque_date);
$chqObj->setRejected_check_payment(2);
$Obj->setCheques_obj($chqObj);
$bankObj = new Gyuser_Model_BankAccounts();
$bankObj->setUser_id($request->client_id);
$bankObj->setBank_name($request->bank_name);
$bankObj->setBranch($request->branch);
$bankObj->setAccount_n($request->account_n);
$bankObj->setOpening_date($request->opening_date);
$bankObj->setZip_code($request->check_zip_code);
$bankObj->setLocation_capital($request->location_capital);
$Obj->setBank_accounts_obj($bankObj);
break;
}
$mapper = new Gyuser_Model_CobranzasDataMapper();
$id = $mapper->SavePaymentForRejectedCheque($Obj);
echo $id;
}
} catch (Exception $e) {
echo $e;
}
}
public function CreatePDF(Gyuser_Model_User $obj, $typeid, $status, $operationid)
{
$clietid = $obj->getId();
$param = array();
if ($status) {
$param = array('compress' => 0, 'Attachment' => 0);
}
switch ($typeid) {
case 1:
$mapper = new Gyuser_Model_UserDataMapper();
$result = $mapper->ClientDetailsById($obj);
$fn = $result->getFirst_name();
$ln = $result->getLast_name();
$dni = $result->GetDNI();
$html = '<html><body>' . '<table style="font-size:30px;font-weight:bold;font-family:Helvetica,Arial;">' . '<tr>' . '<td>Nombre</td>' . '<td>: </td>' . "<td>{$fn}</td>" . '</tr>' . '<tr>' . '<td>Apellido</td>' . '<td>: </td>' . "<td>{$ln}</td>" . '</tr>' . '<tr>' . '<td>DNI</td>' . '<td>: </td>' . "<td>{$dni}</td>" . '</tr>' . '</table>' . '</body></html>';
$dompdf = new DOMPDF();
$dompdf->load_html($html);
$dompdf->render();
$dompdf->stream("Mutuo-1.pdf", $param);
break;
case 2:
$mapper = new Gyuser_Model_UserDataMapper();
$result = $mapper->ClientDetailsById($obj);
$fn = $result->getFirst_name();
$ln = $result->getLast_name();
$dni = $result->GetDNI();
$chequeObj = new Gyuser_Model_Cheques();
$chequeObj->setOperation_id($operationid);
$chequeMapper = new Gyuser_Model_ChequesDataMapper();
$chequesList = $chequeMapper->GetChequeDetailsByUserId($chequeObj);
$html = '<html>
<style>
.cheques{
width:100%;
border:1px solid #ccc;
}
.cheques td,.cheques th{
border:2px solid #ccc;
font-family:Helvetica,Arial;
padding:10px;
}
.cheques th{
font-size:20px;
font-weight:bold;
}
.h1Txt{
text-decoration:underline;
font-family:Helvetica,Arial;
}
</style>
<body>' . '<table style="font-size:30px;font-weight:bold;font-family:Helvetica,Arial;">' . '<tr>' . '<td>Nombre</td>' . '<td>: </td>' . "<td>{$fn}</td>" . '</tr>' . '<tr>' . '<td>Apellido</td>' . '<td>: </td>' . "<td>{$ln}</td>" . '</tr>' . '<tr>' . '<td>DNI</td>' . '<td>: </td>' . "<td>{$dni}</td>" . '</tr>' . '</table><br/><br/>';
if ($chequesList) {
$html .= '<table class="cheques"><tr><th>Fecha</th><th>Numero De Cheque</th><th>Importe</th></tr>';
foreach ($chequesList as $cheque) {
$html .= '<tr>';
$html .= '<td >' . $cheque['date'] . '</td>';
$html .= '<td >' . $cheque['check_n'] . '</td>';
$html .= '<td >' . $cheque['amount'] . '</td>';
$html .= '</tr>';
}
$html .= '</table>';
}
$html .= '</body></html>';
$dompdf = new DOMPDF();
$dompdf->load_html($html);
$dompdf->render();
$dompdf->stream("Mutuo-2.pdf", $param);
break;
case 3:
$mapper = new Gyuser_Model_UserDataMapper();
$result = $mapper->ClientDetailsById($obj);
$fn = $result->getFirst_name();
$ln = $result->getLast_name();
$dni = $result->GetDNI();
$telc = $result->getTel_cell_code() . ' ' . $result->getTel_cell();
$tell = $result->getTel_lab_code() . ' ' . $result->getTel_lab();
$telo = $result->getTel_otro_code() . ' ' . $result->getTel_otro();
$telp = $result->getTel_part_code() . ' ' . $result->getTel_part();
$chequeObj = new Gyuser_Model_Cheques();
$chequeObj->setOperation_id($operationid);
$chequeMapper = new Gyuser_Model_ChequesDataMapper();
$chequesList = $chequeMapper->GetChequeDetailsByUserId($chequeObj);
$addressMapper = new Gyuser_Model_AddressDataMapper();
$addressObj = new Gyuser_Model_Address();
$addressObj->setClient_id($clietid);
$address = $addressMapper->GetDeliveryAddressByClientId($addressObj);
$html = '<html>
<style>
.cheques{
width:100%;
border:1px solid #ccc;
}
.cheques td,.cheques th{
border:2px solid #ccc;
font-family:Helvetica,Arial;
padding:10px;
}
.cheques th{
font-size:20px;
font-weight:bold;
}
.address td{
font-family:Helvetica,Arial;
padding:10px;
font-size:20px;
}
</style>
<body>' . '<table style="font-size:30px;font-weight:bold;font-family:Helvetica,Arial;">' . '<tr>' . '<td>Nombre</td>' . '<td>: </td>' . "<td>{$fn}</td>" . '</tr>' . '<tr>' . '<td>Apellido</td>' . '<td>: </td>' . "<td>{$ln}</td>" . '</tr>' . '<tr>' . '<td>DNI</td>' . '<td>: </td>' . "<td>{$dni}</td>" . '</tr>' . '</table><br/><br/><h1 class="h1Txt">Cheques</h1>';
if ($chequesList) {
$html .= '<table class="cheques"><tr><th>Fecha</th><th>Numero De Cheque</th><th>Importe</th></tr>';
foreach ($chequesList as $cheque) {
$html .= '<tr>';
$html .= '<td >' . $cheque['date'] . '</td>';
$html .= '<td >' . $cheque['check_n'] . '</td>';
$html .= '<td >' . $cheque['amount'] . '</td>';
$html .= '</tr>';
}
$html .= '</table>';
}
$html .= '<br/><br/><h1 class="h1Txt">Domicilios</h1>';
if ($address) {
$str = '';
$jsonData = $address;
$id = $jsonData['id'];
$street = $jsonData['street'];
$city = $jsonData['city'];
$state = $jsonData['state'];
$state_name = $jsonData['state_name'];
$country = $jsonData['country'];
$html .= '<table class="address">' . '<tr>' . '<td width="100">Domicilio</td><td> : </td><td>' . $street . '</td>' . '</tr>' . '<tr>' . '<td>Barrio / Ciudad</td><td> : </td><td>' . $city . '</td>' . '</tr>' . '<tr>' . '<td>Provincia</td><td> : </td><td>' . $state_name . '</td>' . '</tr>' . '<tr>' . '<td>Tel�fono</td><td> : </td><td>' . $telc . '<br/>' . $tell . '<br/>' . $telo . '<br/>' . $telp . '<br/></td>' . '</tr>' . '</table>';
}
$html .= '</body></html>';
$dompdf = new DOMPDF();
$dompdf->load_html($html);
$dompdf->render();
$dompdf->stream("Mutuo-3.pdf", $param);
break;
default:
break;
}
}
public function RejectedChequeBySupplierId(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', 'rejected_cost', 'rejected_type', 'check_zip_code', 'credit_provider_id'));
$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('cqu.credit_provider_id = ?', $obj->getCredit_provider_id());
//$select->where('ops.liquidacion_id IS NOT NULL');
$select->where('cqu.status = ?', 3);
//$select->where('cqu.local = ?', 1);
//$select->where('cqu.date <= ?', date("Y-m-d"));
$select->where('cqu.rejected_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->cheque_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->setCheck_zip_code($row->check_zip_code);
$entry->setLiquidacion_id($row->liquidacion_id);
$entry->setCredit_provider_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;
}
public function OpTercerosStateChange($opId, $newStateId, $tasaAnual = null, $chequesListJson = null)
{
$success = 0;
$obj = new Gyuser_Model_Operations();
$obj->setId($opId);
$opResult = $this->GetStateByOperationId($obj);
$currentStateId = (int) $opResult['stateid'];
if ($currentStateId < $newStateId) {
switch ($newStateId) {
case 2:
$data = array('state_order_id' => $obj->getState(), 'cave_id' => $obj->getCave_id());
break;
case 3:
case 4:
$data = array('state_order_id' => $obj->getState(), 'report' => $obj->getReport());
break;
case 5:
//cerrada
$chequesMapper = new Gyuser_Model_ChequesDataMapper();
$informesCompletos = $chequesMapper->checkInformesCompletos($opId);
if ($informesCompletos) {
$data = array('state_order_id' => $newStateId);
}
break;
case 6:
//op. en camino
$opAmount = 0;
$opTodayVal = 0;
$adminMapper = new Gyuser_Model_AdminDataMapper();
$admin = $adminMapper->getAdminSettings();
$prov = new Gyuser_Model_Providers();
$prov->setAcreditacion_capital($admin->getTiempo_ac_capital());
$prov->setAcreditacion_interior($admin->getTiempo_ac_interior());
$prov->setGastos_general($admin->getGastos_general());
$prov->setGastos_interior($admin->getGastos_interior());
$prov->setImpuesto_al_cheque($admin->getImpuesto_al_cheque());
$prov->setTasa_anual($tasaAnual);
$chequesMapper = new Gyuser_Model_ChequesDataMapper();
$cheque = new Gyuser_Model_Cheques();
$cheques = $chequesMapper->GetChequesByOpId($opId);
//gets only cheques with status 7 (aprobados)
foreach ($cheques as $cheque) {
$cDetails = $chequesMapper->saveDetails($cheque->getId(), $prov);
$opAmount += $cDetails['amount'];
$opTodayVal += $cDetails['terceros_today_value'];
}
$data = array('amount' => $opAmount, 'amount_today' => $opTodayVal, 'ac_date' => date('Y-m-d'), 'tasa_porcentual' => $tasaAnual, 'state_order_id' => $newStateId);
break;
case 9:
//consolidated / cheques en cartera
$chequesList = json_decode($chequesListJson);
$chequesMapper = new Gyuser_Model_ChequesDataMapper();
$chequesTotals = $chequesMapper->consolidateCheques($chequesList);
$data = array('amount' => $chequesTotals['amount'], 'amount_today' => $chequesTotals['todayValue'], 'state_order_id' => $newStateId);
break;
case 99:
$chequesMapper = new Gyuser_Model_ChequesDataMapper();
$cheques = new Gyuser_Model_Cheques();
$cheques->setOperation_id($obj->getId());
$result = $chequesMapper->deleteByOperationId($cheques);
$data = array('state_order_id' => $obj->getState());
break;
default:
$data = array('state_order_id' => $obj->getState());
break;
}
if ($data) {
$id = (int) $obj->getId();
$id = $this->getDbTable()->update($data, array('id = ?' => $id));
}
$success = 1;
} elseif ($currentStateId >= $newStateId) {
//new state is smaller or equal to current state
$success = 2;
}
//2 = the state has already been changed.
return $success;
}
