| Línea 974... |
Línea 974... |
| 974 |
* @param int $records_per_page
|
974 |
* @param int $records_per_page
|
| 975 |
* @param string $order_field
|
975 |
* @param string $order_field
|
| 976 |
* @param string $order_direction
|
976 |
* @param string $order_direction
|
| 977 |
* @return Paginator
|
977 |
* @return Paginator
|
| 978 |
*/
|
978 |
*/
|
| 979 |
public function fetchAllDataTableByCompanyId($company_id, $status = '', $search, $page = 1, $records_per_page = 10, $order_field = 'name', $order_direction = 'ASC')
|
979 |
public function fetchAllDataTableByCompanyId($company_id, $search, $status = '', $page = 1, $records_per_page = 10, $order_field = 'name', $order_direction = 'ASC')
|
| 980 |
{
|
980 |
{
|
| 981 |
$select = $this->sql->select();
|
981 |
$select = $this->sql->select();
|
| 982 |
$select->columns(['status', 'backend', 'creator']);
|
982 |
$select->columns(['status', 'backend', 'creator']);
|
| 983 |
$select->from(['tb1' => CompanyUserMapper::_TABLE]);
|
983 |
$select->from(['tb1' => CompanyUserMapper::_TABLE]);
|
| 984 |
$select->join(['tb2' => self::_TABLE], 'tb1.user_id = tb2.id', [
|
984 |
$select->join(['tb2' => self::_TABLE], 'tb1.user_id = tb2.id', [
|