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