/** * 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)); }