예제 #1
0
 public function editWidgetAction()
 {
     $this->view->layout()->disableLayout();
     $this->_helper->viewRenderer->setNoRender(true);
     $request = $this->getRequest();
     $usersNs = new Zend_Session_Namespace("members");
     $mapCode = "fdWidget";
     $mapId1 = $usersNs->userId;
     if ($request->isPost()) {
         $model1 = new Security_Model_SystemMaster();
         $model = $model1->fetchAll("master_code='fdWidget'");
         $model2 = new Security_Model_SystemMapping();
         $model2->delete("map_code='{$mapCode}' and map_id1='{$mapId1}'");
         foreach ($model as $_row) {
             $disC = "display" . $_row->getMasterId();
             $ordC = "order" . $_row->getMasterId();
             $intval1 = $_POST[$disC];
             $intval2 = $_POST[$ordC];
             if (empty($intval2)) {
                 $intval2 = 0;
             }
             if (empty($intval1)) {
                 $intval1 = 0;
             } else {
                 $intval1 = 1;
             }
             $mapId2 = $_row->getMasterId();
             $model2->setMapCode($mapCode)->setMapId1($mapId1)->setMapId2($mapId2)->setIntval1($intval1)->setIntval2($intval2)->save();
         }
         $this->_flashMessenger->addMessage(array('success' => 'Widgets updated successfully!'));
         $this->_helper->_redirector->gotoUrl($this->view->seoUrl('/admin/widget/manage'));
     }
 }
예제 #2
0
 public function getLegendsValue($legend_id, $status = 1)
 {
     $model = new Security_Model_SystemMapping();
     $table = $model->getMapper()->getDbTable();
     $select = $table->select()->setIntegrityCheck(false)->from(array("a" => 'system_mapping'), array('map_code', 'group_id' => 'map_id1', 'legend_value_id' => 'map_id2'))->join(array("b" => 'system_master'), "a.map_id2=b.master_id and b.master_code='fdLegendsVal'", array('legend_value_title' => 'master_value', 'master_code'))->where("a.status='{$status}' and a.map_code='fdLegendsLegendsValMap' and a.map_id1='{$legend_id}'");
     //echo $select->__toString(); exit;
     return $table->fetchAll($select);
 }
예제 #3
0
 public function getRoles($sub_group_id,$status=1)
 {
     $model=new Security_Model_SystemMapping();
     $table=$model->getMapper()->getDbTable();
     $select = $table->select()->setIntegrityCheck(false)->from(array("a"=>'system_mapping'), array('map_code','sub_group_id'=>'map_id1','role_id'=>'map_id2'))
             ->join(array("b"=>'system_master'),"a.map_id2=b.master_id and b.master_code='fdUserRole'" ,array('role_title'=>'master_value', 'master_code'))
             ->where("a.status='{$status}' and a.map_code='fdSubGroupRoleMap' and a.map_id1='$sub_group_id'");
    
    return $table->fetchAll($select);
 }
 public function ajaxGetAnimalColorAction()
 {
     $this->view->layout()->disableLayout();
     $this->_helper->viewRenderer->setNoRender(true);
     $breed_id = $this->_getParam('breed_id');
     $animal_id = $this->_getParam('animal_id');
     $objPrivilege = new Security_Model_SystemMapping();
     $subgroups = $objPrivilege->getAnimalColorArray($animal_id, $breed_id);
     echo Zend_Json::encode($subgroups);
 }
예제 #5
0
 public function getAnimalColors($animal_id, $animal_type_id, $status = 1)
 {
     $subSQL = " and a.map_id1='{$animal_id}' and a.map_id2='{$animal_type_id}'";
     if ($animal_type_id == "All") {
         $subSQL = "";
     }
     $model = new Security_Model_SystemMapping();
     $table = $model->getMapper()->getDbTable();
     $select = $table->select()->setIntegrityCheck(false)->from(array("a" => 'system_mapping'), array('map_code', 'animal_type_id' => 'map_id2', 'animal_color_id' => 'map_id3'))->join(array("b" => 'system_master'), "a.map_id3=b.master_id and b.master_code='fdAnimalColor'", array('animal_color_title' => 'master_value', 'master_code'))->where("a.status='{$status}' and a.map_code='fdAnimalAnimalTypeAnimalColorMap' {$subSQL}");
     return $table->fetchAll($select);
 }
