28 lines
1.0 KiB
PHP
Executable File
28 lines
1.0 KiB
PHP
Executable File
<?php
|
|
namespace App\Models;
|
|
use CodeIgniter\Model;
|
|
class RoleModel extends Model
|
|
{
|
|
protected $table = 'roles';
|
|
protected $primaryKey = 'role_id';
|
|
protected $allowedFields = ['role_id','roles','isactive'];
|
|
public function getRoles(){
|
|
return $this->where('roles !=', 'Super Admin')->findAll();
|
|
}
|
|
public function getRoleNameById($roleId)
|
|
{
|
|
$role = $this->where('role_id', $roleId)->first();
|
|
return $role ? $role['roles'] : 'Unknown';
|
|
}
|
|
|
|
public function get_workers($logged_user_branch_id)
|
|
{
|
|
$this->select('roles.*,users.user_id, users.name, users.business_id, users.branch_id, users.role, users.mobile_no, users.isactive');
|
|
$this->join('users', 'users.role = roles.role_id');
|
|
$this->where('roles.isactive', 1);
|
|
$this->where('users.isactive', 1);
|
|
$this->whereIn('roles.roles', ['Senior Mechanic','Mechanic','Helper']);
|
|
$this ->where('users.branch_id',$logged_user_branch_id);
|
|
return $this->findAll();
|
|
}
|
|
} |