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