public function indexAction()
{
// $options = $this->getFrontController()->getParam('bootstrap')->getApplication()->getOptions();
$model = new Branch();
$select = $model->select();
$request = $this->getRequest();
$page = $request->getParam('page', 1);
$sort = $request->getParam('sort', 'web_name');
$order = $request->getParam('order', 'asc');
$select->where('ghost = false');
$select->order($sort . ' ' . $order);
// $this->view->assign('paginator', new Base_Paginator(new Zend_Paginator_Adapter_DbTableSelect($select)));
// $paginator->setCurrentPageNumber($page);
// $this->view->paginator = $paginator;
$paginator = new Base_Paginator(new Zend_Paginator_Adapter_DbTableSelect($select));
$paginator->setCurrentPageNumber($page);
$this->view->paginator = $paginator;
$this->view->headers = array('branch_name', 'web_name', 'type', 'id_status', 'city', 'province');
}
public function getBranchesInGroup($id)
{
$branch = new Branch();
$select = $branch->select()->from('branch')->join('branch_branch_group', 'branch.id= branch_branch_group.id_branch', array())->where('branch_branch_group.id_branch_group = ?', $id)->where('branch.ghost = false and branch_branch_group.ghost = false')->order(array('branch.created_at', 'branch.id'))->setIntegrityCheck(false);
return $select;
}
public function __construct()
{
$this->categories_list = Categories::select()->orderBy('category')->get();
$this->branch_list = Branch::select()->orderBy('id')->get();
$this->student_categories_list = StudentCategories::select()->orderBy('cat_id')->get();
}
public function getDataToUserReport()
{
$profileModel = new Profile();
$select = $profileModel->select()->order('id_user');
$profileDataArray = $profileModel->fetchAll($select)->toArray();
$groupModel = new Group();
$select = $groupModel->select();
$groupDataArray = $groupModel->fetchAll($select)->toArray();
foreach ($groupDataArray as $key => $value) {
$tmp[$value['id']] = $value;
}
$groupDataArray = $tmp;
unset($tmp);
$branchModel = new Branch();
$select = $branchModel->select();
$branchDataArray = $branchModel->fetchAll($select)->toArray();
foreach ($branchDataArray as $key => $value) {
$tmp[$value['id']] = $value;
}
$branchDataArray = $tmp;
unset($tmp);
$userModel = new User();
$select = $userModel->select();
$userDataArray = $userModel->fetchAll($select)->toArray();
foreach ($userDataArray as $key => $value) {
$tmp[$value['id']] = $value;
}
$userDataArray = $tmp;
unset($tmp);
$roleModel = new Role();
$select = $roleModel->select();
$roleDataArray = $roleModel->fetchAll($select)->toArray();
foreach ($roleDataArray as $key => $value) {
$tmp[$value['id']] = $value;
}
$roleDataArray = $tmp;
unset($tmp);
$groupArray = array();
foreach ($profileDataArray as $key => $value) {
$data = $this->getAuthorizationsForProfile($value['id']);
foreach ($data as $key2 => $values) {
foreach ($values as $key3 => $privs) {
/* if ($privs['ghost'] === true) {
unset($data[$key2][$key3]);
continue;
}
*/
$tmp = array('login' => '', 'surname' => '', 'first_name' => '', 'group' => '', 'role' => '', 'branch' => '', 'ghost' => '');
if ($key2 === 'group') {
$tmp['group'] = $groupDataArray[$privs['id_group']]['group_name'];
}
if ($key2 === 'role') {
$tmp['role'] = $roleDataArray[$privs['id_role']]['description'];
}
$tmp['login'] = $userDataArray[$value['id_user']]['login'];
$tmp['surname'] = $userDataArray[$value['id_user']]['surname'];
$tmp['first_name'] = $userDataArray[$value['id_user']]['first_name'];
$tmp['branch'] = $branchDataArray[$value['id_branch']]['branch_name'];
$tmp['ghost'] = $userDataArray['ghost'] ? 'NIEAKTYWNY' : 'AKTYWNY';
$groupArray[] = $tmp;
}
}
}
return $groupArray;
}
