public function cancelIlPayment($data){ $db = $this->getAdapter(); $db_loan = new Loan_Model_DbTable_DbLoanILPayment(); $db_group = new Loan_Model_DbTable_DbGroupPayment(); $db->beginTransaction(); $is_set = 0; try{ $id = $data["id"]; $recipt_money = $db_loan->getReceiptMoneyById($id); $recipt_money_detail = $db_loan->getReceiptMoneyDetailByID($id); foreach ($recipt_money_detail as $row_recipt_detail){ $fun_id = $row_recipt_detail["lfd_id"]; if($is_set!=1){ $loan_number = $row_recipt_detail["loan_number"]; $rs_fun = $db_group->getFunDetailByLoanNumber($loan_number); $rs_group = "SELECT m.group_id FROM ln_loan_member AS m WHERE m.loan_number = '$loan_number' GROUP BY m.loan_number"; $group_id = $db->fetchOne($rs_group); if(empty($rs_fun) or $rs_fun=="" or $rs_fun==null){ $arr_member = array( 'is_completed' => 0, ); $this->_name = "ln_loan_member"; $where = $db->quoteInto("loan_number=?", $loan_number); $db->getProfiler()->setEnabled(true); $this->update($arr_member, $where); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQuery()); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQueryParams()); $db->getProfiler()->setEnabled(false); $arr_group = array( 'status' => 1, ); $this->_name = "ln_loan_group"; $where = $db->quoteInto("g_id=?", $group_id); $db->getProfiler()->setEnabled(true); $this->update($arr_group, $where); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQuery()); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQueryParams()); $db->getProfiler()->setEnabled(false); } $is_set=1; } if($recipt_money["payment_option"]==1){ echo 1111; $is_completed = $db_loan->getFunDetailById($fun_id); if($is_completed==1){ $arr_update = array( 'is_completed' => 0, ); $this->_name = "ln_loanmember_funddetail"; $where = $db->quoteInto("id=?", $fun_id); $db->getProfiler()->setEnabled(true); $this->update($arr_update, $where); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQuery()); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQueryParams()); $db->getProfiler()->setEnabled(false); }else{ $arr_update = array( 'principle_after' => $row_recipt_detail["principal_permonth"], 'total_interest_after' => $row_recipt_detail["total_interest"], 'penelize' => $row_recipt_detail["penelize_amount"], 'service_charge' => $row_recipt_detail["service_charge"], 'total_payment_after' => $row_recipt_detail["total_payment"], 'is_completed' => 0, ); $this->_name = "ln_loanmember_funddetail"; $where = $db->quoteInto("id=?", $fun_id); $db->getProfiler()->setEnabled(true); $this->update($arr_update, $where); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQuery()); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQueryParams()); $db->getProfiler()->setEnabled(false); } }else{ $arr_update = array( 'is_completed' => 0, ); $this->_name = "ln_loanmember_funddetail"; $where = $db->quoteInto("id=?", $fun_id); $db->getProfiler()->setEnabled(true); $this->update($arr_update, $where); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQuery()); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQueryParams()); $db->getProfiler()->setEnabled(false); } } $sql = "DELETE FROM `ln_client_receipt_money` WHERE `id`=$id"; $db->getProfiler()->setEnabled(true); $db->query($sql); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQuery()); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQueryParams()); $db->getProfiler()->setEnabled(false); $sql_cmd = "DELETE FROM `ln_client_receipt_money_detail` WHERE `crm_id` = $id"; $db->getProfiler()->setEnabled(true); $db->query($sql_cmd); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQuery()); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQueryParams()); $db->getProfiler()->setEnabled(false); exit(); // $db->commit(); }catch (Exception $e){ $db->rollBack(); echo $e->getMessage(); } }
function cancelPaymnet($data){ $db = $this->getAdapter(); $db_recipt= new Loan_Model_DbTable_DbGroupPayment(); $db->beginTransaction(); try{ $id = $data["id"]; $loan_number = $data["old_loan_number"]; $sql_option = "SELECT cr.`payment_option`,cr.`recieve_amount`,cr.`total_payment` FROM `ln_client_receipt_money` AS cr WHERE cr.`id`=$id"; $rs = $db->fetchRow($sql_option); $rs_fun = $db_recipt->getFunDetailByLoanNumber($loan_number); $rs_recipt = $db_recipt->getReciptDetailById($id); print_r($rs_recipt); if($rs_fun=="" or $rs_fun==null){ $loan_number = $data["old_loan_number"]; $arr_member = array( 'is_completed' => 0, ); $this->_name = "ln_loan_member"; $where = $db->quoteInto("loan_number=?", $loan_number); $db->getProfiler()->setEnabled(true); $this->update($arr_member, $where); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQuery()); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQueryParams()); $db->getProfiler()->setEnabled(false); $sql_group = "SELECT m.`group_id` FROM `ln_loan_member` AS m WHERE m.`loan_number`='$loan_number' LIMIT 1"; $rs_group = $db->fetchOne($sql); $arr_group = array( 'status' => 1, ); $this->_name = "ln_loan_group"; $where = $db->quoteInto("g_id=?", $rs_group["group_id"]); $db->getProfiler()->setEnabled(true); $this->update($arr_group, $where); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQuery()); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQueryParams()); $db->getProfiler()->setEnabled(false); foreach ($rs_recipt as $row_recipt){ $arr_fun = array( 'is_completed' =>0, ); $this->_name="`ln_loanmember_funddetail`"; $where = $db->quoteInto("id=?", $row_recipt["lfd_id"]); $db->getProfiler()->setEnabled(true); $this->update($arr_fun, $where); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQuery()); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQueryParams()); $db->getProfiler()->setEnabled(false); } }else{ if($rs["payment_option"]==1){ foreach ($rs_recipt as $row_recipt){ $fun_id = $row_recipt['lfd_id']; $sql = "SELECT * FROM ln_loanmember_funddetail WHERE id= $fun_id"; $result_fun = $db->fetchAll($sql); // print_r($result_fun); $fun = $db_recipt->getFunHasPayedByLoanNumber($row_recipt["lfd_id"]); foreach ($result_fun as $result_row){ $fun_penelize = $result_row["penelize"]; $fun_service = $result_row["service_charge"]; if($fun["is_completed"]==0){ $total_pay = $row_recipt["total_payment"]; $total_recieve = $row_recipt["total_recieve"]; $principle = $row_recipt["principal_permonth"]; $interest = $row_recipt["total_interest"]; $penelize = $row_recipt["penelize_amount"]; $service =$row_recipt["service_charge"]; $new_recieve = $total_recieve-$service; if($new_recieve>0){ $old_service =0; $new_recieve = $new_recieve-$penelize; if($new_recieve>0){ $old_penelize =0; // $new_recieve = $new_recieve - $interest; // if($new_recieve>0){ // $old_interest = 0; // $new_recieve = $new_recieve - $penelize; // if($new_recieve>0){ // $old_principle = 0; // } // }else{ // $old_interest = abs($new_recieve); // } }else{ $old_penelize = abs($new_recieve); } }else{ $old_service = abs($new_recieve); } // $old_penelize = round($total_pay,2)-(round($principle,2)+round($interest,2)+round($penelize,2)); // $old_service = round($total_pay,2)-(round($principle,2)+round($interest,2)+round($penelize,2)); // echo $a= $principle+$penelize+$interest+$service; // echo $old_penelize."=".$total_pay."-".$principle."+".$interest."+".$service; $arr_fun = array( "principle_after" => $principle, 'total_interest_after' => $interest, 'penelize' => $fun_penelize-$old_penelize, 'service_charge' => $fun_service-$old_service, 'total_payment_after' => $principle+$interest+($fun_penelize-$old_penelize)+($fun_service-$old_service), ); $this->_name = "ln_loanmember_funddetail"; $where = $db->quoteInto("id=?", $row_recipt["lfd_id"]); $db->getProfiler()->setEnabled(true); $this->update($arr_fun, $where); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQuery()); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQueryParams()); $db->getProfiler()->setEnabled(false); // } }else{ foreach ($rs_recipt as $row_recipt){ $total_pay = $row_recipt["total_payment"]; $principle = $row_recipt["principal_permonth"]; $interest = $row_recipt["total_interest"]; $penelize = $row_recipt["penelize_amount"]; $service =$row_recipt["service_charge"]; $arr_fun = array( // "principle_after" => $principle, // 'total_interest_after' => $interest, // 'penelize' => $penelize, // 'service_charge' => $service, // 'total_payment_after' => $total_pay, 'is_completed' => 0, ); $this->_name = "ln_loanmember_funddetail"; $where = $db->quoteInto("id=?", $row_recipt["lfd_id"]); $db->getProfiler()->setEnabled(true); $this->update($arr_fun, $where); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQuery()); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQueryParams()); $db->getProfiler()->setEnabled(false); } } } } }else{ foreach ($rs_recipt as $row_recipt){ $arr_fun = array( 'is_completed' => 0, ); $this->_name="ln_loanmember_funddetail"; $where = $db->quoteInto("id=?", $row_recipt["lfd_id"]); $db->getProfiler()->setEnabled(true); $this->update($arr_fun, $where); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQuery()); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQueryParams()); $db->getProfiler()->setEnabled(false); } } } $sql = "DELETE FROM `ln_client_receipt_money` WHERE `id`=$id"; $db->getProfiler()->setEnabled(true); $db->query($sql); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQuery()); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQueryParams()); $db->getProfiler()->setEnabled(false); $sql_cmd = "DELETE FROM `ln_client_receipt_money_detail` WHERE `crm_id` = $id"; $db->getProfiler()->setEnabled(true); $db->query($sql_cmd); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQuery()); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQueryParams()); $db->getProfiler()->setEnabled(false); // exit(); $db->commit(); }catch (Exception $e){ $db->rollBack(); Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage()); } }