public function rptFundtranAction() { // action body try { $db_payment = new Application_Model_DbTable_DbPayment(); $db_keycode = new Application_Model_DbTable_DbKeycode(); $this->view->mainbranch = $db_keycode->getMainBranch(); $this->view->from_date = date('Y-m-d'); $this->view->to_date = date('Y-m-d'); $sender = new Application_Model_DbTable_DbSender(); $_sender = $sender->getAllSenderNameFound(); array_unshift($_sender, array('id' => '-1', "name" => "ជ្រើសរើសឈ្មោះអ្នកជំពាក់")); $this->view->senderlist = $_sender; $db_tran = new Application_Model_DbTable_DbMoneyTransactions(); $db_tran = new Application_Model_DbTable_DbFund(); if ($this->getRequest()->isPost()) { $formdata = $this->getRequest()->getPost(); $this->view->from_date = $formdata['from_date']; $this->view->to_date = $formdata['to_date']; $this->view->selected = $formdata['sender_name']; } else { $this->view->selected = -1; $formdata = array('from_date' => date('Y-m-d'), 'to_date' => date('Y-m-d'), 'sender_name' => -1); } $row_num = 0; $result = $db_tran->getAllTransactionFund($formdata); if (!empty($result)) { // print_r($result); $tra_id = ''; foreach ($result as $i => $rs) { $refund_dollar = 0; $refund_bath = 0; $refund_riel = 0; // capital $capital_dollar = 0; $capital_bath = 0; $capital_riel = 0; // fund for which debt tran? $trandebt_dollar = ''; $trandebt_bath = ''; $trandebt_riel = ''; $refund_txt = 'refund_dollar'; $txt_capital = 'capital_dollar'; $txt_trandebt = 'trandebt_dollar'; if ($rs["curency_type"] == 1) { $refund_dollar = $rs["refund"]; $capital_dollar = $rs["capital"]; $trandebt_dollar = $rs['tran_id']; } else { if ($rs["curency_type"] == 2) { $refund_bath = $rs["refund"]; $refund_txt = 'refund_bath'; $txt_capital = 'capital_bath'; $capital_bath = $rs['capital']; $txt_trandebt = 'trandebt_bath'; $trandebt_bath = $rs['tran_id']; } else { $refund_riel = $rs["refund"]; $refund_txt = 'refund_riel'; $txt_capital = 'capital_riel'; $capital_riel = $rs["capital"]; $txt_trandebt = 'trandebt_riel'; $trandebt_riel = $rs['tran_id']; } } // echo $tra_id."=".$rs["invoice_found"]."<br/><br/>"; if ($tra_id != $rs["invoice_found"]) { $tra_id = $rs["invoice_found"]; $result_row[$tra_id] = array('num' => ++$row_num, "sender_id" => $rs["sender_id"], "found_id" => $rs["invoice_found"], "invoice_found" => $rs["invoice_found"], "sender_name" => $rs["sender_name"], "curency_type" => $rs["curency_type"], "refund_dollar" => $refund_dollar, "refund_bath" => $refund_bath, "refund_riel" => $refund_riel, "capital_dollar" => $capital_dollar, "capital_bath" => $capital_bath, "capital_riel" => $capital_riel, "trandebt_dollar" => $trandebt_dollar, "trandebt_bath" => $trandebt_bath, "trandebt_riel" => $trandebt_riel, "date_refund" => $rs["date_refund"]); // print_r($result_row);echo "<br/> ***New <br/>"; } else { $result_row[$tra_id][$refund_txt] = $rs["refund"]; $result_row[$tra_id][$txt_capital] = $rs["capital"]; $result_row[$tra_id][$txt_trandebt] = $rs["tran_id"]; } } $i = 0; foreach ($result_row as $val) { $result_rows[$i] = $val; $i++; // $owe_d = // $db_payment->getTransactionOweByIdForreport($val['trandebt_dollar']); // $owe_b = // $db_payment->getTransactionOweByIdForreport($val['trandebt_dollar']); // $owe_r = // $db_payment->getTransactionOweByIdForreport($val['trandebt_dollar']); // $row_owe[$val['sender_id']] = // array($owe_d,$owe_b,$owe_r); } // $this->view->listowe=$row_owe; } else { $result_rows = array('err' => 1, 'msg' => 'មិនទាន់មានទន្និន័យនូវឡើយទេ!'); } // print_r($result_rows); // exit; $this->view->fundlist = $result_rows; } catch (Exception $e) { $this->view->msg = "ការផ្លាស់ប្តូរមិនជោគជ័យ"; } }
public function indexAction() { // action body //Get Session User try { $db_owe = new Application_Model_DbTable_DbPayment(); //create sesesion $session_transfer = new Zend_Session_Namespace('search_transfer'); if (empty($session_transfer->limit)) { $session_transfer->limit = Application_Form_FrmNavigation::getLimit(); $session_transfer->status = -1; $session_transfer->type_money = -1; $session_transfer->sender_name = ""; $session_transfer->loan = -1; $session_transfer->province = -1; $session_transfer->agent = -1; $session_transfer->from_date = date('Y-m-d'); $session_transfer->to_date = date('Y-m-d'); $session_transfer->lock(); } //start page nevigation $limit = $session_transfer->limit; $start = $this->getRequest()->getParam('limit_satrt', 0); $this->view->from_date = $session_transfer->from_date; $this->view->to_date = $session_transfer->to_date; $this->view->status = $session_transfer->status; $cur = new Application_Model_DbTable_DbCurrencies(); $this->view->currencylist = $cur->getCurrencyList(); $this->view->type_money = $session_transfer->type_money; $this->view->sender_name = $session_transfer->sender_name; $pro = new Application_Model_DbTable_DbProvinces(); $this->view->provincelist = $pro->getProvinceList(); //$this->view->province = $session_transfer->province; $agent = new Application_Model_DbTable_DbAgents(); //$this->view->agentlist = $agent->getAgentListSelect(); //$this->view->agent = $session_transfer->agent; if ($this->getRequest()->isPost()) { $formdata = $this->getRequest()->getPost(); $session_transfer->unlock(); $session_transfer->sender_name = $formdata['sender_name']; $session_transfer->limit = $formdata['rows_per_page']; $session_transfer->from_date = $formdata['from_date']; $session_transfer->to_date = $formdata['to_date']; $session_transfer->lock(); $this->view->sender_name = $formdata['sender_name']; $this->view->from_date = $session_transfer->from_date; $this->view->to_date = $session_transfer->to_date; $limit = $session_transfer->limit; $result = $db_owe->getTransactionOweList($formdata, $start, $limit); $record_count = $db_owe->getTransactionOweListTotal($formdata); } else { $formdata = array('sender_name' => $session_transfer->sender_name, 'status' => $session_transfer->status, 'status_loan' => $session_transfer->loan, 'from_date' => $session_transfer->from_date, 'to_date' => $session_transfer->to_date, 'type_money' => $session_transfer->type_money); //print_r($formdata); exit(); $result = $db_owe->getTransactionOweList($formdata, $start, $limit); $record_count = $db_owe->getTransactionOweListTotal($formdata); } $row_num = $start; //print_r($result);exit; if (!empty($result)) { $tra_id = ''; foreach ($result as $i => $rs) { $refund_dollar = 0; $refund_bath = 0; $refund_riel = 0; $refund_txt = 'refund_dollar'; if ($rs["curency_type"] == 1) { $refund_dollar = $rs["refund"]; } else { if ($rs["curency_type"] == 2) { $refund_bath = $rs["refund"]; $refund_txt = 'refund_bath'; } else { $refund_riel = $rs["refund"]; $refund_txt = 'refund_riel'; } } //echo $tra_id."=".$rs["invoice_found"]."<br/><br/>"; if ($tra_id != $rs["invoice_found"]) { $tra_id = $rs["invoice_found"]; $result_row[$tra_id] = array('num' => ++$row_num, "found_id" => $rs["invoice_found"], "invoice_found" => $rs["invoice_found"], "sender_name" => $rs["sender_name"], "refund_dollar" => $refund_dollar, "refund_bath" => $refund_bath, "refund_riel" => $refund_riel, "date_refund" => $rs["date_refund"]); //print_r($result_row);echo "<br/> ***New <br/>"; } else { $result_row[$tra_id][$refund_txt] = $rs["refund"]; //print_r($result_row);echo "<br/>***old<br/>"; } } $i = 0; foreach ($result_row as $val) { $result_rows[$i] = $val; $i++; } //print_r($result_rows); // exit; // //format amount // $amount = $tran['symbol'].' '.number_format($tran['amount']); // $sub_agent = (empty($tran['subname']))? "":"(".$tran['subname'].")"; // $inc_no = sprintf("%'010s", $tran['invoice_no']); // $result[$i] = array( // 'num' => (++$row_num), // 'id' => $tran['id'], // 'amount' => $amount, // 'agentname' => $tran['agentname'].$sub_agent, // 'reciever_tel' => $tran['reciever_tel'], // 'invoice_no'=> $inc_no, // 'send_date'=> date_format(date_create($tran['send_date']), "d/m/Y"), // //'status'=> $this->statuslist[$tran['status']], // //'status_loan'=> $this->loanlist[$tran['status_loan']], // 'sender_name'=>$tran['sender_name'], // 'reciever_name'=>$tran['reciever_name'] // ); // } } else { $result_rows = array('err' => 1, 'msg' => 'មិនទាន់មានទន្និន័យនូវឡើយទេ!'); } $this->view->tranlist = Zend_Json::encode($result_rows); $sender = new Application_Model_DbTable_DbSender(); //$this->view->loanlist =($this->loanlist); // $this->view->senderlist = $sender->getAllSenderNameOwe(); // print_r($sender->getAllSenderNameOwe()); $page = new Application_Form_FrmNavigation(self::REDIRECT_URL, $start, $limit, $record_count); $page->init(self::REDIRECT_URL, $start, $limit, $record_count); $this->view->nevigation = $page->navigationPage(); //print_r($limit);exit; $this->view->rows_per_page = $page->getRowsPerPage($limit, 'frmlist_mt'); $this->view->result_row = $page->getResultRows(); $sender = new Application_Model_DbTable_DbSender(); $this->view->senderlist = $sender->getAllSenderNameFound(); } catch (Exception $e) { } }