https://www.graphicz.solutions/1823searchdifferences/actinicsearch.js.1823.txt https://www.graphicz.solutions/1823searchdifferences/SearchScript.pl.1823.txt
<actinic:variable name="CatalogURL" /><actinic:block php="true">
$dpecmajor = <actinic:variable name="ECMajorVersion" selectable="false" />;
$dpispreview = <actinic:variable name="IsPreviewMode" selectable="false" />;
include_once "getsectionfilename.php";
echo GetProdPageName("<actinic:variable name="ProductID" selectable="false" />");
</actinic:block>#<actinic:variable Name="EncodedProductAnchor" />
<?php
/***************************************************************
* GetSectFileName - A support function for Ref2File
***************************************************************/
function GetSectFileName($sectref)
{
global $dpecmajor, $dpispreview;
$previewprefix = $dpispreview ? 'P_' : '';
$connect = odbc_connect("ActinicCatalog" . $dpecmajor,"","");
$query = "SELECT [sPageName] FROM [Catalog Section] WHERE [nSectionID]=".$sectref."";
$result = odbc_exec($connect, $query);
while(odbc_fetch_row($result)){
$url = odbc_result($result, 1);
}
odbc_close($connect);
return $previewprefix . $url;
}
/***************************************************************
* GetProdPageName - Return Product Page FIleName if it exists - else Section File Name
***************************************************************/
function GetProdPageName($prodrefs)
{
global $dpecmajor, $dpispreview;
$previewprefix = $dpispreview ? 'P_' : '';
$prodrefs = str_replace("{","",$prodrefs);
$prodrefs = str_replace("}","",$prodrefs);
$connect = odbc_connect("ActinicCatalog" . $dpecmajor, "", "");
$query = "SELECT nParentSectionID, bGenerateSingleProductPage, sSingleProductPageName FROM [product] WHERE [Product Reference]='".$prodrefs."'";
$result = odbc_exec($connect, $query);
while(odbc_fetch_row($result)){
$parentid = odbc_result($result, 1);
$hasproductpage = odbc_result($result, 2);
$productpagename = odbc_result($result, 3);
}
odbc_close($connect);
if ( $hasproductpage ) return $previewprefix . $productpagename;
return GetSectFileName($parentid);
}
/***************************************************************
* GetProdParent - A support function for Ref2File
***************************************************************/
function GetProdParent($prodrefs)
{
global $dpecmajor, $dpispreview;
$prodrefs = str_replace("{","",$prodrefs);
$prodrefs = str_replace("}","",$prodrefs);
$connect = odbc_connect("ActinicCatalog" . $dpecmajor,"","");
$query = "SELECT [nParentSectionID] FROM [product] WHERE [Product Reference]='".$prodrefs."'";
$result = odbc_exec($connect, $query);
while(odbc_fetch_row($result)){
$parentid = odbc_result($result, 1);
}
odbc_close($connect);
return $parentid;
}
/***************************************************************
* GetSectParent- A support function for Ref2File
***************************************************************/
function GetSectParent($sectrefs)
{
global $dpecmajor, $dpispreview;
$sectrefs = str_replace("{","",$sectrefs);
$sectrefs = str_replace("}","",$sectrefs);
$connect = odbc_connect("ActinicCatalog" . $dpecmajor,"","");
$query = "SELECT [nParentSectionID] FROM [Catalog section] WHERE [nSectionID]=".$sectrefs."";
$result = odbc_exec($connect, $query);
while(odbc_fetch_row($result)){
$parentid = odbc_result($result, 1);
}
odbc_close($connect);
return $parentid;
}
/***************************************************************
* Ref2file - Use Actinic's pwn database, to convert a prod ref, to a filename
* @param int $ref the product reference.
* @author Gabriel Crowe + NormanRouxel 08 September 2007
*
* usage example:
<a href="<actinic:variable name="CatalogURL" /><actinic:block php="true">echo Ref2file("<actinic:variable Name="ProductReference" />");</actinic:block>">Link Text</a>
***************************************************************/
function Ref2File($ref) {
return GetSectFileName(GetProdParent($ref));
}
function Ref2ParentFile($ref) {
return GetSectFileName(GetSectParent(GetProdParent($ref)));
}
?>
Comment