示例#1
0
 /**
  * Install module
  *
  * @param \phpOMS\DataStorage\Database\Pool $dbPool Database instance
  * @param array                             $info   Module info
  *
  * @since  1.0.0
  * @author Dennis Eichhorn <*****@*****.**>
  */
 public static function install($dbPool, $info)
 {
     switch ($dbPool->get('core')->getType()) {
         case \phpOMS\DataStorage\Database\DatabaseType::MYSQL:
             break;
     }
 }
示例#2
0
 /**
  * Install module
  *
  * @param \phpOMS\DataStorage\Database\Pool $dbPool Database instance
  * @param array                             $info   Module info
  *
  * @since  1.0.0
  * @author Dennis Eichhorn <*****@*****.**>
  */
 public static function install($dbPool, $info)
 {
     switch ($dbPool->get('core')->getType()) {
         case \phpOMS\DataStorage\Database\DatabaseType::MYSQL:
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'itemreference` (
                         `itemreference_id` int(11) NOT NULL AUTO_INCREMENT,
                         `itemreference_name` varchar(30) DEFAULT NULL,
                         `itemreference_desc` varchar(256) DEFAULT NULL,
                         PRIMARY KEY (`itemreference_id`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             break;
     }
 }
 /**
  * Get all groups
  *
  * This function gets all groups in a range
  *
  * @param array $filter Filter for search results
  * @param int   $offset Offset for first account
  * @param int   $limit  Limit for results
  *
  * @return array
  *
  * @since  1.0.0
  * @author Dennis Eichhorn <*****@*****.**>
  */
 public function getList($filter = null, $offset = 0, $limit = 100)
 {
     $result = null;
     switch ($this->dbPool->get('core')->getType()) {
         case \phpOMS\DataStorage\Database\DatabaseType::MYSQL:
             $sth = $this->dbPool->get('core')->con->prepare('SELECT SQL_CALC_FOUND_ROWS * FROM `' . $this->dbPool->get('core')->prefix . 'group` LIMIT ' . $offset . ',' . $limit);
             $sth->execute();
             $result['list'] = $sth->fetchAll();
             $sth = $this->dbPool->get('core')->con->prepare('SELECT FOUND_ROWS();');
             $sth->execute();
             $result['count'] = $sth->fetchAll()[0][0];
             break;
     }
     return $result;
 }
示例#4
0
 /**
  * Create dummy data
  *
  * @param array $toDummy Dummy data array
  *
  * @since  1.0.0
  * @author Dennis Eichhorn <*****@*****.**>
  */
 public function installDummy($toDummy)
 {
     $this->dbPool->get('core')->con->beginTransaction();
     $a = "INSERT INTO `" . $this->dbPool->get('core')->prefix . "account` (`status`, `type`, `lactive`, `created`, `changed`) VALUES";
     $b = "INSERT INTO `" . $this->dbPool->get('core')->prefix . "account_data` (`login`, `name1`, `name2`, `name3`, `password`, `email`, `tries`, `account`) VALUES";
     $c = "INSERT INTO `" . $this->dbPool->get('core')->prefix . "account_group` (`group`, `account`) VALUES";
     $valA = '';
     $valB = '';
     $valC = '';
     for ($i = 2; $i < 9998; $i++) {
         $valA .= " (" . rand(0, 1) . ", " . rand(0, 3) . ", '0000-00-00 00:00:00', '" . \phpOMS\Utils\RnG\DateTime::generateDateTime('2005-12-10', '2014-12-31')->format('Y-m-d H:i:s') . "', " . rand(0, 1) . "),";
         $valB .= " ('" . strtolower(\phpOMS\Utils\RnG\Name::generateName(['male', 'female'])) . "', '" . \phpOMS\Utils\RnG\Name::generateName(['male', 'female']) . "', '" . \phpOMS\Utils\RnG\Name::generateName(['family']) . "', 'Orange Management', 'yellowOrange', '" . \phpOMS\Utils\RnG\Name::generateName(['male', 'female']) . "@email.com', " . rand(0, 5) . ", " . $i . "),";
         $valC .= " (1000101000, 1),";
     }
     $valA = rtrim($valA, ',');
     $valB = rtrim($valB, ',');
     $valC = rtrim($valC, ',');
     $this->dbPool->get('core')->con->prepare($a . $valA)->execute();
     $this->dbPool->get('core')->con->prepare($b . $valB)->execute();
     $this->dbPool->get('core')->con->prepare($c . $valC)->execute();
     $this->dbPool->get('core')->con->commit();
     foreach ($toDummy as $dummy) {
         \phpOMS\Install\DummyFactory::generate($this->dbPool, $dummy);
     }
 }
示例#5
0
 /**
  * Install module
  *
  * @param \phpOMS\DataStorage\Database\Pool $dbPool Database instance
  * @param array                             $info   Module info
  *
  * @since  1.0.0
  * @author Dennis Eichhorn <*****@*****.**>
  */
 public static function install($dbPool, $info)
 {
     switch ($dbPool->get('core')->getType()) {
         case \phpOMS\DataStorage\Database\DatabaseType::MYSQL:
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'marketing_promotion` (
                         `marketing_promotion_id` int(11) NOT NULL AUTO_INCREMENT,
                         `marketing_promotion_name`  varchar(30) NOT NULL,
                         `marketing_promotion_description` text DEFAULT NULL,
                         `marketing_promotion_start` datetime DEFAULT NULL,
                         `marketing_promotion_end` datetime DEFAULT NULL,
                         `marketing_promotion_type` tinyint(1) DEFAULT NULL,
                         PRIMARY KEY (`marketing_promotion_id`)
                     )ENGINE=InnoDB  DEFAULT CHARSET=utf8;')->execute();
             break;
     }
 }
 /**
  * Load navigation based on request
  *
  * @param string[] $request Request hashes
  *
  * @since  1.0.0
  * @author Dennis Eichhorn <*****@*****.**>
  */
 private function load($request)
 {
     if (!$this->nav) {
         $temp_nav = null;
         $this->nav = [];
         $uri_hash = $request;
         $uri_pdo = '';
         $i = 1;
         foreach ($uri_hash as $hash) {
             $uri_pdo .= ':pid' . $i . ',';
             $i++;
         }
         $uri_pdo = rtrim($uri_pdo, ',');
         $sth = $this->dbPool->get('core')->con->prepare('SELECT * FROM `' . $this->dbPool->get('core')->prefix . 'nav` WHERE `nav_pid` IN(' . $uri_pdo . ') ORDER BY `nav_order` ASC');
         $i = 1;
         foreach ($uri_hash as $hash) {
             $sth->bindValue(':pid' . $i, $hash, \PDO::PARAM_STR);
             $i++;
         }
         $sth->execute();
         $temp_nav = $sth->fetchAll();
         foreach ($temp_nav as $link) {
             $this->nav[$link['nav_type']][$link['nav_subtype']][$link['nav_id']] = $link;
         }
     }
 }
 /**
  * Init cache
  *
  * @param mixed $options Options used to initialize the different caching types
  *
  * @since  1.0.0
  * @author Dennis Eichhorn <*****@*****.**>
  */
 public function init($options = null)
 {
     if ($options === null) {
         /* This is costing me 1ms, maybe init settings first cause i'm making another settings call later on -> same call 2 times */
         $sth = $this->dbPool->get('core')->con->prepare('SELECT `content` FROM `' . $this->dbPool->get('core')->prefix . 'settings` WHERE `id` = 1000000015');
         $sth->execute();
         $cache_data = $sth->fetchAll();
         $this->setOption('cache:type', (int) $cache_data[0][0]);
     } else {
         $this->options = $options;
     }
 }
示例#8
0
 /**
  * Install navigation element
  *
  * @param \phpOMS\DataStorage\Database\Pool $dbPool Database instance
  * @param array                             $data   Link info
  * @param int                               $parent Parent element (default is 0 for none)
  *
  * @since  1.0.0
  * @author Dennis Eichhorn <*****@*****.**>
  */
 private static function installLink($dbPool, $data, $parent = 0)
 {
     $sth = $dbPool->get('core')->con->prepare('INSERT INTO `' . $dbPool->get('core')->prefix . 'nav` (`nav_id`, `nav_pid`, `nav_name`, `nav_type`, `nav_subtype`, `nav_icon`, `nav_uri`, `nav_from`, `nav_order`, `nav_parent`, `nav_permission`) VALUES
                     (:id, :pid, :name, :type, :subtype, :icon, :uri, :from, :order, :parent, :perm);');
     $sth->bindValue(':id', $data['id'], \PDO::PARAM_INT);
     $sth->bindValue(':pid', $data['pid'], \PDO::PARAM_STR);
     $sth->bindValue(':name', $data['name'], \PDO::PARAM_STR);
     $sth->bindValue(':type', $data['type'], \PDO::PARAM_INT);
     $sth->bindValue(':subtype', $data['subtype'], \PDO::PARAM_INT);
     $sth->bindValue(':icon', $data['icon'], \PDO::PARAM_STR);
     $sth->bindValue(':uri', $data['uri'], \PDO::PARAM_STR);
     $sth->bindValue(':from', $data['from'], \PDO::PARAM_INT);
     $sth->bindValue(':order', $data['order'], \PDO::PARAM_INT);
     $sth->bindValue(':parent', $parent, \PDO::PARAM_INT);
     $sth->bindValue(':perm', $data['permission'], \PDO::PARAM_INT);
     $sth->execute();
     $lastInsertID = $dbPool->get('core')->con->lastInsertId();
     foreach ($data['children'] as $link) {
         $parent = $link['parent'] == null ? $lastInsertID : $link['parent'];
         self::installLink($dbPool, $link, $parent);
     }
 }
示例#9
0
 /**
  * Install module
  *
  * @param \phpOMS\DataStorage\Database\Pool $dbPool Database instance
  * @param array                             $info   Module info
  *
  * @since  1.0.0
  * @author Dennis Eichhorn <*****@*****.**>
  */
 public static function install($dbPool, $info)
 {
     switch ($dbPool->get('core')->getType()) {
         case \phpOMS\DataStorage\Database\DatabaseType::MYSQL:
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'payment_info` (
                         `payment_info_id` int(11) NOT NULL AUTO_INCREMENT,
                         `payment_info_account` int(11) DEFAULT NULL,
                         PRIMARY KEY (`payment_info_id`),
                         KEY `payment_info_account` (`payment_info_account`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'payment_info`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'payment_info_ibfk_1` FOREIGN KEY (`payment_info_account`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`);')->execute();
             break;
     }
 }
 /**
  * Install module
  *
  * @param \phpOMS\DataStorage\Database\Pool $dbPool Database instance
  * @param array                             $info   Module info
  *
  * @since  1.0.0
  * @author Dennis Eichhorn <*****@*****.**>
  */
 public static function install($dbPool, $info)
 {
     switch ($dbPool->get('core')->getType()) {
         case \phpOMS\DataStorage\Database\DatabaseType::MYSQL:
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'billing_invoice_element`
                     ADD KEY `billing_invoice_element_article` (`billing_invoice_element_article`),
                     ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'billing_invoice_element_ibfk_2` FOREIGN KEY (`billing_invoice_element_article`) REFERENCES `' . $dbPool->get('core')->prefix . 'itemreference` (`itemreference_id`);')->execute();
             break;
     }
 }
