/**
* Get Sub Category
* @param cotegory $id
* @return string
*/
function getSubCategory($id)
{
$mysqli = connectBD();
$sub = '';
$query = "SELECT * FROM categories WHERE id_parent = {$id}";
if ($result = $mysqli->query($query)) {
$sub .= '<ul>';
while ($obj = $result->fetch_object()) {
$article = getArticles($obj->id) ? getArticles($obj->id) : '';
$child = getSubCategory($obj->id) ? getSubCategory($obj->id) : '';
$sub .= '<li>' . $obj->name . '' . $child . $article . '</li>';
}
$sub .= '</ul>';
}
return $sub;
}
function getCategory($n_rows)
{
global $con;
$sql = "SELECT * FROM category";
$run_cat = mysqli_query($con, $sql);
$sql2 = "SELECT cat_id FROM category ORDER BY cat_id DESC LIMIT 1 OFFSET 0";
$result = mysqli_query($con, $sql);
$pole = array();
while ($row = mysqli_fetch_array($result)) {
$pole[] = $row['cat_id'];
}
for ($x = 0; $x < $n_rows; $x++) {
// echo'<p>POCET ROWS'.$x.'</p>';
$row_cat = mysqli_fetch_array($run_cat);
// $cat_id = $row_cat['cat_id'];
$cat_name = $row_cat['cat_name'];
echo '
<a href="#collapse' . $x . '" class="list-group-item list-group-item-info" data-toggle="collapse"
data-parent="#affix_sidebar"><b>' . $cat_name . '</b></a>
';
getSubCategory($x, $pole[$x]);
}
}
<?php
include './config.php';
include './auth.php';
$SubCategory = getSubCategory();
if ($_GET['delete_id']) {
$delete_id = $_GET['delete_id'];
$sql = "DELETE FROM sohorepro_category WHERE id = " . $delete_id . " ";
$sql_result = mysql_query($sql);
if ($sql_result) {
$result = "success_del";
} else {
$result = "failure_del";
}
}
?>
<?php
$id = $_GET['id'];
$editSubCategory = editCategory($id);
$active_category = getCategoryActive();
if ($_REQUEST['edi_subcat'] == '1') {
extract($_POST);
$sql = "UPDATE sohorepro_category
SET category_name = '" . $subcategory_name . "',
parent_id = '" . $category_name . "',
status = '" . $status . "' WHERE id = " . $id . " ";
$sql_result = mysql_query($sql);
if ($sql_result) {
$result = "success";
unlink('no1.csv');
}
$fp = fopen("no1.csv", "a+");
foreach ($data as $value) {
$imgStr = '';
$sizeArray = array();
$packArray = array();
$category = $value['category'];
if ($category == 'active-wear') {
$category = 'activewear';
}
$subcategory = $value['subcategory'];
$tempData = json_decode($value['data'], TRUE);
/*Get Category String*/
$category = getCategory($value['category'], $value['subcategory'], $tempData['title'][0]);
$subCategory = getSubCategory($value['category'], $value['subcategory'], $tempData['title'][0]);
$categoryStr = getCategoryString($category, $subCategory);
/*Get dimension*/
$dimension = getDimensions($category, $subcategory);
$csvData[$count]['category'] = $category;
$csvData[$count]['subCategory'] = $subCategory;
$csvData[$count]['category_str'] = $categoryStr;
$csvData[$count]['price'] = getSalePrice(str_replace('$', '', trim($tempData['price'])));
$csvData[$count]['weight'] = $dimension['weight'];
$csvData[$count]['auctioninc_product_length'] = $dimension['length'];
$csvData[$count]['auctioninc_product_width'] = $dimension['width'];
$csvData[$count]['auctioninc_product_height'] = $dimension['height'];
$csvData[$count++]['prod_url'] = $value['url'];
}
// Writing Header
fputcsv($fp, array_keys($csvData[0]));
<?php
include './config.php';
include './auth.php';
$sort_sc = ($_REQUEST['sort'] == 'sca') ? 'scd' : 'sca';
$sort_sc_img = ($_REQUEST['sort'] == 'sca') ? 'down' : 'up';
$SubCategory = getSubCategory($_REQUEST['sort']);
if ($_GET['delete_id']) {
$delete_id = $_GET['delete_id'];
$sql = "DELETE FROM sohorepro_category WHERE id = " . $delete_id . " ";
$sql_result = mysql_query($sql);
if ($sql_result) {
$result = "success_del";
} else {
$result = "failure_del";
}
}
?>
<?php
$page=1;//Default page
$limit=20;//Records per page
$start=0;//starts displaying records from 0
if(isset($_GET['page']) && $_GET['page']!=''){
$page=$_GET['page'];
}
$start=($page-1)*$limit;
public function mutildialog()
{
$product = D('ProductView');
// 实例化对象
$category = D('ProductCategory');
// 实例化对象
$where = array();
$list = $product->order('product_id desc')->where($where)->limit(10)->select();
$count = $product->where($where)->count();
$category_list = $category->select();
$this->treecode = getSubCategoryTreeCode(0, 1);
$this->categoryList = getSubCategory(0, $category_list, '');
//类别选项
$this->total = $count % 10 > 0 ? ceil($count / 10) : $count / 10;
$this->count_num = $count;
$this->assign('list', $list);
// 赋值数据集
$this->display();
// 输出模板
}
public function excelImport()
{
C('TOKEN_ON', false);
$m_knowledge = M('knowledge');
if ($_POST['submit']) {
if (isset($_FILES['excel']['size']) && $_FILES['excel']['size'] != null) {
import('@.ORG.UploadFile');
$upload = new UploadFile();
$upload->maxSize = 20000000;
$upload->allowExts = array('xls');
$dirname = UPLOAD_PATH . date('Ym', time()) . '/' . date('d', time()) . '/';
if (!is_dir($dirname) && !mkdir($dirname, 0777, true)) {
alert('error', L('ATTACHMENTS TO UPLOAD DIRECTORY CANNOT WRITE'), U('knowledge/index'));
}
$upload->savePath = $dirname;
if (!$upload->upload()) {
alert('error', $upload->getErrorMsg(), U('knowledge/index'));
} else {
$info = $upload->getUploadFileInfo();
}
}
if (is_array($info[0]) && !empty($info[0])) {
$savePath = $dirname . $info[0]['savename'];
} else {
alert('error', L('UPLOAD FAILED'), U('knowledge/index'));
}
import("ORG.PHPExcel.PHPExcel");
$PHPExcel = new PHPExcel();
$PHPReader = new PHPExcel_Reader_Excel2007();
if (!$PHPReader->canRead($savePath)) {
$PHPReader = new PHPExcel_Reader_Excel5();
}
$PHPExcel = $PHPReader->load($savePath);
$currentSheet = $PHPExcel->getSheet(0);
$allRow = $currentSheet->getHighestRow();
if ($allRow <= 1) {
alert('error', L('UPLOAD A FILE WITHOUT A VALID DATA'), U('knowledge/index'));
} else {
for ($currentRow = 3; $currentRow <= $allRow; $currentRow++) {
$data = array();
$data['category_id'] = intval($_POST['category_id']);
$data['role_id'] = session('role_id');
$data['create_time'] = time();
$data['update_time'] = time();
$title = (string) $currentSheet->getCell('A' . $currentRow)->getValue();
if ($title != '' && $title != null) {
$data['title'] = $title;
}
$category = (string) $currentSheet->getCell('B' . $currentRow)->getValue();
$category_id = M('KnowledgeCategory')->where('name = "%s"', trim($category))->getField('category_id');
if ($category) {
if ($category_id > 0) {
$data['category_id'] = $category_id;
} else {
if ($this->_post('error_handing', 'intval', 0) == 0) {
alert('error', L('IMPORT_FAILY_SOURCE_NOT_EXIST', array($currentRow, $category)), U('knowledge/index'));
} else {
$error_message .= L('FAILY_SOURCE_NOT_EXIST', array($currentRow, $category));
}
break;
}
}
$content = (string) $currentSheet->getCell('C' . $currentRow)->getValue();
if ($content != '' && $content != null) {
$data['content'] = $content;
}
if (!$m_knowledge->add($data)) {
if ($this->_post('error_handing', 'intval', 0) == 0) {
alert('error', L('IMPORT_FAILY_SOURCE', array($currentRow)), U('knowledge/index'));
} else {
$error_message .= L('FAILY_SOURCE', array($currentRow, $m_knowledge->getError()));
$m_knowledge->clearError();
}
break;
}
}
alert('success', $error_message . L('IMPORT SUCCESS'), U('knowledge/index'));
}
} else {
$this->category_list = getSubCategory(0, M('KnowledgeCategory')->select(), '');
$this->display();
}
}
function kids($category, $subCategory, $title)
{
global $leggings, $active, $palazzo, $pants, $printed, $missy, $leather, $fitness, $sublimation, $jeggings, $capri, $skirts, $jogger, $jeans, $harem, $seamless, $shorts, $basic;
$subCategory = getSubCategory($subCategory, $title);
$removableChars = array(" ", "_", ":", ";");
$lstr = trim(strtolower(str_replace($removableChars, "-", $title)));
if ($subCategory == 'skirt' || $subCategory == 'skirts' || preg_match_all($skirts, $lstr, $matches)) {
return '/skirt';
} else {
if ($subCategory == 'palazzo' || preg_match_all($palazzo, $lstr, $matches)) {
return '/palazzo';
} else {
if ($subCategory == 'leggings' || $subCategory == 'legging' || preg_match_all($leggings, $lstr, $matches)) {
return '/leggings';
} else {
return '';
}
}
}
}
function getSubCategory($parentid)
{
$querySubCat = "select * from category where deleted=0 and parentid= '{$parentid}' and status=0 ORDER BY sort_order ASC ";
$results = mysql_query($querySubCat);
$subUlOpen = "<ul>";
$subUlClose = "</ul>";
$subMenuHtml = "";
$subMenu = "";
$SubCategoryData = "";
while ($obj = mysql_fetch_object($results)) {
$SubCategoryData[] = $obj;
}
if ($SubCategoryData != "") {
foreach ($SubCategoryData as $subcategory) {
$subMenuHtml = $subMenuHtml . "<li class='category'><a href='http://" . $_SERVER['SERVER_NAME'] . "" . BaseUrl . "pages/index.php?categoryId=" . $subcategory->category_id . "'>" . $subcategory->title . "</a>" . getSubCategory($subcategory->category_id) . "</li>";
$subMenuHtml = $subMenuHtml . createPagesMenu($subcategory->category_id);
}
$subMenu = $subMenuHtml;
}
if (checkDataExit($parentid)) {
$subMenu = $subUlOpen . $subMenu . createPagesMenu($parentid) . $subUlClose;
} else {
$subMenu = $subMenu . createPagesMenu($parentid);
}
return $subMenu;
}
<?php
require_once 'functions.php';
$mysqli = connectBD();
$query = "SELECT * FROM categories WHERE id_parent = 0";
if ($result = $mysqli->query($query)) {
?>
<ul>
<?php
while ($obj = $result->fetch_object()) {
$article = getArticles($obj->id) ? getArticles($obj->id) : '';
$sub = getSubCategory($obj->id) ? getSubCategory($obj->id) : '';
echo '<li>' . $obj->name . '' . $sub . $article . '</li>';
}
?>
</ul>
<?php
}