예제 #6
0
 public function dashboardAction()
 {
     //Start Dashboard bookmark listing
     $code1 = "fdUserBookmark";
     $usersNs = new Zend_Session_Namespace("members");
     $mapId1 = $usersNs->userId;
     $model = new Security_Model_SystemMapping();
     $strOrderBy = "s.map_id3";
     $this->view->sortOptions = array();
     $this->view->linkArray = array();
     $table = $model->getMapper()->getDbTable();
     $select = $table->select()->setIntegrityCheck(false)->from(array("sm" => 'system_master'), array("master_value", "strval1", "strval3"))->join(array("s" => "system_mapping"), "s.map_code='{$code1}' and s.map_id1='{$mapId1}'  and sm.master_code='fdMenu' and sm.strval1!='' and sm.master_id=s.map_id2", array("map_id1" => 'map_id1', "map_id2" => 'map_id2', "map_id3" => 'map_id3'))->group("s.map_id2")->order($strOrderBy);
     $this->view->bookmarks = $table->fetchAll($select);
     //End Dashboard bookmark listing
     //start dashboard Widgets
     $code2 = "fdWidget";
     $model = new Security_Model_SystemMaster();
     $table2 = $model->getMapper()->getDbTable();
     $select = $table2->select()->setIntegrityCheck(false)->from(array("s" => 'system_master'), array("master_value"))->join(array("sm" => "system_mapping"), "sm.map_code='{$code2}' and sm.map_id1='{$mapId1}'  and s.master_code=sm.map_code and s.master_id=sm.map_id2 and sm.intval1=1", array("master_id" => 'map_id2', "intval1" => 'intval1', "intval2" => 'intval2'))->order("sm.map_id3");
     $this->view->widgets = $table2->fetchAll($select);
     //End widgets listing
     $this->view->pageHeading = "Dashboard";
 }
예제 #7
0
 public function removeAction()
 {
     $this->view->layout()->disableLayout();
     $this->_helper->viewRenderer->setNoRender(true);
     $child_node_id = $this->_getParam('child_node_id');
     $arrChildNode = explode("_", $child_node_id);
     $child_master_code = $arrChildNode[0];
     $child_master_id = $arrChildNode[1];
     $parent_node_id = $this->_getParam('parent_node_id');
     $arrParentNode = explode("_", $parent_node_id);
     $parent_master_code = $arrParentNode[0];
     $parent_master_id = $arrParentNode[1];
     if ($child_master_code == "fdLegendsVal") {
         //delete role
         $objMap = new Security_Model_SystemMapping();
         $objMap->delete("map_code='fdLegendsLegendsValMap' and map_id1='{$parent_master_id}' and map_id2='{$child_master_id}'");
         $objMaster = new Security_Model_SystemMaster();
         $objMaster->delete("master_code='{$child_master_code}' and master_id='{$child_master_id}'");
     } else {
         if ($child_master_code == "fdLegends") {
             //fetch roles and delete them
             $objMap = new Security_Model_SystemMapping();
             $result = $objMap->fetchAll("map_code='fdLegendsLegendsValMap' and map_id1='{$child_master_id}'");
             if (count($result) > 0) {
                 foreach ($result as $_row) {
                     $objMaster = new Security_Model_SystemMaster();
                     $objMaster->delete("master_code='fdLegendsVal' and master_id='{$_row->getMapId2()}'");
                 }
             }
             $objMap->delete("map_code='fdLegendsLegendsValMap' and map_id1='{$child_master_id}'");
             // now delete sub group from master
             $objMaster = new Security_Model_SystemMaster();
             $objMaster->delete("master_code='{$child_master_code}' and master_id='{$child_master_id}'");
         }
     }
     echo $result = Zend_Json::encode(array("status" => true));
 }
