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