示例#11
0
 /**
  * Install module
  *
  * @param \phpOMS\DataStorage\Database\Pool $dbPool Database instance
  * @param array                             $info   Module info
  *
  * @since  1.0.0
  * @author Dennis Eichhorn <*****@*****.**>
  */
 public static function install($dbPool, $info)
 {
     switch ($dbPool->get('core')->getType()) {
         case \phpOMS\DataStorage\Database\DatabaseType::MYSQL:
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'arrival`
                     ADD KEY `arrival_media` (`arrival_media`),
                     ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'arrival_ibfk_3` FOREIGN KEY (`arrival_media`) REFERENCES `' . $dbPool->get('core')->prefix . 'media` (`media_id`);')->execute();
             break;
     }
 }
示例#12
0
 /**
  * Install module
  *
  * @param \phpOMS\DataStorage\Database\Pool $dbPool Database instance
  * @param array                             $info   Module info
  *
  * @since  1.0.0
  * @author Dennis Eichhorn <*****@*****.**>
  */
 public static function install($dbPool, $info)
 {
     switch ($dbPool->get('core')->getType()) {
         case \phpOMS\DataStorage\Database\DatabaseType::MYSQL:
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'hr_staff` (
                         `hr_staff_id` int(11) NOT NULL AUTO_INCREMENT,
                         `hr_staff_status` tinyint(2) DEFAULT NULL,
                         `hr_staff_account` int(11) DEFAULT NULL,
                         PRIMARY KEY (`hr_staff_id`),
                         KEY `hr_staff_account` (`hr_staff_account`)
                     )ENGINE=InnoDB  DEFAULT CHARSET=utf8;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'hr_staff`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'hr_staff_ibfk_1` FOREIGN KEY (`hr_staff_account`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'hr_staff_history` (
                         `hr_staff_history_id` int(11) NOT NULL AUTO_INCREMENT,
                         `hr_staff_history_staff` int(11) DEFAULT NULL,
                         `hr_staff_history_position` int(11) DEFAULT NULL,
                         `hr_staff_history_department` int(11) DEFAULT NULL,
                         `hr_staff_history_start` datetime DEFAULT NULL,
                         `hr_staff_history_end` datetime DEFAULT NULL,
                         PRIMARY KEY (`hr_staff_history_id`),
                         KEY `hr_staff_history_staff` (`hr_staff_history_staff`)
                     )ENGINE=InnoDB  DEFAULT CHARSET=utf8;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'hr_staff_history`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'hr_staff_history_ibfk_1` FOREIGN KEY (`hr_staff_history_staff`) REFERENCES `' . $dbPool->get('core')->prefix . 'hr_staff` (`hr_staff_id`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'hr_staff_contract` (
                         `hr_staff_contract_id` int(11) NOT NULL AUTO_INCREMENT,
                         `hr_staff_contract_stype` tinyint(1) DEFAULT NULL,
                         `hr_staff_contract_salary` decimal(8,2) DEFAULT NULL,
                         `hr_staff_contract_cformingbenefits` decimal(8,2) DEFAULT NULL,
                         `hr_staff_contract_working_hours` int(11) DEFAULT NULL,
                         `hr_staff_contract_vacation` tinyint(3) DEFAULT NULL,
                         `hr_staff_contract_vtype` tinyint(3) DEFAULT NULL,
                         `hr_staff_contract_personal_time` tinyint(3) DEFAULT NULL,
                         `hr_staff_contract_start` datetime DEFAULT NULL,
                         `hr_staff_contract_end` datetime DEFAULT NULL,
                         `hr_staff_contract_employee` int(11) DEFAULT NULL,
                         PRIMARY KEY (`hr_staff_contract_id`),
                         KEY `hr_staff_contract_employee` (`hr_staff_contract_employee`)
                     )ENGINE=InnoDB  DEFAULT CHARSET=utf8;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'hr_staff_contract`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'hr_staff_contract_ibfk_1` FOREIGN KEY (`hr_staff_contract_employee`) REFERENCES `' . $dbPool->get('core')->prefix . 'hr_staff` (`hr_staff_id`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'hr_planning_shift` (
                         `HRPlanningShiftID` int(11) NOT NULL AUTO_INCREMENT,
                         `amount` int(11) DEFAULT NULL,
                         `position` int(11) DEFAULT NULL,
                         `department` int(11) DEFAULT NULL,
                         `start` datetime DEFAULT NULL,
                         `end` datetime DEFAULT NULL,
                         PRIMARY KEY (`HRPlanningShiftID`),
                         KEY `department` (`department`)
                     )ENGINE=InnoDB  DEFAULT CHARSET=utf8;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'hr_planning_shift`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'hr_planning_shift_ibfk_1` FOREIGN KEY (`department`) REFERENCES `' . $dbPool->get('core')->prefix . 'business_department` (`business_department_id`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'hr_planning_staff` (
                         `HRPlanningStaffID` int(11) NOT NULL AUTO_INCREMENT,
                         `person` int(11) DEFAULT NULL,
                         `start` datetime DEFAULT NULL,
                         `end` datetime DEFAULT NULL,
                         `status` tinyint(1) NOT NULL,
                         `type` tinyint(1) NOT NULL,
                         `repeat` tinyint(1) NOT NULL,
                         `rep_interval` tinyint(3) NOT NULL,
                         `rep_monday` tinyint(1) NOT NULL,
                         `rep_tuesday` tinyint(1) NOT NULL,
                         `rep_wednesday` tinyint(1) NOT NULL,
                         `rep_thursday` tinyint(1) NOT NULL,
                         `rep_friday` tinyint(1) NOT NULL,
                         `rep_saturday` tinyint(1) NOT NULL,
                         `rep_sunday` tinyint(1) NOT NULL,
                         PRIMARY KEY (`HRPlanningStaffID`),
                         KEY `person` (`person`)
                     )ENGINE=InnoDB  DEFAULT CHARSET=utf8;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'hr_planning_staff`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'hr_planning_staff_ibfk_1` FOREIGN KEY (`person`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`);')->execute();
             break;
     }
 }
示例#13
0
 /**
  * Install module
  *
  * @param \phpOMS\DataStorage\Database\Pool $dbPool Database instance
  * @param array                             $info   Module info
  *
  * @since  1.0.0
  * @author Dennis Eichhorn <*****@*****.**>
  */
 public static function install($dbPool, $info)
 {
     switch ($dbPool->get('core')->getType()) {
         case \phpOMS\DataStorage\Database\DatabaseType::MYSQL:
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'profile_account` (
                         `profile_account_id` int(11) NOT NULL,
                         `profile_account_begin` datetime NOT NULL,
                         `profile_account_image` varchar(255) NOT NULL,
                         `profile_account_cv` text NOT NULL,
                         `profile_account_account` int(11) DEFAULT NULL,
                         PRIMARY KEY (`profile_account_id`),
                         KEY `profile_account_account` (`profile_account_account`)
                     )ENGINE=InnoDB  DEFAULT CHARSET=utf8;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'profile_account`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'profile_account_ibfk_1` FOREIGN KEY (`profile_account_account`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'profile_phone` (
                         `profile_phone_id` int(11) NOT NULL,
                         `profile_phone_type` tinyint(2) NOT NULL,
                         `profile_phone_number` varchar(50) NOT NULL,
                         `profile_phone_account` int(11) NOT NULL,
                         PRIMARY KEY (`profile_phone_id`),
                         KEY `profile_phone_account` (`profile_phone_account`)
                     )ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'profile_phone`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'profile_phone_ibfk_1` FOREIGN KEY (`profile_phone_account`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'profile_address` (
                         `profile_address_id` int(11) NOT NULL,
                         `profile_address_type` tinyint(2) NOT NULL,
                         `profile_address_address` varchar(50) NOT NULL,
                         `profile_address_street` varchar(50) NOT NULL,
                         `profile_address_city` varchar(50) NOT NULL,
                         `profile_address_zip` varchar(50) NOT NULL,
                         `profile_address_country` varchar(50) NOT NULL,
                         `profile_address_account` int(11) DEFAULT NULL,
                         PRIMARY KEY (`profile_address_id`),
                         KEY `profile_address_account` (`profile_address_account`)
                     )ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'profile_address`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'profile_address_ibfk_1` FOREIGN KEY (`profile_address_account`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'profile_account_relation` (
                         `profile_account_relation_id` int(11) NOT NULL,
                         `profile_account_relation_type` tinyint(2) NOT NULL,
                         `profile_account_relation_relation` int(11) DEFAULT NULL,
                         `profile_account_relation_account` int(11) DEFAULT NULL,
                         PRIMARY KEY (`profile_account_relation_id`),
                         KEY `profile_account_relation_account` (`profile_account_relation_account`)
                     )ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'profile_account_relation`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'profile_account_relation_ibfk_1` FOREIGN KEY (`profile_account_relation_account`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'profile_account_setting` (
                         `profile_account_setting_id` int(11) NOT NULL,
                         `profile_account_setting_module` int(11) NOT NULL,
                         `profile_account_setting_type` varchar(20) NOT NULL,
                         `profile_account_setting_value` varchar(32) DEFAULT NULL,
                         `profile_account_setting_account` int(11) DEFAULT NULL,
                         PRIMARY KEY (`profile_account_setting_id`),
                         KEY `profile_account_setting_account` (`profile_account_setting_account`)
                     )ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'profile_account_setting`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'profile_account_setting_ibfk_1` FOREIGN KEY (`profile_account_setting_account`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`);')->execute();
             break;
     }
 }
示例#14
0
 /**
  * Install module
  *
  * @param \phpOMS\DataStorage\Database\Pool $dbPool Database instance
  * @param array                             $info   Module info
  *
  * @since  1.0.0
  * @author Dennis Eichhorn <*****@*****.**>
  */
 public static function install($dbPool, $info)
 {
     switch ($dbPool->get('core')->getType()) {
         case \phpOMS\DataStorage\Database\DatabaseType::MYSQL:
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'area_manager_area` (
                         `area_manager_area_id` int(11) NOT NULL AUTO_INCREMENT,
                         `area_manager_area_name` varchar(50) NOT NULL,
                         PRIMARY KEY (`area_manager_area_id`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'area_manager_account` (
                         `area_manager_account_id` int(11) NOT NULL AUTO_INCREMENT,
                         `area_manager_account_start` datetime NOT NULL,
                         `area_manager_account_end` datetime NOT NULL,
                         `area_manager_account_account` int(11) NOT NULL,
                         `area_manager_account_area` int(11) NOT NULL,
                         PRIMARY KEY (`area_manager_account_id`),
                         KEY `area_manager_account_account` (`area_manager_account_account`),
                         KEY `area_manager_account_area` (`area_manager_account_area`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'area_manager_account`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'area_manager_account_ibfk_1` FOREIGN KEY (`area_manager_account_account`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`),
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'area_manager_account_ibfk_2` FOREIGN KEY (`area_manager_account_area`) REFERENCES `' . $dbPool->get('core')->prefix . 'area_manager_area` (`area_manager_area_id`);')->execute();
             break;
     }
 }
