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; }