예제 #8
0
 public function initACL()
 {
     $model = new Security_Model_SystemMaster();
     $result = $model->fetchAll("master_code='fdMenu' and status='1'");
     $acl = new Base_Acl();
     foreach ($result as $row) {
         $arrUrl = explode("/", $row->getStrval1());
         $module = $arrUrl[1];
         $controller = $arrUrl[2];
         $action = $arrUrl[3];
         if (!$acl->has("{$module}:{$controller}")) {
             $acl->add(new Zend_Acl_Resource("{$module}:{$controller}"));
         }
         //$acl->deny('administrator', "$module:$controller", $action);
     }
     $acl->add(new Zend_Acl_Resource('default:error'))->add(new Zend_Acl_Resource('mps:auth'))->add(new Zend_Acl_Resource('default:index'));
     $acl->allow('guest', array('default:error', "mps:auth", 'default:index'));
     $acl->allow('administrator', array("mps:app"));
     // prototype
     $model = new Security_Model_SystemMapping();
     $userGroupId = $this->view->userGroupId;
     $userSubGroupId = $this->view->userSubGroupId;
     $userRoleId = $this->view->userRoleId;
     $userId = $this->view->userId;
     $arrG = array();
     $res = $model->fetchAll("map_code='fdMenuGroupMap' and map_id2='{$userGroupId}'");
     if (count($res) > 0) {
         foreach ($res as $_row) {
             $arrG[] = $_row->getMapId1();
         }
     }
     $res = $model->fetchAll("map_code='fdMenuSubGroupMap' and map_id2='{$userSubGroupId}'");
     if (count($res) > 0) {
         foreach ($res as $_row) {
             $arrG[] = $_row->getMapId1();
         }
     }
     $res = $model->fetchAll("map_code='fdMenuRoleMap' and map_id2='{$userRoleId}'");
     if (count($res) > 0) {
         foreach ($res as $_row) {
             $arrG[] = $_row->getMapId1();
         }
     }
     $res = $model->fetchAll("map_code='fdMenuUserMap' and map_id2='{$userId}'");
     if (count($res) > 0) {
         foreach ($res as $_row) {
             $arrG[] = $_row->getMapId1();
         }
     }
     $arrG = array_unique($arrG);
     $strid = implode("','", $arrG);
     $model = new Security_Model_SystemMaster();
     $result = $model->fetchAll("master_code='fdMenu' and master_id in ('{$strid}')");
     if (count($result) > 0) {
         foreach ($result as $row) {
             $arrUrl = explode("/", $row->getStrval1());
             $module = $arrUrl[1];
             $controller = $arrUrl[2];
             $action = $arrUrl[3];
             //                    echo "<pre>";
             //                    print_r($arrUrl);
             //                    echo "</pre>";
             $acl->allow('administrator', "{$module}:{$controller}", $action);
         }
     }
     $acl->allow('administrator', 'security:menu', array('get-permission', 'save-permission'));
     Zend_Registry::set('acl', $acl);
 }
예제 #9
0
 public function setModel($row)
 {
     $model = new Security_Model_SystemMapping();
     $model->setMapCode($row->map_code)->setMapId1($row->map_id1)->setMapId2($row->map_id2)->setStatus($row->status)->setIntval1($row->intval1)->setIntval2($row->intval2)->setStrval1($row->strval1)->setStrval2($row->strval2)->setBlnval1($row->blnval1)->setBlnval2($row->blnval2)->setDblval1($row->dblval1)->setDblval2($row->dblval2)->setCreatedOn($row->created_on)->setCreatedBy($row->created_by)->setUpdatedOn($row->updated_on)->setUpdatedBy($row->updated_by)->setRowGuid($row->row_guid);
     return $model;
 }
예제 #10
0
 public function getPermissionAction()
 {
     $this->view->layout()->disableLayout();
     $this->_helper->viewRenderer->setNoRender(true);
     $params = $this->_getAllParams();
     $rdo = $params['rdo'];
     //groupId, subGroupId, roleId, userId
     $mapId2 = $params[$rdo];
     $arrMapId1 = array();
     $mapCode = "";
     $arrResult = array("status" => 0);
     if ($rdo == "groupId") {
         $mapCode = "fdMenuGroupMap";
     } else {
         if ($rdo == "subGroupId") {
             $mapCode = "fdMenuSubGroupMap";
         } else {
             if ($rdo == "roleId") {
                 $mapCode = "fdMenuRoleMap";
             } else {
                 if ($rdo == "userId") {
                     $mapCode = "fdMenuUserMap";
                 }
             }
         }
     }
     $model = new Security_Model_SystemMapping();
     $res = $model->fetchAll("map_code='{$mapCode}' and map_id2='{$mapId2}'");
     if (count($res) > 0) {
         foreach ($res as $row) {
             $arrMapId1[] = $row->getMapId1();
         }
         $arrResult = array("status" => 1, "mapId1" => $arrMapId1);
     }
     echo Zend_Json::encode($arrResult);
 }
 public function addBookMarkAction()
 {
     $this->view->layout()->disableLayout();
     $this->_helper->viewRenderer->setNoRender(true);
     $menu_id = $this->_getParam('id');
     $limit = Zend_Registry::get('bookMark_limit');
     $usersNs = new Zend_Session_Namespace("members");
     $user_id = $usersNs->userId;
     $security = new Base_Security_Menu();
     $bookmarkAdd = $security->isBookMarked($menu_id);
     $model = new Security_Model_SystemMapping();
     if ($bookmarkAdd == false) {
         $count = $model->getCount("map_code='fdUserBookmark' and map_id1='{$user_id}'");
         if ($count >= $limit) {
             $arrResult = array("result" => 1);
             //if more than 15
         } else {
             $mapCode = "fdUserBookmark";
             $model->setMapCode($mapCode);
             $model->setMapId1($user_id);
             $model->setMapId2($menu_id);
             $model->save();
             $arrResult = array("result" => 2);
             //added into bookmark
         }
     } else {
         if ($bookmarkAdd == true) {
             $arrResult = array("result" => 3);
             //All ready added into bookmark
         } else {
             $arrResult = array("result" => 4);
             //// Problem in Parameter
         }
     }
     echo Zend_Json::encode($arrResult);
 }