示例#15
0
 /**
  * Install module
  *
  * @param \phpOMS\DataStorage\Database\Pool $dbPool Database instance
  * @param array                             $info   Module info
  *
  * @since  1.0.0
  * @author Dennis Eichhorn <*****@*****.**>
  */
 public static function install($dbPool, $info)
 {
     switch ($dbPool->get('core')->getType()) {
         case \phpOMS\DataStorage\Database\DatabaseType::MYSQL:
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'chat_room` (
                         `chat_room_id` int(11) NOT NULL AUTO_INCREMENT,
                         `chat_room_name` varchar(25) NOT NULL,
                         `chat_room_password` varchar(64) NOT NULL,
                         `chat_room_description` varchar(255) NOT NULL,
                         `chat_room_creator` int(11) NOT NULL,
                         `chat_room_created` datetime NOT NULL,
                         PRIMARY KEY (`chat_room_id`),
                         KEY `chat_room_creator` (`chat_room_creator`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'chat_room`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'chat_room_ibfk_1` FOREIGN KEY (`chat_room_creator`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'chat_room_permission` (
                         `chat_room_permission_id` int(11) NOT NULL AUTO_INCREMENT,
                         `chat_room_permission_account` int(11) NOT NULL,
                         `chat_room_permission_room` int(11) NOT NULL,
                         `chat_room_permission_permission` tinyint(1) NOT NULL,
                         PRIMARY KEY (`chat_room_permission_id`),
                         KEY `chat_room_permission_account` (`chat_room_permission_account`),
                         KEY `chat_room_permission_room` (`chat_room_permission_room`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'chat_room_permission`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'chat_room_permission_ibfk_1` FOREIGN KEY (`chat_room_permission_account`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`),
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'chat_room_permission_ibfk_2` FOREIGN KEY (`chat_room_permission_room`) REFERENCES `' . $dbPool->get('core')->prefix . 'chat_room` (`chat_room_id`);')->execute();
             break;
     }
 }
示例#16
0
 /**
  * Install module
  *
  * @param \phpOMS\DataStorage\Database\Pool $dbPool Database instance
  * @param array                             $info   Module info
  *
  * @since  1.0.0
  * @author Dennis Eichhorn <*****@*****.**>
  */
 public static function install($dbPool, $info)
 {
     switch ($dbPool->get('core')->getType()) {
         case \phpOMS\DataStorage\Database\DatabaseType::MYSQL:
             $dbPool->get('core')->con->beginTransaction();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'task_template` (
                         `task_template_id` int(11) NOT NULL AUTO_INCREMENT,
                         `task_title` varchar(30) DEFAULT NULL,
                         `task_desc` text NOT NULL,
                         `task_created_by` int(11) NOT NULL,
                         `task_created_at` datetime NOT NULL,
                         PRIMARY KEY (`task_template_id`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             /**
              * task_visibility = 0 or 1
              * 0 everyone who ever received this task can see its current content
              * 1 only the current holder of a task can see its content
              */
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'task` (
                         `task_id` int(11) NOT NULL AUTO_INCREMENT,
                         `task_title` varchar(30) DEFAULT NULL,
                         `task_desc` text NOT NULL,
                         `task_plain` text NOT NULL,
                         `task_status` tinyint(3) NOT NULL,
                         `task_template` int(11) NOT NULL,
                         `task_visibility` tinyint(1) NOT NULL,
                         `task_due` datetime NOT NULL,
                         `task_done` datetime NOT NULL,
                         `task_creator` int(11) NOT NULL,
                         `task_created` datetime NOT NULL,
                         PRIMARY KEY (`task_id`),
                         KEY `task_creator` (`task_creator`),
                         KEY `task_template` (`task_template`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'task`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'task_ibfk_1` FOREIGN KEY (`task_creator`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`),
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'task_ibfk_2` FOREIGN KEY (`task_template`) REFERENCES `' . $dbPool->get('core')->prefix . 'task_template` (`task_template_id`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'task_element` (
                         `task_element_id` int(11) NOT NULL AUTO_INCREMENT,
                         `task_element_desc` text NOT NULL,
                         `task_element_plain` text NOT NULL,
                         `task_element_task` int(11) NOT NULL,
                         `task_element_creator` int(11) NOT NULL,
                         `task_element_status` tinyint(3) NOT NULL,
                         `task_element_due` datetime NOT NULL,
                         `task_element_forwarded` int(11) NOT NULL,
                         `task_element_created` datetime NOT NULL,
                         PRIMARY KEY (`task_element_id`),
                         KEY `task_element_task` (`task_element_task`),
                         KEY `task_element_creator` (`task_element_creator`),
                         KEY `task_element_forwarded` (`task_element_forwarded`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'task_element`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'task_element_ibfk_1` FOREIGN KEY (`task_element_task`) REFERENCES `' . $dbPool->get('core')->prefix . 'task` (`task_id`),
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'task_element_ibfk_2` FOREIGN KEY (`task_element_creator`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`),
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'task_element_ibfk_3` FOREIGN KEY (`task_element_forwarded`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'task_sub` (
                         `task_sub_id` int(11) NOT NULL AUTO_INCREMENT,
                         `task_sub_title` varchar(30) DEFAULT NULL,
                         `task_sub_desc` text NOT NULL,
                         `task_sub_plain` text NOT NULL,
                         `task_sub_status` tinyint(3) NOT NULL,
                         `task_sub_due` datetime NOT NULL,
                         `task_sub_done` datetime NOT NULL,
                         `task_sub_creator` int(11) NOT NULL,
                         `task_sub_created` datetime NOT NULL,
                         `task_sub_element` int(11) NOT NULL,
                         PRIMARY KEY (`task_sub_id`),
                         KEY `task_sub_creator` (`task_sub_creator`),
                         KEY `task_sub_element` (`task_sub_element`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'task_sub`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'task_sub_ibfk_1` FOREIGN KEY (`task_sub_creator`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`),
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'task_sub_ibfk_2` FOREIGN KEY (`task_sub_element`) REFERENCES `' . $dbPool->get('core')->prefix . 'task_element` (`task_element_id`);')->execute();
             $dbPool->get('core')->con->commit();
             break;
     }
 }
示例#17
0
 /**
  * Install module
  *
  * @param \phpOMS\DataStorage\Database\Pool $dbPool Database instance
  * @param array                             $info   Module info
  *
  * @since  1.0.0
  * @author Dennis Eichhorn <*****@*****.**>
  */
 public static function install($dbPool, $info)
 {
     switch ($dbPool->get('core')->getType()) {
         case \phpOMS\DataStorage\Database\DatabaseType::MYSQL:
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'riskmngmt_unit` (
                         `riskmngmt_unit_id` int(11) NOT NULL,
                         `riskmngmt_unit_unit` int(11) NOT NULL,
                         `riskmngmt_unit_responsible` int(11) NOT NULL,
                         PRIMARY KEY (`riskmngmt_unit_id`),
                         KEY `riskmngmt_unit_unit` (`riskmngmt_unit_unit`),
                         KEY `riskmngmt_unit_responsible` (`riskmngmt_unit_responsible`)
                     )ENGINE=InnoDB  DEFAULT CHARSET=utf8;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'riskmngmt_unit`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'riskmngmt_unit_ibfk_1` FOREIGN KEY (`riskmngmt_unit_unit`) REFERENCES `' . $dbPool->get('core')->prefix . 'business_unit` (`business_unit_id`),
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'riskmngmt_unit_ibfk_2` FOREIGN KEY (`riskmngmt_unit_responsible`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'riskmngmt_department` (
                         `riskmngmt_department_id` int(11) NOT NULL,
                         `riskmngmt_department_parent` int(11) NOT NULL,
                         `riskmngmt_department_responsible` int(11) NOT NULL,
                         PRIMARY KEY (`riskmngmt_department_id`),
                         KEY `riskmngmt_department_parent` (`riskmngmt_department_parent`),
                         KEY `riskmngmt_department_responsible` (`riskmngmt_department_responsible`)
                     )ENGINE=InnoDB  DEFAULT CHARSET=utf8;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'riskmngmt_department`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'riskmngmt_department_ibfk_1` FOREIGN KEY (`riskmngmt_department_parent`) REFERENCES `' . $dbPool->get('core')->prefix . 'business_department` (`business_department_id`),
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'riskmngmt_department_ibfk_2` FOREIGN KEY (`riskmngmt_department_responsible`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'riskmngmt_category` (
                         `riskmngmt_category_id` int(11) NOT NULL,
                         `riskmngmt_category_name` varchar(50) NOT NULL,
                         `riskmngmt_category_parent` int(11) DEFAULT NULL,
                         `riskmngmt_category_responsible` int(11) NOT NULL,
                         PRIMARY KEY (`riskmngmt_category_id`),
                         KEY `riskmngmt_category_parent` (`riskmngmt_category_parent`),
                         KEY `riskmngmt_category_responsible` (`riskmngmt_category_responsible`)
                     )ENGINE=InnoDB  DEFAULT CHARSET=utf8;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'riskmngmt_category`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'riskmngmt_category_ibfk_1` FOREIGN KEY (`riskmngmt_category_parent`) REFERENCES `' . $dbPool->get('core')->prefix . 'riskmngmt_category` (`riskmngmt_category_id`),
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'riskmngmt_category_ibfk_2` FOREIGN KEY (`riskmngmt_category_responsible`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`);')->execute();
             // TODO: more (media, start, end etc...)
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'riskmngmt_project` (
                         `riskmngmt_project_id` int(11) NOT NULL,
                         `riskmngmt_project_name` varchar(50) NOT NULL,
                         `riskmngmt_project_description` text NOT NULL,
                         `riskmngmt_project_unit` int(11) NOT NULL,
                         `riskmngmt_project_responsible` int(11) NOT NULL,
                         PRIMARY KEY (`riskmngmt_project_id`),
                         KEY `riskmngmt_project_unit` (`riskmngmt_project_unit`),
                         KEY `riskmngmt_project_responsible` (`riskmngmt_project_responsible`)
                     )ENGINE=InnoDB  DEFAULT CHARSET=utf8;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'riskmngmt_project`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'riskmngmt_project_ibfk_1` FOREIGN KEY (`riskmngmt_project_unit`) REFERENCES `' . $dbPool->get('core')->prefix . 'business_unit` (`business_unit_id`),
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'riskmngmt_project_ibfk_2` FOREIGN KEY (`riskmngmt_project_responsible`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`);')->execute();
             // TODO: more (media, start, end etc...)
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'riskmngmt_process` (
                         `riskmngmt_process_id` int(11) NOT NULL,
                         `riskmngmt_process_name` varchar(50) NOT NULL,
                         `riskmngmt_process_description` text NOT NULL,
                         `riskmngmt_process_unit` int(11) NOT NULL,
                         `riskmngmt_process_responsible` int(11) NOT NULL,
                         PRIMARY KEY (`riskmngmt_process_id`),
                         KEY `riskmngmt_process_unit` (`riskmngmt_process_unit`),
                         KEY `riskmngmt_process_responsible` (`riskmngmt_process_responsible`)
                     )ENGINE=InnoDB  DEFAULT CHARSET=utf8;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'riskmngmt_process`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'riskmngmt_process_ibfk_1` FOREIGN KEY (`riskmngmt_process_unit`) REFERENCES `' . $dbPool->get('core')->prefix . 'business_unit` (`business_unit_id`),
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'riskmngmt_process_ibfk_2` FOREIGN KEY (`riskmngmt_process_responsible`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'riskmngmt_risk` (
                         `riskmngmt_risk_id` int(11) NOT NULL,
                         `riskmngmt_risk_name` varchar(50) NOT NULL,
                         `riskmngmt_risk_description` text NOT NULL,
                         `riskmngmt_risk_unit` int(11) NOT NULL,
                         `riskmngmt_risk_deptartment` int(11) NOT NULL,
                         `riskmngmt_risk_category` int(11) NOT NULL,
                         `riskmngmt_risk_project` int(11) NOT NULL,
                         `riskmngmt_risk_process` int(11) NOT NULL,
                         `riskmngmt_risk_responsible` int(11) NOT NULL,
                         `riskmngmt_risk_backup` int(11) NOT NULL,
                         PRIMARY KEY (`riskmngmt_risk_id`),
                         KEY `riskmngmt_risk_unit` (`riskmngmt_risk_unit`),
                         KEY `riskmngmt_risk_responsible` (`riskmngmt_risk_responsible`)
                     )ENGINE=InnoDB  DEFAULT CHARSET=utf8;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'riskmngmt_risk`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'riskmngmt_risk_ibfk_1` FOREIGN KEY (`riskmngmt_risk_unit`) REFERENCES `' . $dbPool->get('core')->prefix . 'business_unit` (`business_unit_id`),
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'riskmngmt_risk_ibfk_2` FOREIGN KEY (`riskmngmt_risk_responsible`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'riskmngmt_risk_object` (
                         `riskmngmt_risk_object_id` int(11) NOT NULL,
                         `riskmngmt_risk_object_name` varchar(50) NOT NULL,
                         `riskmngmt_risk_object_risk` int(11) NOT NULL,
                         PRIMARY KEY (`riskmngmt_risk_object_id`),
                         KEY `riskmngmt_risk_object_risk` (`riskmngmt_risk_object_risk`)
                     )ENGINE=InnoDB  DEFAULT CHARSET=utf8;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'riskmngmt_risk_object`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'riskmngmt_risk_object_ibfk_1` FOREIGN KEY (`riskmngmt_risk_object_risk`) REFERENCES `' . $dbPool->get('core')->prefix . 'riskmngmt_risk` (`riskmngmt_risk_id`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'riskmngmt_risk_eval` (
                         `riskmngmt_risk_eval_id` int(11) NOT NULL,
                         `riskmngmt_risk_eval_val` decimal(11,4) NOT NULL,
                         `riskmngmt_risk_eval_object` int(11) NOT NULL,
                         PRIMARY KEY (`riskmngmt_risk_eval_id`),
                         KEY `riskmngmt_risk_eval_object` (`riskmngmt_risk_eval_object`)
                     )ENGINE=InnoDB  DEFAULT CHARSET=utf8;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'riskmngmt_risk_eval`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'riskmngmt_risk_evaluation_ibfk_1` FOREIGN KEY (`riskmngmt_risk_eval_object`) REFERENCES `' . $dbPool->get('core')->prefix . 'riskmngmt_risk_object` (`riskmngmt_risk_object_id`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'riskmngmt_risk_media` (
                         `riskmngmt_risk_media_id` int(11) NOT NULL,
                         `riskmngmt_risk_media_media` int(11) NOT NULL,
                         PRIMARY KEY (`riskmngmt_risk_media_id`),
                         KEY `riskmngmt_risk_media_media` (`riskmngmt_risk_media_media`)
                     )ENGINE=InnoDB  DEFAULT CHARSET=utf8;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'riskmngmt_risk_media`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'riskmngmt_risk_media_ibfk_1` FOREIGN KEY (`riskmngmt_risk_media_media`) REFERENCES `' . $dbPool->get('core')->prefix . 'media` (`media_id`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'riskmngmt_risk_cause` (
                         `riskmngmt_risk_cause_id` int(11) NOT NULL,
                         `riskmngmt_risk_cause_name` varchar(50) NOT NULL,
                         `riskmngmt_risk_cause_description` text NOT NULL,
                         `riskmngmt_risk_cause_probability` smallint(6) NOT NULL,
                         `riskmngmt_risk_cause_deptartment` int(11) NOT NULL,
                         `riskmngmt_risk_cause_category` int(11) NOT NULL,
                         `riskmngmt_risk_cause_risk` int(11) NOT NULL,
                         PRIMARY KEY (`riskmngmt_risk_cause_id`),
                         KEY `riskmngmt_risk_cause_deptartment` (`riskmngmt_risk_cause_deptartment`),
                         KEY `riskmngmt_risk_cause_category` (`riskmngmt_risk_cause_category`),
                         KEY `riskmngmt_risk_cause_risk` (`riskmngmt_risk_cause_risk`)
                     )ENGINE=InnoDB  DEFAULT CHARSET=utf8;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'riskmngmt_risk_cause`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'riskmngmt_risk_cause_ibfk_1` FOREIGN KEY (`riskmngmt_risk_cause_risk`) REFERENCES `' . $dbPool->get('core')->prefix . 'riskmngmt_risk` (`riskmngmt_risk_id`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'riskmngmt_risk_solution` (
                         `riskmngmt_risk_solution_id` int(11) NOT NULL,
                         `riskmngmt_risk_solution_name` varchar(50) NOT NULL,
                         `riskmngmt_risk_solution_description` text NOT NULL,
                         `riskmngmt_risk_solution_probability` smallint(6) NOT NULL,
                         `riskmngmt_risk_solution_effect` decimal(11,4) NOT NULL,
                         `riskmngmt_risk_solution_cause` int(11) NOT NULL,
                         `riskmngmt_risk_solution_risk` int(11) NOT NULL,
                         PRIMARY KEY (`riskmngmt_risk_solution_id`),
                         KEY `riskmngmt_risk_solution_cause` (`riskmngmt_risk_solution_cause`),
                         KEY `riskmngmt_risk_solution_risk` (`riskmngmt_risk_solution_risk`)
                     )ENGINE=InnoDB  DEFAULT CHARSET=utf8;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'riskmngmt_risk_solution`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'riskmngmt_risk_solution_ibfk_1` FOREIGN KEY (`riskmngmt_risk_solution_cause`) REFERENCES `' . $dbPool->get('core')->prefix . 'riskmngmt_risk_cause` (`riskmngmt_risk_cause_id`),
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'riskmngmt_risk_solution_ibfk_2` FOREIGN KEY (`riskmngmt_risk_solution_risk`) REFERENCES `' . $dbPool->get('core')->prefix . 'riskmngmt_risk` (`riskmngmt_risk_id`);')->execute();
             break;
     }
 }
示例#18
0
 /**
  * Install module
  *
  * @param \phpOMS\DataStorage\Database\Pool $dbPool Database instance
  * @param array                             $info   Module info
  *
  * @since  1.0.0
  * @author Dennis Eichhorn <*****@*****.**>
  */
 public static function install($dbPool, $info)
 {
     switch ($dbPool->get('core')->getType()) {
         case \phpOMS\DataStorage\Database\DatabaseType::MYSQL:
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'purchase_article` (
                         `purchase_article_id` int(11) NOT NULL AUTO_INCREMENT,
                         `purchase_article_item` int(11) DEFAULT NULL,
                         PRIMARY KEY (`purchase_article_id`),
                         KEY `purchase_article_item` (`purchase_article_item`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'purchase_article`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'purchase_article_ibfk_1` FOREIGN KEY (`purchase_article_item`) REFERENCES `' . $dbPool->get('core')->prefix . 'itemreference` (`itemreference_id`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'purchase_supplier` (
                         `purchase_supplier_id` int(11) NOT NULL AUTO_INCREMENT,
                         `purchase_supplier_account` int(11) NOT NULL,
                         PRIMARY KEY (`purchase_supplier_id`),
                         KEY `account` (`purchase_supplier_account`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'purchase_supplier`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'purchase_supplier_ibfk_1` FOREIGN KEY (`purchase_supplier_account`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`);')->execute();
             // TODO: create reference between WE, RG and Order?????
             /* These are the invoices that get created by the purchasing department */
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'purchase_invoice` (
                         `purchase_invoice_id` int(11) NOT NULL AUTO_INCREMENT,
                         `purchase_invoice_status` tinyint(2) DEFAULT NULL,
                         `purchase_invoice_type` tinyint(2) DEFAULT NULL,
                         `purchase_invoice_created` datetime DEFAULT NULL,
                         `purchase_invoice_printed` datetime DEFAULT NULL,
                         `purchase_invoice_price` decimal(9,2) DEFAULT NULL,
                         `purchase_invoice_currency` varchar(3) DEFAULT NULL,
                         `purchase_invoice_creator` int(11) NOT NULL,
                         `purchase_invoice_supplier` int(11) NOT NULL,
                         `purchase_invoice_referer` int(11) NOT NULL,
                         PRIMARY KEY (`purchase_invoice_id`),
                         KEY `purchase_invoice_creator` (`purchase_invoice_creator`),
                         KEY `purchase_invoice_supplier` (`purchase_invoice_supplier`),
                         KEY `purchase_invoice_referer` (`purchase_invoice_referer`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'purchase_invoice`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'purchase_invoice_ibfk_1` FOREIGN KEY (`purchase_invoice_creator`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`),
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'purchase_invoice_ibfk_2` FOREIGN KEY (`purchase_invoice_supplier`) REFERENCES `' . $dbPool->get('core')->prefix . 'purchase_supplier` (`purchase_supplier_id`),
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'purchase_invoice_ibfk_3` FOREIGN KEY (`purchase_invoice_referer`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`);')->execute();
             break;
     }
 }
示例#19
0
 /**
  * Install module
  *
  * @param \phpOMS\DataStorage\Database\Pool $dbPool Database instance
  * @param array                             $info   Module info
  *
  * @since  1.0.0
  * @author Dennis Eichhorn <*****@*****.**>
  */
 public static function install($dbPool, $info)
 {
     switch ($dbPool->get('core')->getType()) {
         case \phpOMS\DataStorage\Database\DatabaseType::MYSQL:
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'warehousing_stock` (
                         `WarehousingStockID` int(11) NOT NULL AUTO_INCREMENT,
                         `name` varchar(50) DEFAULT NULL,
                         PRIMARY KEY (`WarehousingStockID`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'warehousing_stock_location` (
                         `WarehousingStockLocationID` int(11) NOT NULL AUTO_INCREMENT,
                         `name` varchar(50) DEFAULT NULL,
                         `stock` int(11) DEFAULT NULL,
                         PRIMARY KEY (`WarehousingStockLocationID`),
                         KEY `stock` (`stock`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'warehousing_stock_location`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'warehousing_stock_location_ibfk_1` FOREIGN KEY (`stock`) REFERENCES `' . $dbPool->get('core')->prefix . 'warehousing_stock` (`WarehousingStockID`);')->execute();
             // TODO: complete
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'warehousing_article` (
                         `WarehousingArticleID` int(11) NOT NULL AUTO_INCREMENT,
                         `weight` int(11) DEFAULT NULL,
                         `dimension` varchar(17) DEFAULT NULL,
                         `volume` int(11) DEFAULT NULL,
                         `lot` tinyint(1) DEFAULT NULL,
                         `status` tinyint(2) DEFAULT NULL,
                         PRIMARY KEY (`WarehousingArticleID`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'warehousing_article_disposal` (
                         `WarehousingArticleID` int(11) NOT NULL AUTO_INCREMENT,
                         `glas` int(11) DEFAULT NULL,
                         `paper` int(11) DEFAULT NULL,
                         `sheet` int(11) DEFAULT NULL,
                         `aluminium` int(11) DEFAULT NULL,
                         `synthetic` int(11) DEFAULT NULL,
                         `cardboard` int(11) DEFAULT NULL,
                         `composites` int(11) DEFAULT NULL,
                         `organic` int(11) DEFAULT NULL,
                         `pe` int(11) DEFAULT NULL,
                         `misc` int(11) DEFAULT NULL,
                         PRIMARY KEY (`WarehousingArticleID`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             // WE kann von client oder supplier kommen, deswegen type
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'warehousing_arrival` (
                         `WarehousingArrivalID` int(11) NOT NULL AUTO_INCREMENT,
                         `arrivaldate` datetime DEFAULT NULL,
                         `from` int(11) DEFAULT NULL,
                         `type` tinyint(1) DEFAULT NULL,
                         `media` int(11) DEFAULT NULL,
                         `pcondition` tinyint(1) DEFAULT NULL,
                         `acondition` tinyint(1) DEFAULT NULL,
                         `amount` tinyint(1) DEFAULT NULL,
                         `checked` int(11) DEFAULT NULL,
                         `dnote` int(11) DEFAULT NULL,
                         PRIMARY KEY (`WarehousingArrivalID`),
                         KEY `checked` (`checked`),
                         KEY `dnote` (`dnote`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'warehousing_arrival`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'warehousing_arrival_ibfk_1` FOREIGN KEY (`checked`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`);')->execute();
             /* info: amount will get increased and reduced based on invoices -> will result in a high amount of entries where the amount is 0 -> long lookup times for available lot lookup?! */
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'warehousing_article_stock` (
                         `WarehousingArticleStockID` int(11) NOT NULL AUTO_INCREMENT,
                         `article` int(11) DEFAULT NULL,
                         `lot` varchar(256) DEFAULT NULL,
                         `sn` varchar(256) DEFAULT NULL,
                         `durability` datetime DEFAULT NULL,
                         `arrival` int(11) DEFAULT NULL,
                         `amount` mediumint(9) DEFAULT NULL,
                         `location` int(11) DEFAULT NULL,
                         PRIMARY KEY (`WarehousingArticleStockID`),
                         KEY `article` (`article`),
                         KEY `arrival` (`arrival`),
                         KEY `location` (`location`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'warehousing_article_stock`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'warehousing_article_stock_ibfk_1` FOREIGN KEY (`article`) REFERENCES `' . $dbPool->get('core')->prefix . 'warehousing_article` (`WarehousingArticleID`),
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'warehousing_article_stock_ibfk_2` FOREIGN KEY (`arrival`) REFERENCES `' . $dbPool->get('core')->prefix . 'warehousing_arrival` (`WarehousingArrivalID`),
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'warehousing_article_stock_ibfk_3` FOREIGN KEY (`location`) REFERENCES `' . $dbPool->get('core')->prefix . 'warehousing_stock_location` (`WarehousingStockLocationID`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'warehousing_arrival_transfer` (
                         `WarehousingArrivalTransferID` int(11) NOT NULL AUTO_INCREMENT,
                         `location` int(11) DEFAULT NULL,
                         `amount` int(11) DEFAULT NULL,
                         `arrival` int(11) DEFAULT NULL,
                         PRIMARY KEY (`WarehousingArrivalTransferID`),
                         KEY `location` (`location`),
                         KEY `arrival` (`arrival`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'warehousing_arrival_transfer`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'warehousing_arrival_transfer_ibfk_1` FOREIGN KEY (`location`) REFERENCES `' . $dbPool->get('core')->prefix . 'warehousing_article_stock` (`WarehousingArticleStockID`),
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'warehousing_arrival_transfer_ibfk_2` FOREIGN KEY (`arrival`) REFERENCES `' . $dbPool->get('core')->prefix . 'warehousing_arrival` (`WarehousingArrivalID`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'warehousing_article_transfer` (
                         `WarehousingArticleTransferID` int(11) NOT NULL AUTO_INCREMENT,
                         `name` varchar(50) DEFAULT NULL,
                         `creator` int(11) DEFAULT NULL,
                         `created` datetime DEFAULT NULL,
                         PRIMARY KEY (`WarehousingArticleTransferID`),
                         KEY `creator` (`creator`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'warehousing_article_transfer`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'warehousing_article_transfer_ibfk_1` FOREIGN KEY (`creator`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'warehousing_article_transfer_single` (
                         `WarehousingArticleStockID` int(11) NOT NULL AUTO_INCREMENT,
                         `old` int(11) DEFAULT NULL,
                         `new` int(11) DEFAULT NULL,
                         `amount` int(11) DEFAULT NULL,
                         `transfer` int(11) DEFAULT NULL,
                         PRIMARY KEY (`WarehousingArticleStockID`),
                         KEY `old` (`old`),
                         KEY `new` (`new`),
                         KEY `transfer` (`transfer`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'warehousing_article_transfer_single`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'warehousing_article_transfer_single_ibfk_1` FOREIGN KEY (`old`) REFERENCES `' . $dbPool->get('core')->prefix . 'warehousing_article_stock` (`WarehousingArticleStockID`),
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'warehousing_article_transfer_single_ibfk_2` FOREIGN KEY (`new`) REFERENCES `' . $dbPool->get('core')->prefix . 'warehousing_article_stock` (`WarehousingArticleStockID`),
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'warehousing_article_transfer_single_ibfk_3` FOREIGN KEY (`transfer`) REFERENCES `' . $dbPool->get('core')->prefix . 'warehousing_article_transfer` (`WarehousingArticleTransferID`);')->execute();
             // TODO: maybe consider chaning shipCountry varchar to size 55 (based on ISO 3166-1) (same goes for sales department tables)
             // TODO: create shipFrom table = business address of your company (maybe multiple)
             // TODO: implement ups fields make sure to use multiple tables (multiple packages)
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'warehousing_shipping` (
                         `WarehousingShippingID` int(11) NOT NULL AUTO_INCREMENT,
                         `shippingdate` datetime DEFAULT NULL,
                         `shipTo` varchar(50) DEFAULT NULL,
                         `shipFAO` varchar(30) DEFAULT NULL,
                         `shipAddr` varchar(50) DEFAULT NULL,
                         `shipCity` varchar(20) DEFAULT NULL,
                         `shipState` varchar(30) DEFAULT NULL,
                         `shipZip` varchar(20) DEFAULT NULL,
                         `shipCountry` varchar(30) DEFAULT NULL,
                         `shipPhone` varchar(30) DEFAULT NULL,
                         `shipFrom` int(11) DEFAULT NULL,
                         `carrier` varchar(30) DEFAULT NULL,
                         `tracking` varchar(7089) DEFAULT NULL,
                         `client` int(11) DEFAULT NULL,
                         `invoice` int(11) DEFAULT NULL,
                         `shipped` int(11) DEFAULT NULL,
                         PRIMARY KEY (`WarehousingShippingID`),
                         KEY `shipFrom` (`shipFrom`),
                         KEY `shipped` (`shipped`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'warehousing_shipping`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'warehousing_shipping_ibfk_1` FOREIGN KEY (`shipFrom`) REFERENCES `' . $dbPool->get('core')->prefix . 'business_address` (`business_address_id`),
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'warehousing_shipping_ibfk_2` FOREIGN KEY (`shipped`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`);')->execute();
             break;
     }
 }
示例#20
0
 /**
  * Install module
  *
  * @param \phpOMS\DataStorage\Database\Pool $dbPool Database instance
  * @param array                             $info   Module info
  *
  * @since  1.0.0
  * @author Dennis Eichhorn <*****@*****.**>
  */
 public static function install($dbPool, $info)
 {
     switch ($dbPool->get('core')->getType()) {
         case \phpOMS\DataStorage\Database\DatabaseType::MYSQL:
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'accounting_account` (
                         `accounting_account_id` int(11) NOT NULL AUTO_INCREMENT,
                         `accounting_account_name` varchar(25) NOT NULL,
                         `accounting_account_description` varchar(255) NOT NULL,
                         `accounting_account_type` tinyint(1) NOT NULL,
                         `accounting_account_parent` int(11) NOT NULL,
                         PRIMARY KEY (`accounting_account_id`),
                         KEY `accounting_account_parent` (`accounting_account_parent`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'accounting_account`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'accounting_account_ibfk_1` FOREIGN KEY (`accounting_account_parent`) REFERENCES `' . $dbPool->get('core')->prefix . 'accounting_account` (`accounting_account_id`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'accounting_batch` (
                         `accounting_batch_id` int(11) NOT NULL AUTO_INCREMENT,
                         `accounting_batch_title` varchar(30) NOT NULL,
                         `accounting_batch_creator` int(11) NOT NULL,
                         `accounting_batch_created`datetime NOT NULL,
                         `accounting_batch_type` tinyint(1) NOT NULL,
                         PRIMARY KEY (`accounting_batch_id`),
                         KEY `accounting_batch_creator` (`accounting_batch_creator`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'accounting_batch`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'accounting_batch_ibfk_1` FOREIGN KEY (`accounting_batch_creator`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'accounting_posting` (
                         `accounting_posting_id` int(11) NOT NULL AUTO_INCREMENT,
                         `accounting_posting_batch` int(11) NOT NULL,
                         `accounting_posting_receipt` int(11) DEFAULT NULL,
                         `accounting_posting_receipt_ext` int(11) DEFAULT NULL,
                         `accounting_posting_price` decimal(11,3) NOT NULL,
                         `accounting_posting_affiliation` datetime NOT NULL,
                         PRIMARY KEY (`accounting_posting_id`),
                         KEY `accounting_posting_batch` (`accounting_posting_batch`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'accounting_posting`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'accounting_posting_ibfk_1` FOREIGN KEY (`accounting_posting_batch`) REFERENCES `' . $dbPool->get('core')->prefix . 'accounting_batch` (`accounting_batch_id`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'accounting_posting_ele` (
                         `accounting_posting_ele_id` int(11) NOT NULL AUTO_INCREMENT,
                         `accounting_posting_ele_type` tinyint(1) NOT NULL,
                         `accounting_posting_ele_account` int(11) NOT NULL,
                         `accounting_posting_ele_value` decimal(11,3) NOT NULL,
                         `accounting_posting_ele_tax` tinyint(1) NOT NULL,
                         PRIMARY KEY (`accounting_posting_ele_id`),
                         KEY `accounting_posting_ele_account` (`accounting_posting_ele_account`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'accounting_posting_ele`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'accounting_posting_ele_ibfk_1` FOREIGN KEY (`accounting_posting_ele_account`) REFERENCES `' . $dbPool->get('core')->prefix . 'accounting_account` (`accounting_account_id`);')->execute();
             /*
              * type = (offer, confirmation etc.)
              * soptained = date of when we received the service/order (not the invoice)
              * check = person who checked or is supposed to check the invoice
              * checked = date of when the invoice got approved (no datetime = no approval)
              * posting referes (direct)
              * payment referes to this (indirect)
              * status {
              *  blank
              *  received-ok
              *  received-notok
              *  checked-ok
              *  checked-notok
              *  posted-ok
              *  posted-notok
              *  payed-ok
              *  payed-notok
              * }
              */
             /*
              * TODO: Purchasing can create. person who creates automatically get's permission for these to read.
              * TODO: move to different module
              */
             /*
                             $dbPool->get('core')->con->prepare(
                                 'CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'accounting_invoices_process` (
                                     `AccountingInvoiceProcessID` int(11) NOT NULL AUTO_INCREMENT,
                                     `media` int(11) DEFAULT NULL,
                                     `type` tinyint(1) DEFAULT NULL,
                                     `supplier` int(11) DEFAULT NULL,
                                     `sname` varchar(32) DEFAULT NULL,
                                     `optained` datetime NOT NULL,
                                     `soptained` datetime NOT NULL,
                                     `refnumber` varchar(24) NOT NULL,
                                     `invoicedate` datetime NOT NULL,
                                     `internalref` int(11) NOT NULL,
                                     `due` datetime NOT NULL,
                                     `duediscount` datetime NOT NULL,
                                     `amount` decimal(11,3) NOT NULL,
                                     `amountdiscount` decimal(11,3) NOT NULL,
                                     `order` int(11) DEFAULT NULL,
                                     `arrival` int(11) DEFAULT NULL,
                                     `dnote` int(11) DEFAULT NULL,
                                     PRIMARY KEY (`AccountingInvoiceProcessID`),
                                     KEY `media` (`media`),
                                     KEY `order` (`order`),
                                     KEY `arrival` (`arrival`),
                                     KEY `dnote` (`dnote`)
                                 )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;'
                             )->execute();
             
                             $dbPool->get('core')->con->prepare(
                                 'ALTER TABLE `' . $dbPool->get('core')->prefix . 'accounting_invoices_process`
                                     ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'accounting_invoices_process_ibfk_1` FOREIGN KEY (`media`) REFERENCES `' . $dbPool->get('core')->prefix . 'media` (`media_id`),
                                     ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'accounting_invoices_process_ibfk_2` FOREIGN KEY (`order`) REFERENCES `' . $dbPool->get('core')->prefix . 'purchase_invoices` (`PurchaseInvoiceID`),
                                     ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'accounting_invoices_process_ibfk_3` FOREIGN KEY (`arrival`) REFERENCES `' . $dbPool->get('core')->prefix . 'warehousing_arrival` (`WarehousingArrivalID`),
                                     ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'accounting_invoices_process_ibfk_4` FOREIGN KEY (`dnote`) REFERENCES `' . $dbPool->get('core')->prefix . 'purchase_dnote` (`PurchaseDnoteID`);'
                             )->execute();
             
                             $dbPool->get('core')->con->prepare(
                                 'CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'accounting_invoices_status` (
                                     `AccountingInvoiceStatusID` int(11) NOT NULL AUTO_INCREMENT,
                                     `invoice` int(11) DEFAULT NULL,
                                     `status` tinyint(1) DEFAULT NULL,
                                     `person` int(11) DEFAULT NULL,
                                     `changed` datetime DEFAULT NULL,
                                     `info` varchar(256) NOT NULL,
                                     PRIMARY KEY (`AccountingInvoiceStatusID`),
                                     KEY `invoice` (`invoice`),
                                     KEY `person` (`person`)
                                 )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;'
                             )->execute();
             
                             $dbPool->get('core')->con->prepare(
                                 'ALTER TABLE `' . $dbPool->get('core')->prefix . 'accounting_invoices_status`
                                     ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'accounting_invoices_status_ibfk_1` FOREIGN KEY (`invoice`) REFERENCES `' . $dbPool->get('core')->prefix . 'accounting_invoices_process` (`AccountingInvoiceProcessID`),
                                     ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'accounting_invoices_status_ibfk_2` FOREIGN KEY (`person`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`);'
                             )->execute();
             
                             $dbPool->get('core')->con->prepare(
                                 'CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'accounting_invoices_process_permission` (
                                     `AccountingInvoiceProcessPermissionID` int(11) NOT NULL AUTO_INCREMENT,
                                     `process` int(11) DEFAULT NULL,
                                     `person` int(11) DEFAULT NULL,
                                     `permission` int(11) DEFAULT NULL,
                                     PRIMARY KEY (`AccountingInvoiceProcessPermissionID`),
                                     KEY `person` (`person`),
                                     KEY `process` (`process`)
                                 )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;'
                             )->execute();
             
                             $dbPool->get('core')->con->prepare(
                                 'ALTER TABLE `' . $dbPool->get('core')->prefix . 'accounting_invoices_process_permission`
                                     ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'accounting_invoices_process_permission_ibfk_1` FOREIGN KEY (`person`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`),
                                     ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'accounting_invoices_process_permission_ibfk_2` FOREIGN KEY (`process`) REFERENCES `' . $dbPool->get('core')->prefix . 'accounting_invoices_process` (`AccountingInvoiceProcessID`);'
                             )->execute();*/
             break;
     }
 }
示例#21
0
 /**
  * Install module
  *
  * @param \phpOMS\DataStorage\Database\Pool $dbPool Database instance
  * @param array                             $info   Module info
  *
  * @since  1.0.0
  * @author Dennis Eichhorn <*****@*****.**>
  */
 public static function install($dbPool, $info)
 {
     switch ($dbPool->get('core')->getType()) {
         case \phpOMS\DataStorage\Database\DatabaseType::MYSQL:
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'news` (
                         `news_id` int(11) NOT NULL AUTO_INCREMENT,
                         `news_title` varchar(250) NOT NULL,
                         `news_featured` tinyint(1) DEFAULT NULL,
                         `news_content` text NOT NULL,
                         `news_plain` text NOT NULL,
                         `news_type` tinyint(2) NOT NULL,
                         `news_lang` tinyint(2) NOT NULL,
                         `news_publish` datetime NOT NULL,
                         `news_created` datetime NOT NULL,
                         `news_author` int(11) NOT NULL,
                         `news_last_changed` datetime NOT NULL,
                         `news_last_change` int(11) NOT NULL,
                         PRIMARY KEY (`news_id`),
                         KEY `news_author` (`news_author`),
                         KEY `news_last_change` (`news_last_change`)
                     )ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'news`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'news_ibfk_1` FOREIGN KEY (`news_author`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`),
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'news_ibfk_2` FOREIGN KEY (`news_last_change`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'news_tag` (
                         `news_tag_id` int(11) NOT NULL AUTO_INCREMENT,
                         `news_tag_news` int(11) NOT NULL,
                         `news_tag_tag` varchar(20) NOT NULL,
                         PRIMARY KEY (`news_tag_id`),
                         KEY `news_tag_news` (`news_tag_news`)
                     )ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'news_tag`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'news_tag_ibfk_1` FOREIGN KEY (`news_tag_news`) REFERENCES `' . $dbPool->get('core')->prefix . 'news` (`news_id`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'news_group` (
                         `news_group_id` int(11) NOT NULL AUTO_INCREMENT,
                         `news_group_news` int(11) NOT NULL,
                         `news_group_group` int(11) NOT NULL,
                         PRIMARY KEY (`news_group_id`),
                         KEY `news_group_news` (`news_group_news`)
                     )ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'news_group`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'news_group_ibfk_1` FOREIGN KEY (`news_group_news`) REFERENCES `' . $dbPool->get('core')->prefix . 'news` (`news_id`);')->execute();
             break;
     }
 }
示例#22
0
 /**
  * Install module
  *
  * @param \phpOMS\DataStorage\Database\Pool $dbPool Database instance
  * @param array                             $info   Module info
  *
  * @since  1.0.0
  * @author Dennis Eichhorn <*****@*****.**>
  */
 public static function install($dbPool, $info)
 {
     switch ($dbPool->get('core')->getType()) {
         case \phpOMS\DataStorage\Database\DatabaseType::MYSQL:
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'media` (
                         `media_id` int(11) NOT NULL AUTO_INCREMENT,
                         `media_name`  varchar(100) NOT NULL,
                         `media_versioned`  tinyint(1) NOT NULL,
                         `media_file` varchar(255) NOT NULL,
                         `media_extension` varchar(10) NULL,
                         `media_size` int(11) NULL,
                         `media_created_by` int(11) DEFAULT NULL,
                         `media_created_at` datetime DEFAULT NULL,
                         PRIMARY KEY (`media_id`),
                         KEY `media_created_by` (`media_created_by`)
                     )ENGINE=InnoDB  DEFAULT CHARSET=utf8;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'media`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'media_ibfk_1` FOREIGN KEY (`media_created_by`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'media_relation` (
                         `media_relation_id` int(11) NOT NULL AUTO_INCREMENT,
                         `media_relation_src`  int(11) NULL,
                         `media_relation_dst` int(11) NULL,
                         PRIMARY KEY (`media_relation_id`),
                         KEY `media_relation_src` (`media_relation_src`),
                         KEY `media_relation_dst` (`media_relation_dst`)
                     )ENGINE=InnoDB  DEFAULT CHARSET=utf8;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'media_relation`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'media_relation_ibfk_1` FOREIGN KEY (`media_relation_src`) REFERENCES `' . $dbPool->get('core')->prefix . 'media` (`media_id`),
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'media_relation_ibfk_2` FOREIGN KEY (`media_relation_dst`) REFERENCES `' . $dbPool->get('core')->prefix . 'media` (`media_id`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'media_permission` (
                         `media_permission_id` int(11) NOT NULL AUTO_INCREMENT,
                         `media_permission_type`  tinyint(1) NOT NULL,
                         `media_permission_reference` int(11) NOT NULL,
                         `media_permission_permission` tinyint(2) NOT NULL,
                         `media_permission_media` int(11) NOT NULL,
                         PRIMARY KEY (`media_permission_id`),
                         KEY `media_permission_media` (`media_permission_media`)
                     )ENGINE=InnoDB  DEFAULT CHARSET=utf8;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'media_permission`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'media_permission_ibfk_1` FOREIGN KEY (`media_permission_media`) REFERENCES `' . $dbPool->get('core')->prefix . 'media` (`media_id`);')->execute();
             break;
     }
 }
示例#23
0
 /**
  * Install module
  *
  * @param \phpOMS\DataStorage\Database\Pool $dbPool Database instance
  * @param array                             $info   Module info
  *
  * @since  1.0.0
  * @author Dennis Eichhorn <*****@*****.**>
  */
 public static function install($dbPool, $info)
 {
     switch ($dbPool->get('core')->getType()) {
         case \phpOMS\DataStorage\Database\DatabaseType::MYSQL:
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'calendar` (
                         `calendar_id` int(11) NOT NULL AUTO_INCREMENT,
                         `calendar_name` varchar(25) NOT NULL,
                         `calendar_password` varchar(64) NOT NULL,
                         `calendar_description` varchar(255) NOT NULL,
                         `calendar_creator` int(11) NOT NULL,
                         `calendar_created` datetime NOT NULL,
                         PRIMARY KEY (`calendar_id`),
                         KEY `calendar_creator` (`calendar_creator`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'calendar`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'calendar_ibfk_1` FOREIGN KEY (`calendar_creator`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'calendar_permission` (
                         `calendar_permission_id` int(11) NOT NULL AUTO_INCREMENT,
                         `calendar_permission_account` int(11) NOT NULL,
                         `calendar_permission_calendar` int(11) NOT NULL,
                         `calendar_permission_permission` tinyint(2) NOT NULL,
                         PRIMARY KEY (`calendar_permission_id`),
                         KEY `calendar_permission_account` (`calendar_permission_account`),
                         KEY `calendar_permission_calendar` (`calendar_permission_calendar`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'calendar_permission`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'calendar_permission_ibfk_1` FOREIGN KEY (`calendar_permission_account`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`),
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'calendar_permission_ibfk_2` FOREIGN KEY (`calendar_permission_calendar`) REFERENCES `' . $dbPool->get('core')->prefix . 'calendar` (`calendar_id`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'calendar_event` (
                         `calendar_event_id` int(11) NOT NULL AUTO_INCREMENT,
                         `calendar_event_name` varchar(25) NOT NULL,
                         `calendar_event_description` varchar(255) NOT NULL,
                         `calendar_event_start` datetime NOT NULL,
                         `calendar_event_end` datetime NOT NULL,
                         `calendar_event_status` tinyint(1) NOT NULL,
                         `calendar_event_repeat` tinyint(1) NOT NULL,
                         `calendar_event_rep_interval` tinyint(3) NOT NULL,
                         `calendar_event_rep_monday` tinyint(1) NOT NULL,
                         `calendar_event_rep_tuesday` tinyint(1) NOT NULL,
                         `calendar_event_rep_wednesday` tinyint(1) NOT NULL,
                         `calendar_event_rep_thursday` tinyint(1) NOT NULL,
                         `calendar_event_rep_friday` tinyint(1) NOT NULL,
                         `calendar_event_rep_saturday` tinyint(1) NOT NULL,
                         `calendar_event_rep_sunday` tinyint(1) NOT NULL,
                         `calendar_event_creator` int(11) NOT NULL,
                         `calendar_event_created` datetime NOT NULL,
                         `calendar_event_calendar` int(11) NOT NULL,
                         PRIMARY KEY (`calendar_event_id`),
                         KEY `calendar_event_creator` (`calendar_event_creator`),
                         KEY `calendar_event_calendar` (`calendar_event_calendar`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'calendar_event`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'calendar_event_ibfk_1` FOREIGN KEY (`calendar_event_creator`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`),
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'calendar_event_ibfk_2` FOREIGN KEY (`calendar_event_calendar`) REFERENCES `' . $dbPool->get('core')->prefix . 'calendar` (`calendar_id`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'calendar_event_participant` (
                         `calendar_event_participant_id` int(11) NOT NULL AUTO_INCREMENT,
                         `calendar_event_participant_event` int(11) NOT NULL,
                         `calendar_event_participant_person` int(11) NOT NULL,
                         `calendar_event_participant_status` tinyint(1) NOT NULL,
                         PRIMARY KEY (`calendar_event_participant_id`),
                         KEY `calendar_event_participant_event` (`calendar_event_participant_event`),
                         KEY `calendar_event_participant_person` (`calendar_event_participant_person`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'calendar_event_participant`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'calendar_event_participant_ibfk_1` FOREIGN KEY (`calendar_event_participant_event`) REFERENCES `' . $dbPool->get('core')->prefix . 'calendar_event` (`calendar_event_id`),
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'calendar_event_participant_ibfk_2` FOREIGN KEY (`calendar_event_participant_person`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`);')->execute();
             break;
     }
 }
示例#24
0
 /**
  * Install module
  *
  * @param \phpOMS\DataStorage\Database\Pool $dbPool Database pool instance
  * @param array                             $info   Module info
  *
  * @since  1.0.0
  * @author Dennis Eichhorn <*****@*****.**>
  */
 public static function install($dbPool, $info)
 {
     switch ($dbPool->get('core')->getType()) {
         case \phpOMS\DataStorage\Database\DatabaseType::MYSQL:
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'reporter` (
                         `reporter_id` int(11) NOT NULL AUTO_INCREMENT,
                         `reporter_title` varchar(25) NOT NULL,
                         `reporter_desc` varchar(255) NOT NULL,
                         `reporter_media` int(11) NOT NULL,
                         `reporter_creator` int(11) NOT NULL,
                         `reporter_created` datetime NOT NULL,
                         PRIMARY KEY (`reporter_id`),
                         KEY `reporter_media` (`reporter_media`),
                         KEY `reporter_creator` (`reporter_creator`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'reporter`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'reporter_ibfk_1` FOREIGN KEY (`reporter_media`) REFERENCES `' . $dbPool->get('core')->prefix . 'media` (`media_id`),
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'reporter_ibfk_2` FOREIGN KEY (`reporter_creator`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'reporter_permission` (
                         `reporter_permission_id` int(11) NOT NULL AUTO_INCREMENT,
                         `reporter_permission_type`  tinyint(1) NOT NULL,
                         `reporter_permission_reference` int(11) NOT NULL,
                         `reporter_permission_permission` tinyint(2) NOT NULL,
                         `reporter_permission_report` int(11) NOT NULL,
                         PRIMARY KEY (`reporter_permission_id`),
                         KEY `reporter_permission_report` (`reporter_permission_report`)
                     )ENGINE=InnoDB  DEFAULT CHARSET=utf8;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'reporter_permission`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'reporter_permission_ibfk_1` FOREIGN KEY (`reporter_permission_report`) REFERENCES `' . $dbPool->get('core')->prefix . 'reporter` (`reporter_id`);')->execute();
             break;
     }
 }
示例#25
0
 /**
  * Install module
  *
  * @param \phpOMS\DataStorage\Database\Pool $dbPool Database instance
  * @param array                             $info   Module info
  *
  * @since  1.0.0
  * @author Dennis Eichhorn <*****@*****.**>
  */
 public static function install($dbPool, $info)
 {
     switch ($dbPool->get('core')->getType()) {
         case \phpOMS\DataStorage\Database\DatabaseType::MYSQL:
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'message` (
                         `message_id` int(11) NOT NULL AUTO_INCREMENT,
                         `message_type`  tinyint(11) NOT NULL,
                         `message_account` int(11) DEFAULT NULL,
                         `message_email` varchar(256) NULL,
                         `message_sent` datetime NULL,
                         `message_cc` varchar(256) DEFAULT NULL,
                         `message_bcc` varchar(256) DEFAULT NULL,
                         `message_content` text DEFAULT NULL,
                         `message_reference` int(11) DEFAULT NULL,
                         PRIMARY KEY (`message_id`),
                         KEY `message_account` (`message_account`),
                         KEY `message_reference` (`message_reference`)
                     )ENGINE=InnoDB  DEFAULT CHARSET=utf8;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'message`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'message_ibfk_1` FOREIGN KEY (`message_account`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`),
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'message_ibfk_2` FOREIGN KEY (`message_reference`) REFERENCES `' . $dbPool->get('core')->prefix . 'message` (`message_id`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'messages_attachment` (
                         `messages_attachment_id` int(11) NOT NULL AUTO_INCREMENT,
                         `messages_attachment_media` int(11) DEFAULT NULL,
                         `messages_attachment_message` int(11) NULL,
                         PRIMARY KEY (`messages_attachment_id`),
                         KEY `messages_attachment_media` (`messages_attachment_media`),
                         KEY `messages_attachment_message` (`messages_attachment_message`)
                     )ENGINE=InnoDB  DEFAULT CHARSET=utf8;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'messages_attachment`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'messages_attachment_ibfk_1` FOREIGN KEY (`messages_attachment_media`) REFERENCES `' . $dbPool->get('core')->prefix . 'media` (`media_id`),
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'messages_attachment_ibfk_2` FOREIGN KEY (`messages_attachment_message`) REFERENCES `' . $dbPool->get('core')->prefix . 'message` (`message_id`);')->execute();
             break;
     }
 }
示例#26
0
 /**
  * Install module
  *
  * @param \phpOMS\DataStorage\Database\Pool $dbPool Database instance
  * @param array                             $info   Module info
  *
  * @since  1.0.0
  * @author Dennis Eichhorn <*****@*****.**>
  */
 public static function install($dbPool, $info)
 {
     switch ($dbPool->get('core')->getType()) {
         case \phpOMS\DataStorage\Database\DatabaseType::MYSQL:
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'arrival` (
                         `arrival_id` int(11) NOT NULL AUTO_INCREMENT,
                         `arrival_date` datetime NOT NULL,
                         `arrival_carrier` int(11) NOT NULL,
                         `arrival_responsible` int(11) NOT NULL,
                         `arrival_media` int(11) NOT NULL,
                         PRIMARY KEY (`arrival_id`),
                         KEY `arrival_carrier` (`arrival_carrier`),
                         KEY `arrival_responsible` (`arrival_responsible`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'arrival`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'arrival_ibfk_1` FOREIGN KEY (`arrival_carrier`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`),
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'arrival_ibfk_2` FOREIGN KEY (`arrival_responsible`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'arrival_status` (
                         `arrival_status_id` int(11) NOT NULL AUTO_INCREMENT,
                         `arrival_status_amount` tinyint(1) NOT NULL,
                         `arrival_status_condition` tinyint(1) NOT NULL,
                         `arrival_status_arrival` int(11) NOT NULL,
                         PRIMARY KEY (`arrival_status_id`),
                         KEY `arrival_status_arrival` (`arrival_status_arrival`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'arrival_status`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'arrival_status_ibfk_1` FOREIGN KEY (`arrival_status_arrival`) REFERENCES `' . $dbPool->get('core')->prefix . 'arrival` (`arrival_id`);')->execute();
             break;
     }
 }
示例#27
0
 /**
  * Install module
  *
  * @param \phpOMS\DataStorage\Database\Pool $dbPool Database instance
  * @param array                             $info   Module info
  *
  * @since  1.0.0
  * @author Dennis Eichhorn <*****@*****.**>
  */
 public static function install($dbPool, $info)
 {
     switch ($dbPool->get('core')->getType()) {
         case \phpOMS\DataStorage\Database\DatabaseType::MYSQL:
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'cost_center_accounting` (
                         `cost_center_accounting_id` int(11) NOT NULL AUTO_INCREMENT,
                         `cost_center_accounting_name` varchar(25) NOT NULL,
                         `cost_center_accounting_description` varchar(255) NOT NULL,
                         `cost_center_accounting_parent` int(11) NOT NULL,
                         PRIMARY KEY (`cost_center_accounting_id`),
                         KEY `cost_center_accounting_parent` (`cost_center_accounting_parent`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'cost_center_accounting`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'cost_center_accounting_ibfk_1` FOREIGN KEY (`cost_center_accounting_parent`) REFERENCES `' . $dbPool->get('core')->prefix . 'cost_center_accounting` (`cost_center_accounting_id`);')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'accounting_posting_ele`
                     ADD `accounting_posting_ele_costcenter` int(11) NOT NULL,
                     ADD KEY `accounting_posting_ele_costcenter` (`accounting_posting_ele_costcenter`),
                     ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'accounting_posting_ele_ibfk_2` FOREIGN KEY (`accounting_posting_ele_costcenter`) REFERENCES `' . $dbPool->get('core')->prefix . 'cost_center_accounting` (`cost_center_accounting_id`);')->execute();
             break;
     }
 }
示例#28
0
 /**
  * Install module
  *
  * @param \phpOMS\DataStorage\Database\Pool $dbPool Database instance
  * @param array                             $info   Module info
  *
  * @since  1.0.0
  * @author Dennis Eichhorn <*****@*****.**>
  */
 public static function install($dbPool, $info)
 {
     switch ($dbPool->get('core')->getType()) {
         case \phpOMS\DataStorage\Database\DatabaseType::MYSQL:
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'business_unit` (
                         `business_unit_id` int(11) NOT NULL AUTO_INCREMENT,
                         `business_unit_status` tinyint(2) DEFAULT NULL,
                         `business_unit_matchcode` varchar(50) DEFAULT NULL,
                         `business_unit_name` varchar(50) DEFAULT NULL,
                         `business_unit_parent` int(11) DEFAULT NULL,
                         PRIMARY KEY (`business_unit_id`),
                         KEY `business_unit_parent` (`business_unit_parent`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'business_unit`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'business_unit_ibfk_1` FOREIGN KEY (`business_unit_parent`) REFERENCES `' . $dbPool->get('core')->prefix . 'business_unit` (`business_unit_id`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'business_department` (
                         `business_department_id` int(11) NOT NULL AUTO_INCREMENT,
                         `business_department_name` varchar(30) DEFAULT NULL,
                         `business_department_parent` int(11) DEFAULT NULL,
                         `business_department_unit` int(11) NOT NULL,
                         PRIMARY KEY (`business_department_id`),
                         KEY `business_department_parent` (`business_department_parent`),
                         KEY `business_department_unit` (`business_department_unit`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'business_department`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'business_department_ibfk_1` FOREIGN KEY (`business_department_parent`) REFERENCES `' . $dbPool->get('core')->prefix . 'business_department` (`business_department_id`),
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'business_department_ibfk_2` FOREIGN KEY (`business_department_unit`) REFERENCES `' . $dbPool->get('core')->prefix . 'business_unit` (`business_unit_id`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'business_address` (
                         `business_address_id` int(11) NOT NULL AUTO_INCREMENT,
                         `business_address_status` tinyint(2) DEFAULT NULL,
                         `business_address_matchcode` varchar(50) DEFAULT NULL,
                         `business_address_name` varchar(50) DEFAULT NULL,
                         `business_address_fao` varchar(30) DEFAULT NULL,
                         `business_address_addr` varchar(50) DEFAULT NULL,
                         `business_address_city` varchar(20) DEFAULT NULL,
                         `business_address_zip` varchar(20) DEFAULT NULL,
                         `business_address_state` varchar(20) DEFAULT NULL,
                         `business_address_country` varchar(30) DEFAULT NULL,
                         `business_address_unit` int(11) DEFAULT NULL,
                         PRIMARY KEY (`business_address_id`),
                         KEY `business_address_unit` (`business_address_unit`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'business_address`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'business_address_ibfk_1` FOREIGN KEY (`business_address_unit`) REFERENCES `' . $dbPool->get('core')->prefix . 'business_unit` (`business_unit_id`);')->execute();
             break;
     }
 }
示例#29
0
 /**
  * Install module
  *
  * @param \phpOMS\DataStorage\Database\Pool $dbPool Database instance
  * @param array                             $info   Module info
  *
  * @since  1.0.0
  * @author Dennis Eichhorn <*****@*****.**>
  */
 public static function install($dbPool, $info)
 {
     switch ($dbPool->get('core')->getType()) {
         case \phpOMS\DataStorage\Database\DatabaseType::MYSQL:
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'billing_invoice` (
                         `billing_invoice_id` int(11) NOT NULL AUTO_INCREMENT,
                         `billing_invoice_status` tinyint(2) DEFAULT NULL,
                         `billing_invoice_shipTo` varchar(50) DEFAULT NULL,
                         `billing_invoice_shipFAO` varchar(30) DEFAULT NULL,
                         `billing_invoice_shipAddr` varchar(50) DEFAULT NULL,
                         `billing_invoice_shipCity` varchar(20) DEFAULT NULL,
                         `billing_invoice_shipZip` varchar(20) DEFAULT NULL,
                         `billing_invoice_shipCountry` varchar(30) DEFAULT NULL,
                         `billing_invoice_billTo` varchar(50) DEFAULT NULL,
                         `billing_invoice_billFAO` varchar(30) DEFAULT NULL,
                         `billing_invoice_billAddr` varchar(50) DEFAULT NULL,
                         `billing_invoice_billCity` varchar(20) DEFAULT NULL,
                         `billing_invoice_billZip` varchar(20) DEFAULT NULL,
                         `billing_invoice_billCountry` varchar(30) DEFAULT NULL,
                         `billing_invoice_type` tinyint(2) DEFAULT NULL,
                         `billing_invoice_created` datetime DEFAULT NULL,
                         `billing_invoice_shippdate` datetime DEFAULT NULL,
                         `billing_invoice_printed` datetime DEFAULT NULL,
                         `billing_invoice_price` decimal(9,2) DEFAULT NULL,
                         `billing_invoice_currency` varchar(3) DEFAULT NULL,
                         `billing_invoice_freightage` decimal(9,2) DEFAULT NULL,
                         `billing_invoice_info` text DEFAULT NULL,
                         `billing_invoice_voucher` int(11) DEFAULT NULL,
                         `billing_invoice_promotion` int(11) DEFAULT NULL,
                         `billing_invoice_creator` int(11) NOT NULL,
                         `billing_invoice_client` int(11) NOT NULL,
                         `billing_invoice_referer` int(11) DEFAULT NULL,
                         `billing_invoice_reference` int(11) DEFAULT NULL,
                         PRIMARY KEY (`billing_invoice_id`),
                         KEY `billing_invoice_creator` (`billing_invoice_creator`),
                         KEY `billing_invoice_client` (`billing_invoice_client`),
                         KEY `billing_invoice_referer` (`billing_invoice_referer`),
                         KEY `billing_invoice_reference` (`billing_invoice_reference`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'billing_invoice`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'billing_invoice_ibfk_1` FOREIGN KEY (`billing_invoice_creator`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`),
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'billing_invoice_ibfk_2` FOREIGN KEY (`billing_invoice_client`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`),
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'billing_invoice_ibfk_3` FOREIGN KEY (`billing_invoice_referer`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`),
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'billing_invoice_ibfk_4` FOREIGN KEY (`billing_invoice_reference`) REFERENCES `' . $dbPool->get('core')->prefix . 'billing_invoice` (`billing_invoice_id`);')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'billing_invoice_element` (
                         `billing_invoice_element_id` int(11) NOT NULL AUTO_INCREMENT,
                         `billing_invoice_element_position` smallint(5) NOT NULL,
                         `billing_invoice_element_article` int(11) NOT NULL,
                         `billing_invoice_element_name` varchar(30) NOT NULL,
                         `billing_invoice_element_desc` text NOT NULL,
                         `billing_invoice_element_quantity` int(11) NOT NULL,
                         `billing_invoice_element_price` decimal(11,2) NOT NULL,
                         `billing_invoice_element_tax` decimal(5,2) NOT NULL,
                         `billing_invoice_element_discountp` decimal(5,2) NOT NULL,
                         `billing_invoice_element_discount` decimal(11,2) NOT NULL,
                         `billing_invoice_element_invoice` int(11) NOT NULL,
                         PRIMARY KEY (`billing_invoice_element_id`),
                         KEY `billing_invoice_element_invoice` (`billing_invoice_element_invoice`)
                     )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'billing_invoice_element`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'billing_invoice_element_ibfk_1` FOREIGN KEY (`billing_invoice_element_invoice`) REFERENCES `' . $dbPool->get('core')->prefix . 'billing_invoice` (`billing_invoice_id`);')->execute();
             break;
     }
 }
示例#30
0
 /**
  * Install module
  *
  * @param \phpOMS\DataStorage\Database\Pool $dbPool Database instance
  * @param array                             $info   Module info
  *
  * @since  1.0.0
  * @author Dennis Eichhorn <*****@*****.**>
  */
 public static function install($dbPool, $info)
 {
     switch ($dbPool->get('core')->getType()) {
         case \phpOMS\DataStorage\Database\DatabaseType::MYSQL:
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'production_process` (
                         `ProcessID` int(11) NOT NULL AUTO_INCREMENT,
                         `product`  int(11) NOT NULL,
                         `status`  tinyint(2) NOT NULL,
                         `quantity` int(11) NOT NULL,
                         `for` int(11) NULL,
                         `orderer` int(11) NULL,
                         `ordered` datetime DEFAULT NULL,
                         `due` datetime DEFAULT NULL,
                         `planned` datetime DEFAULT NULL,
                         `started` datetime DEFAULT NULL,
                         `done` datetime DEFAULT NULL,
                         PRIMARY KEY (`ProcessID`),
                         KEY `product` (`product`),
                         KEY `for` (`for`),
                         KEY `orderer` (`orderer`)
                     )ENGINE=InnoDB  DEFAULT CHARSET=utf8;')->execute();
             /*$dbPool->get('core')->con->prepare(
                   'ALTER TABLE `' . $dbPool->get('core')->prefix . 'production_process`
                       ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'production_process_ibfk_1` FOREIGN KEY (`creator`) REFERENCES `' . $dbPool->get('core')->prefix . 'account` (`account_id`);'
               )->execute();*/
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'production_guideline` (
                         `ProductionGuidelineID` int(11) NOT NULL AUTO_INCREMENT,
                         `product` int(11) NOT NULL,
                         PRIMARY KEY (`ProductionGuidelineID`),
                         KEY `product` (`product`)
                     )ENGINE=InnoDB  DEFAULT CHARSET=utf8;')->execute();
             $dbPool->get('core')->con->prepare('CREATE TABLE if NOT EXISTS `' . $dbPool->get('core')->prefix . 'production_guideline_step` (
                         `ProductionStepID` int(11) NOT NULL AUTO_INCREMENT,
                         `guideline` int(11) NOT NULL,
                         `title` varchar(50) NOT NULL,
                         `text` text NOT NULL,
                         `order` tinyint(3) NOT NULL,
                         PRIMARY KEY (`ProductionStepID`),
                         KEY `guideline` (`guideline`)
                     )ENGINE=InnoDB  DEFAULT CHARSET=utf8;')->execute();
             $dbPool->get('core')->con->prepare('ALTER TABLE `' . $dbPool->get('core')->prefix . 'production_guideline_step`
                         ADD CONSTRAINT `' . $dbPool->get('core')->prefix . 'production_guideline_step_ibfk_1` FOREIGN KEY (`guideline`) REFERENCES `' . $dbPool->get('core')->prefix . 'production_guideline` (`ProductionGuidelineID`);')->execute();
             break;
     }
 }