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) {
}
}
