/**
* Function adds the new promotional codes into the database.
*
*
* @return string
*/
function createPromotionalCodes()
{
/*$sql="SELECT b.category_name as parentcatname ,b.category_id as parentid, a.category_name as subcatname, a.category_id FROM category_table a,category_table b WHERE a.category_parent_id <> 0 AND a.category_parent_id=b.category_id ORDER BY parentcatname";
$obj=new Bin_Query();
$obj->executeQuery($sql);
$arr=$obj->records;*/
$sql = "SELECT category_name as parentcatname ,category_id as parentid FROM category_table WHERE category_parent_id = 0 ORDER BY parentcatname";
$obj = new Bin_Query();
$obj->executeQuery($sql);
$rows = $obj->records;
$i = 0;
foreach ($rows as $row) {
$sql = "SELECT category_id , category_name FROM category_table WHERE category_parent_id = " . $row['parentid'] . " ORDER BY category_name";
$obj1 = new Bin_Query();
$obj1->executeQuery($sql);
$subcats = $obj1->records;
if (count($subcats) > 0) {
$list[$i]['id'] = $row['parentid'];
$list[$i]['catname'] = $row['parentcatname'];
foreach ($subcats as $subcat) {
$list[$i]['subcats'][] = $subcat;
}
$i++;
}
}
$default = new Core_CPromotionalCodes();
return Display_DPromotionalCodes::createPromotionalCodes($list, $default->getRandString(11));
}
