public function indexAction(){
try{
$db_tran=new Application_Model_DbTable_DbGlobal();
$session_transfer=new Zend_Session_Namespace('search_xhcange');
$db = new Tellerandexchange_Model_DbTable_Dbexchange();
$session_user=new Zend_Session_Namespace('auth');
$user_id = $session_user->user_id;
if($this->getRequest()->isPost()){
$search=$this->getRequest()->getPost();
}
else{
$search = array(
'user_id' => -1,
'status' => -1,
'from_date' =>date('Y-m-d'),
'to_date' => date('Y-m-d'),
);
}
$this->view->list_search=$search;
// $rs_row= $db->getAllExchangeListMulti($search);
$rs_row= $db->getAllSigleExchange($search);
$glClass = new Application_Model_GlobalClass();
$rs_rows = $glClass->getImgActive($rs_row, BASE_URL, true);
$list = new Application_Form_Frmtable();
$collumns = array("DATE","EXCHANGE","FROM_AMOUNT","អត្រាប្តូរប្រាក់","ចំនួនទឹកប្រាក់បានប្តូររួច","ប្រាក់ទទួលបាន","ប្រាក់អាប់","STATUS");
$link=array(
'module'=>'tellerandexchange','controller'=>'xchanges','action'=>'edit',
);
$this->view->list=$list->getCheckList(0, $collumns, $rs_rows,array('statusDate'=>$link,'from_to'=>$link,'fromAmount'=>$link));
$usr_mod = new Application_Model_DbTable_DbUsers();
$this->view->users = $usr_mod->getUserListSelect();
$this->view->user_id = $user_id;
//$this->view->from_date=$session_transfer->from_date;
//$this->view->to_date=$session_transfer->to_date;
}catch (Exception $e){
Application_Form_FrmMessage::message("Application Error");
echo $e->getMessage();
Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage());
}
$frm = new Application_Form_FrmAdvanceSearch();
$frm = $frm->AdvanceSearch();
Application_Model_Decorator::removeAllDecorator($frm);
$this->view->frm_search = $frm;
}
public function addAction()
{
$session_user = new Zend_Session_Namespace('auth');
$this->view->user_name = $session_user->last_name . ' ' . $session_user->first_name;
$db_keycode = new Application_Model_DbTable_DbKeycode();
$this->view->keycode = $db_keycode->getKeyCodeMiniInv();
$db_g = new Application_Model_DbTable_DbGlobal();
$this->view->inv_no = $db_g->getNewInvoiceExchange();
if ($this->getRequest()->isPost()) {
$formdata = $this->getRequest()->getPost();
// $db_exc=new Application_Model_DbTable_DbExchange();
$db_xchange = new Tellerandexchange_Model_DbTable_Dbexchange();
try {
$db_xchange->saveExchange($formdata);
// $id = $db_exc->save($formdata);
Application_Form_FrmMessage::Sucessfull('ការបញ្ចូលជោគជ័យ', self::REDIRECT_URL . '/exchanges/add');
} catch (Exception $e) {
echo $e->getMessage();
exit;
$this->view->msg = 'ការបញ្ចូលមិនជោគជ័យ';
}
}
}
public function indexAction(){
try{
$db = new Tellerandexchange_Model_DbTable_Dbexchange();
// if($this->getRequest()->isPost()){
// $search=$this->getRequest()->getPost();
// }
// else{
// $search = array(
// 'client_id' => -1,
// 'status' => -1,
// 'from_date' =>date('Y-m-d'),
// 'to_date' => date('Y-m-d'),
// );
// }
$rs_rows= $db->getAllExchangeListMulti();
$rs_row =array();
foreach ($rs_rows AS $key => $rs){
$rs_row[$key]=array(
'id'=>$rs['id'],
'client_name'=>$rs['client_name'],
'date'=>$rs['date'],
'invoice_code'=>$rs['invoice_code'],
'from_to'=>'',//$rs['from_to'],
'from_amount'=>'',//$rs['from_amount'],
'exchange_rate'=>'',//$rs['exchange_rate'],
'to_amount'=>'',//$rs['to_amount'],
'receive_dollar'=>$rs['receive_dollar'],
'return_dollar'=>$rs['return_dollar'],
'exchange_type'=>$rs['exchange_type'],
'status'=>$rs['status'],
);
$sub_transac = $db->getExchangeDetail($rs['id']);//for get receiver
$total_from_d = 0;$total_from_r=0;$total_from_b=0;
$total_to_d = 0;$total_to_r=0;$total_to_b=0;
foreach ($sub_transac as $j => $s_tran){
if($s_tran['from_currency_type']==2){
$total_from_d = $total_from_d+$s_tran['from_amount'];
}elseif($s_tran['from_currency_type']==1){
$total_from_r = $total_from_r+$s_tran['from_amount'];
}elseif($s_tran['from_currency_type']==3){
$total_from_b = $total_from_b+$s_tran['from_amount'];
}
if($s_tran['to_currency_type']==2){
$total_to_d = $total_to_d+$s_tran['to_amount'];
}elseif($s_tran['to_currency_type']==1){
$total_to_r = $total_to_r+$s_tran['to_amount'];
}elseif($s_tran['to_currency_type']==3){
$total_to_b = $total_to_b+$s_tran['to_amount'];
}
// $rs_row[$key]['from_to'].=$s_tran['from_to'].$s_tran['from_name'].",";
// $rs_row[$key]['to_amount'].=$s_tran['to_amount'].$s_tran['to_name'].",";
$rs_row[$key]['exchange_rate'].=$s_tran['exchange_rate'].",";
}
$total_from_r = empty($total_from_r)?'':$total_from_r.$s_tran['from_name'];
$total_from_b = empty($total_from_b)?'':$total_from_b.$s_tran['from_name'];
$total_from_d = (empty($total_from_d)?'':$total_from_d.$s_tran['from_name']);
$total_to_d = empty($total_to_d)?'':$total_to_d.$s_tran['to_name'].",";
$total_to_b = empty($total_to_b)?'':$total_to_b.$s_tran['to_name'].",";
$total_to_r = (empty($total_to_r)?'':$total_to_r.$s_tran['to_name'].",");
$rs_row[$key]['from_amount']=$total_from_d.$total_from_r.$total_from_b;//;
$rs_row[$key]['to_amount']=$total_to_d.$total_to_b.$total_to_r;//;
}
$glClass = new Application_Model_GlobalClass();
$rs_rows = $glClass->getImgActive($rs_row, BASE_URL, true);
$list = new Application_Form_Frmtable();
$collumns = array("ឈ្មោះអតិថិជន","ថ្ងៃប្រតិបត្តិ","វិ.បត្រ","ការប្តូរប្រាក់","ទិញចូល","អត្រាប្តូរប្រាក់","លក់ចេញ","ប្រាក់ទទួលបាន","ប្រាក់អាប់","TYPE","STATUS");
$link=array(
'module'=>'tellerandexchange','controller'=>'exchanges','action'=>'edit',
);
$this->view->list=$list->getCheckList(0, $collumns, $rs_rows,array('client_name'=>$link,'invoice_code'=>$link,'date'=>$link));
}catch (Exception $e){
Application_Form_FrmMessage::message("Application Error");
echo $e->getMessage();
Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage());
}
$frm = new Application_Form_FrmAdvanceSearch();
$frm = $frm->AdvanceSearch();
Application_Model_Decorator::removeAllDecorator($frm);
$this->view->frm_search = $frm;
}