function serProductAndCategoriesSerialization($fileName)
{
$f = gzopen($fileName, "w");
$xmlTables = new XmlNode();
$xmlTables->LoadInnerXmlFromFile(DATABASE_STRUCTURE_XML_PATH);
$array = $xmlTables->SelectNodes("DataBaseStructure/tables/table");
foreach ($array as $xmlTable) {
$attrubtes = $xmlTable->GetXmlNodeAttributes();
if (isset($attrubtes["PRODUCTANDCATEGORYSYNC"])) {
if (strtoupper($attrubtes["PRODUCTANDCATEGORYSYNC"]) == "TRUE") {
$res = _tableSerialization($xmlTable);
gzputs($f, $res . "\n");
}
}
}
gzclose($f);
}
function GetColumnDataType($columnName, $tableName, $fileName)
{
$xmlTables = new XmlNode();
$xmlTables->LoadInnerXmlFromFile($fileName);
$array = $xmlTables->SelectNodes("DataBaseStructure/tables/table");
foreach ($array as $xmlTable) {
$attr = $xmlTable->GetXmlNodeAttributes();
$tableName = $attr["NAME"];
if (trim($tableName) == trim($tableName)) {
$arrayColumn = $xmlTable->SelectNodes("table/column");
foreach ($arrayColumn as $xmlColumn) {
if (trim($xmlColumn->GetXmlNodeData()) == trim($columnName)) {
$attributes = $xmlColumn->GetXmlNodeAttributes();
return strtoupper($attributes["TYPE"]);
}
}
}
}
return false;
}