예제 #12
0
 public function removeAction()
 {
     $this->view->layout()->disableLayout();
     $this->_helper->viewRenderer->setNoRender(true);
     $child_node_id = $this->_getParam('child_node_id');
     //print_r ($child_node_id);
     $arrChildNode = explode("_", $child_node_id);
     $child_master_code = $arrChildNode[0];
     $child_master_id = $arrChildNode[1];
     $parent_node_id = $this->_getParam('parent_node_id');
     $arrParentNode = explode("_", $parent_node_id);
     $parent_master_code = $arrParentNode[0];
     $parent_master_id = $arrParentNode[1];
     if ($child_master_code == "fdAnimalColor") {
         //delete role
         $objMap = new Security_Model_SystemMapping();
         //$objMap->delete("map_code='fdAnimalTypeAnimalColorMap' and map_id1='{$parent_master_id}' and map_id2='{$child_master_id}'");
         $objMap->updateanimal_color('fdAnimalAnimalTypeAnimalColorMap', $arrChildNode[1], $arrChildNode[2], $arrChildNode[3]);
         //$objMaster=new Security_Model_SystemMaster();
         //$objMaster->delete("master_code='{$child_master_code}' and master_id='{$child_master_id}'");
     } else {
         if ($child_master_code == "fdAnimalType") {
             //fetch roles and delete them
             $objMap = new Security_Model_SystemMapping();
             //$objMap->deleteanimal_type('fdAnimalAnimalTypeAnimalColorMap',$arrChildNode[1],$arrChildNode[2]);
             $objMap->delete("map_code='fdAnimalAnimalTypeAnimalColorMap' AND map_id2='{$arrChildNode['1']}' AND map_id1='{$arrChildNode['2']}'");
         } else {
             if ($child_master_code == "fdAnimal") {
                 // fetch sub groups and delete them
                 $objMap = new Security_Model_SystemMapping();
                 $result = $objMap->fetchAll("map_code='fdAnimalAnimalTypeMap' and map_id1='{$child_master_id}'");
                 if (count($result) > 0) {
                     foreach ($result as $_row) {
                         //fetch roles and delete them
                         $objMap1 = new Security_Model_SystemMapping();
                         $result1 = $objMap1->fetchAll("map_code='fdAnimalTypeAnimalColorMap' and map_id1='{$_row->getMapId2()}'");
                         if (count($result1) > 0) {
                             foreach ($result1 as $_row1) {
                                 $objMaster = new Security_Model_SystemMaster();
                                 $objMaster->delete("master_code='fdAnimalColor' and master_id='{$_row1->getMapId2()}'");
                             }
                         }
                         $objMap1->delete("map_code='fdAnimalTypeAnimalColorMap' and map_id1='{$_row->getMapId2()}'");
                         $objMaster = new Security_Model_SystemMaster();
                         $objMaster->delete("master_code='fdAnimalType' and master_id='{$_row->getMapId2()}'");
                     }
                 }
                 $objMap->delete("map_code='fdAnimalAnimalTypeMap' and map_id1='{$child_master_id}'");
                 // now delete group from master
                 $objMaster = new Security_Model_SystemMaster();
                 $objMaster->delete("master_code='{$child_master_code}' and master_id='{$child_master_id}'");
             }
         }
     }
     echo $result = Zend_Json::encode(array("status" => true));
 }
 public function deleteBookmarkAction()
 {
     $this->view->layout()->disableLayout();
     $this->_helper->viewRenderer->setNoRender(true);
     $request = $this->getRequest();
     $usersNs = new Zend_Session_Namespace("members");
     $id = trim($this->_getParam('bookID'));
     $mapCode = "fdUserBookmark";
     $mapId1 = $usersNs->userId;
     if ($id) {
         $model1 = new Security_Model_SystemMapping();
         $model = $model1->delete("map_code='{$mapCode}' and map_id1='{$mapId1}' and map_id2='{$id}'");
         $this->_flashMessenger->addMessage(array('success' => 'Bookmark deleted successfully!'));
         $this->_helper->_redirector->gotoUrl($this->view->seoUrl('/admin/bookmark/index'));
     }
 }
예제 #14
0
 public function countBookmark($menu_id)
 {
     $usersNs = new Zend_Session_Namespace("members");
     $user_id = $usersNs->userId;
     $model = new Security_Model_SystemMapping();
     $rows = $model->getCount("map_code='fdUserBookmark' and map_id1='{$user_id}'");
     return $rows;
 }