Kategorien
01 Administrator A Organisation Management Qv Service Manual

Manage Organisation Groups

NEW Feature!!! (2011-04-11)

As it is sometimes neccessary to manage user groups, which will recieve the same report with the same settings. I’m proud to announce the new feature in the User Management, which allows you to define a Organisation as a group. This is done at the to, next to the salutation.

After you have activated this feature, you need to reload the page, to get the correct input view:

tutorial_user_groups

As you can see, you can now add several users with the related communication information. Notice! You are allowed to add a user several times, as you send e.g. a mail to different adresses;)

Feedback welcome!

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';

ALTER SCHEMA `beeyeqvservice`  DEFAULT CHARACTER SET utf8  DEFAULT COLLATE utf8_bin ;

USE `beeyeqvservice`;

ALTER TABLE `beeyeqvservice`.`tbl_organisation` ADD COLUMN `is_group` TINYINT(1) NULL DEFAULT 0  AFTER `type` ;

ALTER TABLE `beeyeqvservice`.`tbl_reports` DROP COLUMN `s_zylklus_start` , ADD COLUMN `s_zyklus_start` INT(11) NULL DEFAULT 0  AFTER `s_zyklus_gap` ;

CREATE  TABLE IF NOT EXISTS `beeyeqvservice`.`tbl_organisation_has_tbl_organisation` (
`tbl_organisation_org_id` INT(11) NOT NULL ,
`tbl_organisation_org_childid` INT(11) NOT NULL ,
`kom_id` INT(11) NOT NULL ,
PRIMARY KEY (`tbl_organisation_org_id`, `tbl_organisation_org_childid`, `kom_id`) ,
INDEX `fk_tbl_organisation_has_tbl_organisation_tbl_organisation2` (`tbl_organisation_org_childid` ASC) ,
CONSTRAINT `fk_tbl_organisation_has_tbl_organisation_tbl_organisation1`
FOREIGN KEY (`tbl_organisation_org_id` )
REFERENCES `beeyeqvservice`.`tbl_organisation` (`org_id` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_tbl_organisation_has_tbl_organisation_tbl_organisation2`
FOREIGN KEY (`tbl_organisation_org_childid` )
REFERENCES `beeyeqvservice`.`tbl_organisation` (`org_id` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;

SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;

Schreibe einen Kommentar