README

TODO

- include PDFs from website - what to do with attached Word/Excel files

• landscape for Excel files - check https://www.deddingtonhistory.uk/buildings/windmillcentre - encoding for asset names
• video assets
• PDF outline for PDFs
• review tmp/pdf_duplicates, tmp/ignored_links

Code added to mysource_matrix/core/include/asset.inc:

    /*
     * martin@martinreed.co.uk 2025-09-04
     * Return array: [0] array of webpaths, [1] redirection URL or ''
     */
    public function getAssetUrlsKeywordReplacement()
    {
            // retrieve all existing URLs for this asset
            $sql = 'SELECT l.url, l.http, l.https, u.urlid
                            FROM sq_ast_lookup l
                                    LEFT OUTER JOIN sq_ast_url u ON l.root_urlid = u.urlid
                                    LEFT OUTER JOIN sq_ast_path p ON l.assetid = p.assetid
                            WHERE l.assetid = :assetid';

            try {
                    $query = MatrixDAL::preparePdoQuery($sql);
                    MatrixDAL::bindValueToPdo($query, 'assetid', $this->id);
                    $urls = MatrixDAL::executePdoAssoc($query);
            } catch (Exception $e) {
                    throw new Exception('Unable to get all urls for asset "'.$this->name.'" (#'.$this->id.') due to database error: '.$e->getMessage());
            }
            $urls = array_map(function($url) { return $url['url']; }, $urls);
            if (method_exists($this, '_getRedirectURL')) {
                    $redirect_url = $this->_getRedirectURL();
            }
            else {
                    $redirect_url = '';

            }
            return json_encode([$urls, $redirect_url], JSON_UNESCAPED_SLASHES);
    }

INSTRUCTIONS

• Clear Squiz cache
• Restart Web2Pdf
• http://127.0.0.1:3000/websites/1/spider
• http://127.0.0.1:3000/websites/1/generate_archive
• http://127.0.0.1:3000/websites/1/zip_archive