| <?php | <?php |
| include_once("../lib/common.inc.php"); | include_once("../lib/common.inc.php"); |
| $query = 'update contractnotice set "parentCN" = null where "parentCN" = \'0\''; | $query = 'update contractnotice set "parentCN" = null where "parentCN" = \'0\''; |
| $result = $conn->prepare($query); | $result = $conn->prepare($query); |
| $result->execute(); | $result->execute(); |
| $query = 'update contractnotice set "childCN" = null where "childCN" = \'0\''; | $query = 'update contractnotice set "childCN" = null where "childCN" = \'0\''; |
| $result = $conn->prepare($query); | $result = $conn->prepare($query); |
| $result->execute(); | $result->execute(); |
| $query = 'select "CNID","parentCN" from contractnotice where "CNID" like \'%00_\' and "parentCN" is not null'; | $query = 'select "CNID","parentCN" from contractnotice where "CNID" like \'%00_\' and "parentCN" is not null'; |
| $result = $conn->prepare($query); | $result = $conn->prepare($query); |
| $result->execute(); | $result->execute(); |
| foreach ($result->fetchAll() as $record) { | foreach ($result->fetchAll() as $record) { |
| $oldCN = $record['CNID']; | $oldCN = $record['CNID']; |
| $parentCN = substr($oldCN,0,-3); | $parentCN = substr($oldCN,0,-3); |
| if ($parentCN == $record['parentCN']) { | if ($parentCN == $record['parentCN']) { |
| $newCN = $parentCN . "-A". substr($oldCN,-1); | $newCN = $parentCN . "-A". substr($oldCN,-1); |
| $updateresult = $conn->exec('UPDATE contractnotice SET "CNID" = | $updateresult = $conn->exec('UPDATE contractnotice SET "CNID" = |
| \'' . $newCN . '\' where "CNID" = \'' . $oldCN . '\';'); | \'' . $newCN . '\' where "CNID" = \'' . $oldCN . '\';'); |
| echo "$oldCN => $newCN (from parent CN $parentCN) <br>\n"; | echo "$oldCN => $newCN (from parent CN $parentCN) <br>\n"; |
| } | } |
| else { | else { |
| echo "parent CN unexpected - $oldCN doesn't look like child of {$record['parentCN']} <br>\n"; | // echo "parent CN unexpected - $oldCN doesn't look like child of {$record['parentCN']} <br>\n"; |
| } | } |
| } | } |