Example #1
0
 public function __construct($data = NULL)
 {
     parent::__construct($data);
     $this->_transactions = ORM::Factory('transaction')->distinct(TRUE)->join('entities', 'LEFT')->on('entities.id', '=', 'transaction.entity_id');
     $this->_page = (isset($data->page) and (int) $data->page >= 0) ? (int) $data->page : 0;
     $this->_page_size = (isset($data->page_size) and (int) $data->page_size > 0) ? (int) $data->page_size : 50;
     $this->_sort_by = isset($data->sort_by) ? strtolower($data->sort_by) : "newest";
     $this->_form_id = isset($data->form_id) ? $data->form_id : FALSE;
     // Re-declare $this->_transactions to use proper joins for a form search.
     $this->_transactions = ORM::Factory('transaction')->DISTINCT(TRUE)->join('account_transactions', 'RIGHT')->on('account_transactions.transaction_id', '=', 'transaction.id')->join('account_transaction_forms', 'RIGHT')->on('account_transaction_forms.account_transaction_id', '=', 'account_transactions.id');
 }
Example #2
0
 public function __construct($data = NULL)
 {
     parent::__construct($data);
     $this->_transactions = ORM::Factory('transaction')->distinct(TRUE)->join('entities', 'LEFT')->on('entities.id', '=', 'transaction.entity_id');
     $this->_page = (isset($data->page) and (int) $data->page >= 0) ? (int) $data->page : 0;
     $this->_page_size = (isset($data->page_size) and (int) $data->page_size > 0) ? (int) $data->page_size : 50;
     $this->_sort_by = isset($data->sort_by) ? strtolower($data->sort_by) : "newest";
     // Check for search fields.
     $this->_search_vendor_keywords = isset($data->vendor_keywords) ? $data->vendor_keywords : FALSE;
     $this->_search_customer_keywords = isset($data->customer_keywords) ? $data->customer_keywords : FALSE;
     $this->_search_date = isset($data->date) ? $data->date : FALSE;
     $this->_search_check_number = isset($data->check_number) ? $data->check_number : FALSE;
 }
Example #3
0
 public function __construct($data = NULL)
 {
     parent::__construct($data);
     $this->_transactions = ORM::Factory('transaction')->distinct(TRUE);
     $this->_page = (isset($data->page) and (int) $data->page >= 0) ? (int) $data->page : 0;
     $this->_page_size = (isset($data->page_size) and (int) $data->page_size > 0) ? (int) $data->page_size : 50;
     $this->_sort_by = isset($data->sort_by) ? strtolower($data->sort_by) : "newest";
     // Check for search fields.
     $this->_search_vendor_id = isset($data->vendor_id) ? $data->vendor_id : FALSE;
     $this->_search_keywords = isset($data->search_keywords) ? $data->search_keywords : FALSE;
     $this->_search_date = isset($data->date) ? $data->date : FALSE;
     $this->_search_check_number = isset($data->check_number) ? $data->check_number : FALSE;
     $this->_search_and = isset($data->search_and) ? $data->search_and ? TRUE : FALSE : TRUE;
 }