123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324 |
- <?php
- class StatusCodeGroupDao
- {
-
- public function addGroup(&$projectID, &$groupName)
- {
- $db = getDatabase();
- $db->prepareExecute('INSERT INTO eo_project_status_code_group (eo_project_status_code_group.projectID,eo_project_status_code_group.groupName) VALUES (?,?);', array(
- $projectID,
- $groupName
- ));
- $groupID = $db->getLastInsertID();
- if ($db->getAffectRow() < 1)
- return FALSE;
- else
- return $groupID;
- }
-
- public function addChildGroup(&$projectID, &$groupName, &$parentGroupID)
- {
- $db = getDatabase();
- $db->prepareExecute('INSERT INTO eo_project_status_code_group (eo_project_status_code_group.projectID,eo_project_status_code_group.groupName,eo_project_status_code_group.parentGroupID,eo_project_status_code_group.isChild) VALUES (?,?,?,1);', array(
- $projectID,
- $groupName,
- $parentGroupID
- ));
- $groupID = $db->getLastInsertID();
- if ($db->getAffectRow() < 1)
- return FALSE;
- else
- return $groupID;
- }
-
- public function checkStatusCodeGroupPermission(&$groupID, &$userID)
- {
- $db = getDatabase();
- $result = $db->prepareExecute('SELECT eo_conn_project.projectID FROM eo_conn_project INNER JOIN eo_project_status_code_group ON eo_conn_project.projectID = eo_project_status_code_group.projectID WHERE groupID = ? AND userID = ?;', array(
- $groupID,
- $userID
- ));
- if (empty($result))
- return FALSE;
- else
- return $result['projectID'];
- }
-
- public function deleteGroup(&$groupID)
- {
- $db = getDatabase();
- $db->prepareExecute('DELETE FROM eo_project_status_code_group WHERE eo_project_status_code_group.groupID = ?;', array($groupID));
- if ($db->getAffectRow() < 1)
- return FALSE;
- else
- return TRUE;
- }
-
- public function getGroupList(&$projectID)
- {
- $db = getDatabase();
- $groupList = $db->prepareExecuteAll('SELECT eo_project_status_code_group.groupID,eo_project_status_code_group.groupName FROM eo_project_status_code_group WHERE projectID = ? AND isChild = 0 ORDER BY eo_project_status_code_group.groupID DESC;', array($projectID));
- if (is_array($groupList))
- foreach ($groupList as &$parentGroup) {
- $parentGroup['childGroupList'] = array();
- $childGroup = $db->prepareExecuteAll('SELECT eo_project_status_code_group.groupID,eo_project_status_code_group.groupName,eo_project_status_code_group.parentGroupID FROM eo_project_status_code_group WHERE projectID = ? AND isChild = 1 AND parentGroupID = ? ORDER BY eo_project_status_code_group.groupID DESC;', array(
- $projectID,
- $parentGroup['groupID']
- ));
-
- if (!empty($childGroup))
- $parentGroup['childGroupList'] = $childGroup;
- }
- $result = array();
- $result['groupList'] = $groupList;
- $groupOrder = $db->prepareExecute('SELECT eo_api_status_code_group_order.orderList FROM eo_api_status_code_group_order WHERE projectID = ?;', array(
- $projectID
- ));
- $result['groupOrder'] = $groupOrder['orderList'];
- if (empty($result))
- return FALSE;
- else
- return $result;
- }
-
- public function editGroup(&$groupID, &$groupName, $parentGroupID)
- {
- $db = getDatabase();
- if (!$parentGroupID) {
- $db->prepareExecute('UPDATE eo_project_status_code_group SET eo_project_status_code_group.groupName = ?,isChild = 0,parentGroupID = NULL WHERE eo_project_status_code_group.groupID = ?;', array(
- $groupName,
- $groupID
- ));
- } else {
- $db->prepareExecute('UPDATE eo_project_status_code_group SET eo_project_status_code_group.groupName = ?,isChild = 1,parentGroupID = ? WHERE eo_project_status_code_group.groupID = ?;', array(
- $groupName,
- $parentGroupID,
- $groupID
- ));
- }
- if ($db->getAffectRow() < 1)
- return FALSE;
- else
- return TRUE;
- }
-
- public function sortGroup(&$projectID, &$orderList)
- {
- $db = getDatabase();
- $db->prepareExecute('REPLACE INTO eo_api_status_code_group_order(projectID, orderList) VALUES (?,?);', array(
- $projectID,
- $orderList
- ));
- if ($db->getAffectRow() > 0)
- return TRUE;
- else
- return FALSE;
- }
-
- public function getGroupName(&$group_id)
- {
- $db = getDatabase();
- $result = $db->prepareExecute('SELECT eo_project_status_code_group.groupName FROM eo_project_status_code_group WHERE eo_project_status_code_group.groupID = ?;', array($group_id));
- if (empty($result)) {
- return FALSE;
- } else {
- return $result['groupName'];
- }
- }
-
- public function getGroupData(&$project_id, &$group_id)
- {
- $db = getDatabase();
- $result = array();
- $group = $db->prepareExecute('SELECT eo_project_status_code_group.groupName,eo_project_status_code_group.isChild FROM eo_project_status_code_group WHERE eo_project_status_code_group.projectID = ? AND eo_project_status_code_group.groupID = ?;', array(
- $project_id,
- $group_id
- ));
- $result['statusCodeList'] = $db->prepareExecuteAll("SELECT eo_project_status_code.codeID,eo_project_status_code.code,eo_project_status_code.codeDescription FROM eo_project_status_code WHERE eo_project_status_code.groupID = ?", array(
- $group_id
- ));
- $result['groupName'] = $group['groupName'];
- if ($group['isChild'] == 0) {
- $child_group_list = $db->prepareExecuteAll('SELECT eo_project_status_code_group.groupID,eo_project_status_code_group.groupName FROM eo_project_status_code_group WHERE eo_project_status_code_group.parentGroupID = ? AND eo_project_status_code_group.projectID = ?', array(
- $group_id,
- $project_id
- ));
- if ($child_group_list) {
- $i = 0;
- foreach ($child_group_list as $group) {
- $result['childGroupList'][$i]['groupName'] = $group['groupName'];
- $result['childGroupList'][$i]['statusCodeList'] = $db->prepareExecuteAll("SELECT eo_project_status_code.codeID,eo_project_status_code.code,eo_project_status_code.codeDescription FROM eo_project_status_code WHERE eo_project_status_code.groupID = ?", array(
- $group['groupID']
- ));
- $i++;
- }
- }
- }
- if ($result)
- return $result;
- else
- return FALSE;
- }
-
- public function importGroup(&$project_id, &$data)
- {
- $db = getDatabase();
- try {
- $db->beginTransaction();
-
- $db->prepareExecute('INSERT INTO eo_project_status_code_group (eo_project_status_code_group.projectID,eo_project_status_code_group.groupName) VALUES (?,?);', array(
- $project_id,
- $data['groupName']
- ));
- if ($db->getAffectRow() < 1)
- throw new \PDOException("add statusCodeGroup error");
- $group_id = $db->getLastInsertID();
- if ($data['statusCodeList']) {
-
- foreach ($data['statusCodeList'] as $status_code) {
- $db->prepareExecute('INSERT INTO eo_project_status_code (eo_project_status_code.groupID,eo_project_status_code.code,eo_project_status_code.codeDescription) VALUES (?,?,?);', array(
- $group_id,
- $status_code['code'],
- $status_code['codeDescription']
- ));
- if ($db->getAffectRow() < 1)
- throw new \PDOException("add statusCode error");
- }
- }
- if ($data['childGroupList']) {
- $group_id_parent = $group_id;
- foreach ($data['childGroupList'] as $child_group) {
-
- $db->prepareExecute('INSERT INTO eo_project_status_code_group (eo_project_status_code_group.projectID,eo_project_status_code_group.groupName,eo_project_status_code_group.parentGroupID,eo_project_status_code_group.isChild) VALUES (?,?,?,?);', array(
- $project_id,
- $child_group['groupName'],
- $group_id_parent,
- 1
- ));
- if ($db->getAffectRow() < 1) {
- throw new \PDOException("add statusCodeGroup error");
- }
- $group_id = $db->getLastInsertID();
- if ($child_group['statusCodeList']) {
-
- foreach ($child_group['statusCodeList'] as $status_code) {
- $db->prepareExecute('INSERT INTO eo_project_status_code (eo_project_status_code.groupID,eo_project_status_code.code,eo_project_status_code.codeDescription) VALUES (?,?,?);', array(
- $group_id,
- $status_code['code'],
- $status_code['codeDescription']
- ));
- if ($db->getAffectRow() < 1) {
- throw new \PDOException("add statusCode error");
- }
- }
- }
- }
- }
- $db->commit();
- return TRUE;
- } catch (\PDOException $e) {
- $db->rollback();
- return FALSE;
- }
- }
- }
- ?>
|