";
$UsersHTML .= "| $i | ";
$UsersHTML .= "" . $row['producttitle'] . " | ";
$UsersHTML .= "" . $row['product_code'] . " | ";
$UsersHTML .= "" . get_category($row['catid']) . " | ";
$UsersHTML .= "{$row['currentstocklevel']} | ";
$UsersHTML .= "{$row['alertcount']} | ";
$UsersHTML .= "";
$UsersHTML = $UsersHTML . " ";
$UsersHTML = $UsersHTML . " ";
$UsersHTML = $UsersHTML . " | ";
$UsersHTML .= "
";
$i ++;
}
}
else
{
$UsersHTML = "
readXmlArrtibut('xml_product_managment.xml', 'Product_Management'); ?>
readXmlArrtibut('xml_product_managment.xml', 'Add_New_Product'); ?>
Edit ALL
';
$Header = $Header . '';
$Footer = '';
$Cat_Query = "SELECT * FROM `category` where `delete` = '0'";
$Exe_Cat_Query = mysql_query($Cat_Query);
while($Cat_Row = mysql_fetch_array($Exe_Cat_Query))
{
$Cat_No = $Cat_Row['id'];
$Category_title = '
'.$Cat_Row['desc'].'
';
$Html = '';
$k = 1;
$Product_Query = "SELECT * FROM `product` where `catid` = '{$Cat_No}' and `delete` = '0' order by producttitle";
$Exe_Product_Query = mysql_query($Product_Query);
while($Porduct_Row = mysql_fetch_array($Exe_Product_Query))
{
$Intransit = $Porduct_Row["in_transit"];
if($Intransit < 0 || $Intransit == '')
{
$Intransit = 0;
}
$Html = $Html .'
';
$Html = $Html . '| '.$k.' | ';
$Html = $Html . '' . $Porduct_Row['producttitle'] . ' | ';
$Html = $Html . '' . $Porduct_Row['product_code'] . ' | ';
$Html = $Html . '' . get_category($Porduct_Row['catid']) . ' | ';
$Html = $Html . "{$Porduct_Row['currentstocklevel']} | ";
$Html = $Html . "$Intransit | ";
$Html = $Html . "{$Porduct_Row['alertcount']} | ";
$Html = $Html . '' . $Porduct_Row['price'] . ' | ';
$Html = $Html . '';
$Html = $Html . " ";
$Html = $Html . "";
$Html = $Html . ' | ';
$Html = $Html . '
';
$k++;
}
if($k > 1)
{
echo $Category_title;
echo $Header;
echo $Html;
echo $Footer;
}
echo "
";
}
?>