query('UPDATE stock_take_item AS sti
LEFT JOIN item AS i ON sti.item_code=i.item_code
LEFT JOIN mst_coll_type AS ct ON i.coll_type_id=ct.coll_type_id
LEFT JOIN mst_location AS loc ON i.location_id=loc.location_id
LEFT JOIN biblio AS b ON i.biblio_id=b.biblio_id
LEFT JOIN mst_gmd AS g ON b.gmd_id=g.gmd_id
SET sti.title=b.title, sti.gmd_name=g.gmd_name,
sti.classification=b.classification, sti.call_number=b.call_number,
sti.coll_type_name=ct.coll_type_name');
if (!$dbs->error) {
$aff_rows = $dbs->affected_rows;
// record to log
utility::writeLogs($dbs, 'staff', $_SESSION['uid'], 'stock_take', 'Stock Take Re-Synchronization');
echo '';
} else {
echo '';
}
exit();
}
echo ''.__('Re-synchronize will only update current stock take\'s item data. It won\'t update any new bibliographic or item data that were inserted in the middle of stock take proccess')."\n";
echo '
'."\n";
echo ''."\n";
echo ''."\n";
echo '';
echo '
';