function addApplication($arr) { $conn = getConnection(); $name = $arr['appNme']; $desc = str_replace("'", '`', $arr['appDsc']); $src = $arr['src']; $categoryID = getCategoryID($arr['catOpt']); $ioslink = $arr['ioslink']; $andlink = $arr['andlink']; $sql = "INSERT INTO `apps` (AppName, AppDesc, ImgSrc, CatID)\n VALUES ('" . $name . "', '" . $desc . "', '" . $src . "', '" . $categoryID . "')"; $conn->query($sql); $appID = getAppID($name); $sql = "INSERT INTO `link` (AppID, IOS, Android)\n VALUES ('" . $appID . "', '" . $ioslink . "', '" . $andlink . "')"; $ret = $conn->query($sql); $conn->close(); return $ret; }
function processFile($path) { $content = file_get_contents($path); $lines = explode("\n", $content); $header = explode(VALUE_SEPARATOR, $lines[0]); //for($i = 0; $i < count($header); $i++) // echo $header[$i] . "<br>"; //echo $content; for ($i = 1; $i < count($lines); $i++) { $oneLine = explode(VALUE_SEPARATOR, addslashes($lines[$i])); $supplierID = getSupplierID($oneLine[0]); $categoryID = getCategoryID($oneLine[1]); $producyTypeID = getProductTypeID($oneLine[2]); $producyID = getProduct($supplierID, $categoryID, $producyTypeID, $oneLine[3], $oneLine[4], $oneLine[5], $oneLine[6]); /* echo "$oneLine[0] ($supplierID)<br>"; echo "$oneLine[1] ($categoryID)<br>"; echo "$oneLine[2] ($producyTypeID)<br>"; echo "$oneLine[3] ($producyID)<br>"; */ } echo "<hr>\n\n"; }
} else { if ($product_name) { // if products name is defined add it $pid = insertProduct($product_name, $model, $price); $referred_cid = array(); // hold the refereed cid $multicats = checkMultiCat($pid); $category2 = explode(';', $category); for ($c = 0; $c < count($category2); $c++) { $catdata = explode('||', $category2[$c]); $catdata_id = array(); for ($s = 0; $s < count($catdata); $s++) { if ($s > 0) { $cid = getCategoryID($catdata[$s], $this->sys_language_uid, $catdata_id[$s - 1]); } else { $cid = getCategoryID($catdata[$s], $this->sys_language_uid); } if (!$cid) { if ($s > 0) { $cid = insertCategory($catdata[$s], $this->shop_pid, $this->sys_language_uid, $catdata_id[$s - 1]); } else { $cid = insertCategory($catdata[$s], $this->shop_pid, $this->sys_language_uid, 0); } } $catdata_id[$s] = $cid; } if (count($category2) > 1) { productToCategories($pid, $catdata_id[count($catdata_id) - 1]); $referred_cid[] = $catdata_id[count($catdata_id) - 1]; } else { productToCategories($pid, $catdata_id[count($catdata_id) - 1]);
function defaultsubcatlevel($catid, $catlevel) { $lvl2subcats = modApiFunc("Catalog", "getSubCategories", $catid); // Checking for subcategories which have level greater than 1 if ($catlevel > 1) { $catname = getCategoryName($catid); $catlink = getCategoryLink($catid); $value = ""; $value .= "<li><a href='{$catlink}'><span>" . $catname . "</span></a><div><ul>"; } //Get subcategories for level2 and below $count = count($lvl2subcats) - 1; while ($count >= 0) { $value .= $this->defaultsubcatlevel(getCategoryID($lvl2subcats[$count]["category_id"]), 2); $count = $count - 1; } if ($catlevel > 1) { $value .= "</ul></div>"; } return $value; }