Changeset 13 for trunk/cleanup.php

Timestamp:

Jun 18, 2015, 12:49:58 PM (9 years ago)

Author:

gegorbet

Message:

fix AIRA cleanup.php to update any mrecs record with modelID

File:

• trunk/cleanup.php (modified) (1 diff)

trunk/cleanup.php

@@ -568 +568 @@
    }
 
+   // Now possibly fix up mrecs entries
+
+   foreach ( $mrecsIDs as $mrecsID )
+   {
+      $modelGUID = $rmodlGUIDs[ $mrecsID ];
+      $query = "UPDATE pcsa_modelrecs SET "                                                 .
+               "modelID="                                                          .
+               "(SELECT modelID FROM model WHERE modelGUID='$modelGUID')"          .
+               "WHERE mrecsID=$mrecsID";
+
+      $result = mysql_query( $query, $us3_link );
+
+      if ( ! $result )
+      {
+         write_log( "$me: Bad query:\n$query\n" . mysql_error( $us3_link ) );
+         mail_to_user( "fail", "Bad query\n$query\n" . mysql_error( $us3_link ) );
+         return( -1 );
+      }
+write_log( "$me:     mrecs entry updated : mrecsID=$mrecsID" );
+   }
+//write_log( "$me:     mrecs entries updated" );
+
    // Copy results to LIMS submit directory (files there are deleted after 7 days)
    global $submit_dir; // LIMS submit files dir