Better importing CN error display
[contractdashboard.git] / admin / linkAmendments.php


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
<?php
include_once ("../lib/common.inc.php");
$query = 'SELECT c."CNID",c."parentCN",c."amendmentReason",p."childCN" FROM contractnotice as c  LEFT OUTER JOIN contractnotice as p on c."parentCN" = p."CNID"
WHERE
c."parentCN" > 0 AND p."childCN" IS NULL ';
$query = $conn->prepare($query);
        $query->execute();
        if (!$query) {
                databaseError($conn->errorInfo());
        }
foreach ($query->fetchAll() as $row) {
  $conn->exec('UPDATE contractnotice SET "childCN" = \'' .
                         $row['CNID'] . '\', "amendmentReason" = \'' .
                         $row['amendmentReason'] . '\' where "CNID" = \'' .
                         $row['parentCN'] . '\';');
                         //echo 'UPDATE contractnotice SET "childCN" = \'' .
                         $row['CNID'] . '\', "amendmentReason" = \'' .
                         $row['amendmentReason'] . '\' where "CNID" = \'' .
                         $row['parentCN'] . '\';';
    $errors = $conn->errorInfo();
              
              if ($errors[1] == 7 || $errors[1] ==0)
                  echo $row['CNID'] . " linked to parent " . $row['parentCN'] .
  "<br>\n";
  else print_r($errors);
 
}
// also need to eliminate CN 100528/100529 - check for double parent CNs with no childCN, latest sequent CN id wins childCN = 0
?>