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 updateGroupPayment($data){ $db = $this->getAdapter(); $db_loan = new Loan_Model_DbTable_DbLoanILPayment(); $db_group= new Loan_Model_DbTable_DbGroupPayment(); $db->beginTransaction(); $session_user=new Zend_Session_Namespace('auth'); $user_id = $session_user->user_id; $query = new Application_Model_DbTable_DbGlobal(); $id= $data["id"]; //$old_loannumber= $data["old_loan_number"]; $option_pay = $data["option_pay"]; $is_set=0; try{ $arr_client_pay = array( 'co_id' => $data['co_id'], 'group_id' => $data["client_code"], 'receiver_id' => $data['reciever'], 'branch_id' => $data['branch_id'], 'date_input' => $data["collect_date"], 'principal_amount' => $data["priciple_amount"], 'total_principal_permonth' => $data["os_amount"], 'total_payment' => $data["total_payment"], 'total_interest' => $data["total_interest"], 'recieve_amount' => $data["amount_receive"], 'penalize_amount' => $data['penalize_amount'], 'return_amount' => $data["amount_return"], 'service_charge' => $data["service_charge"], 'note' => $data['note'], 'user_id' => $user_id, 'is_group' => 1, 'payment_option' => 1, 'currency_type' => $data["currency_type"], 'status' => 1, 'amount_payment' => $data["amount_receive"]-$data["amount_return"], 'is_completed' => 1 ); $this->_name = "ln_client_receipt_money"; $where = $db->quoteInto("id=?", $id); $db->getProfiler()->setEnabled(true); $client_pay = $this->update($arr_client_pay, $where); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQuery()); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQueryParams()); $db->getProfiler()->setEnabled(false); $recipt_money = $db_loan->getReceiptMoneyById($id); $recipt_money_detail = $db_loan->getReceiptMoneyDetailByID($id); print_r($recipt_money_detail); 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){ $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_cmd = "DELETE FROM `ln_client_receipt_money_detail` WHERE `crm_id` = $id"; $db->query($sql_cmd); $identify = explode(',',$data['identity']); foreach($identify as $i){ $client_detail = $data["mfdid_".$i]; $sub_recieve_amount = $data["sub_recive_amount_".$i]; $sub_service_charge = $data["sub_service_charge_".$i]; $sub_peneline_amount = $data["sub_penelize_".$i]; $sub_interest_amount = $data["sub_interest_".$i]; $sub_principle= $data["sub_principal_permonth_".$i]; $sub_total_payment = $data["sub_payment_".$i]; $loan_number = $data["loan_number_".$i]; $date_payment = $data["date_payment_".$i]; if($client_detail!=""){ $arr_money_detail = array( 'crm_id' => $id, 'loan_number' => $data["loan_number_".$i], 'lfd_id' => $data["mfdid_".$i], 'client_id' => $data["client_id_".$i], 'date_payment' => $data["date_payment_".$i], 'capital' => $data["sub_total_priciple_".$i], 'remain_capital' => $data["sub_total_priciple_".$i] - $data["sub_principal_permonth_".$i], 'principal_permonth' => $data["sub_principal_permonth_".$i], 'total_interest' => $data["sub_interest_".$i], 'total_payment' => $data["sub_payment_".$i], 'total_recieve' => $data["sub_recive_amount_".$i], 'currency_id' => $data["currency_type"], 'pay_after' => $data['multiplier_'.$i], 'penelize_amount' => $data["old_sub_penelize_".$i], 'service_charge' => $data["sub_service_charge_".$i], 'is_completed' => 0, 'is_verify' => 0, 'verify_by' => 0, 'is_closingentry' => 0, 'status' => 1 ); $db->getProfiler()->setEnabled(true); $db->insert("ln_client_receipt_money_detail", $arr_money_detail); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQuery()); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQueryParams()); $db->getProfiler()->setEnabled(false); if($option_pay==1){ if($sub_recieve_amount>=$sub_total_payment){ $arr_update_fun_detail = array( 'is_completed' => 1, ); $this->_name="ln_loanmember_funddetail"; $where = $db->quoteInto("id=?", $data["mfdid_".$i]); $db->getProfiler()->setEnabled(true); $this->update($arr_update_fun_detail, $where); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQuery()); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQueryParams()); $db->getProfiler()->setEnabled(false); }else{ $new_sub_interest_amount = $data["sub_interest_".$i]; $new_sub_penelize = $data["sub_penelize_".$i]+$data["old_penelize_".$i]; $new_sub_service_charge = $data["sub_service_charge_".$i]; $new_sub_principle = $data["sub_principal_permonth_".$i]; if($sub_recieve_amount>0){ $new_amount_after_service = $sub_recieve_amount-$sub_service_charge; if($new_amount_after_service>=0){ $new_sub_service_charge = 0; $new_amount_after_penelize = $new_amount_after_service - $sub_peneline_amount; if($new_amount_after_penelize>=0){ $new_sub_penelize = 0; $new_amount_after_interest = $new_amount_after_penelize - $sub_interest_amount; if($new_amount_after_interest>=0){ $new_sub_interest_amount = 0; $new_sub_principle = $sub_principle - $new_amount_after_interest; }else{ $new_sub_interest_amount = abs($new_amount_after_interest); } }else{ $new_sub_penelize = abs($new_amount_after_penelize); } }else{ $new_sub_service_charge = abs($new_amount_after_service); } } $arr_update_fun_detail = array( 'is_completed' => 0, 'total_interest_after' => $new_sub_interest_amount, 'total_payment_after' => $new_sub_principle, 'penelize' => $new_sub_penelize, 'principle_after' => $new_sub_principle, 'service_charge' => $new_sub_service_charge, 'payment_option' => 1 ); $this->_name="ln_loanmember_funddetail"; $where = $db->quoteInto("id=?", $data["mfdid_".$i]); $db->getProfiler()->setEnabled(true); $this->update($arr_update_fun_detail, $where); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQuery()); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQueryParams()); $db->getProfiler()->setEnabled(false); } }else{ $sql_loan_fun = "SELECT lf.`id` , lf.`total_principal`, lf.`principle_after`, lf.`total_interest_after`, lf.`service_charge`, lf.`penelize` FROM `ln_loanmember_funddetail` AS lf, `ln_loan_member` AS lm WHERE lf.`member_id` = lm.`member_id` AND lm.`loan_number` = '$loan_number' AND lf.`date_payment` = '$date_payment'"; $row_fun = $db->fetchAll($sql_loan_fun); $is_set=0; foreach ($row_fun as $rs_fun){ $arr_update_fun_detail = array( 'is_completed' => 1, 'payment_option' => $data["option_pay"] ); $this->_name="ln_loanmember_funddetail"; $where = $db->quoteInto("id=?", $rs_fun['id']); $db->getProfiler()->setEnabled(true); $this->update($arr_update_fun_detail, $where); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQuery()); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQueryParams()); $db->getProfiler()->setEnabled(false); } } $sql_payment ="SELECT l.* FROM `ln_loanmember_funddetail` AS l, `ln_loan_member` AS m WHERE l.`member_id` = m.`member_id` AND m.`loan_number` = '$loan_number' AND l.`is_completed` = 0 "; $rs_payment = $db->fetchRow($sql_payment); $group_id = $data["client_code"]; if(empty($rs_payment)){ $sql ="UPDATE `ln_loan_group` AS l SET l.`status` = 2 WHERE l.`g_id`= (SELECT m.`group_id` FROM `ln_loan_member` AS m WHERE m.`loan_number`='$loan_number' LIMIT 1) AND l.`group_id`= $group_id AND l.`loan_type`=2"; $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_loan_memeber ="UPDATE `ln_loan_member` AS m SET m.`is_completed`=1 WHERE m.`loan_number`= '$loan_number'"; $db->getProfiler()->setEnabled(true); $db->query($sql_loan_memeber); 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(); Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage()); } }