public static function changeCategory($condition, $category) { self::initDB(); $sql = "UPDATE `qc_category_type_relation` SET sampleTypeId={$category} WHERE path like '{$condition}'"; //echo $sql; $query = self::$dbConn->query($sql); if ($query) { //$ret =self::$dbConn->fetch_array_all($query); return true; } else { self::$errCode = "003"; self::$errMsg = "444444444"; return false; //失败则设置错误码和错误信息, 返回false } }
function act_getSampleTypeName($path) { $reDataArr = array(); $whereStr = " where path = '{$path}' AND is_delete != 1 "; $selectStr = "`path`,`sampleTypeId`"; $sampleTypeIdArr = qcCategoryListModel::getCategoryList($selectStr, $whereStr); if (empty($sampleTypeIdArr)) { return false; } $whereStr2 = " where id = {$sampleTypeIdArr[0]['sampleTypeId']} "; $qcStandardModel = new qcStandardModel(); $listArr = $qcStandardModel->skuTypeQcList($whereStr2); if (empty($listArr)) { return false; } else { $reDataArr[$sampleTypeIdArr[0]['sampleTypeId']] = $listArr[0]['typeName'] . "-" . $listArr[0]['describe']; return $reDataArr; } }
public function view_skuCategoryList() { if (!isset($_SESSION['userName'])) { header('Location:index.php?mod=login&act=index'); } require_once WEB_PATH . "lib/Tree.class.php"; //调用action层, 获取列表数据 /*$OmAvailableApiAct = new OmAvailableApiAct(); $skuTypeQcArrList = $OmAvailableApiAct->act_getCategoryInfoAll();*/ $qcCategoryListAct = new qcCategoryListAct(); $condition = isset($_GET['condition']) ? trim($_GET['condition']) : ""; if ($condition != "") { $info = "and path like '{$condition}'"; } else { $info = ""; } $where = "WHERE is_delete=0 {$info} "; $total = $qcCategoryListAct->act_getCategoryListNum($where); $num = 100; //每页显示的个数 $page = new Page($total, $num, '', 'CN'); $where .= "ORDER BY path "; $where .= $page->limit; $qcStandard = new qcStandardAct(); $skuTypeQcArrList = $qcStandard->act_skuTypeQcList($this->where); $sampleTypeList = array(); foreach ($skuTypeQcArrList as $skuTypeQcArrListValue) { $sampleTypeList[$skuTypeQcArrListValue['id']] = $skuTypeQcArrListValue['typeName']; } $categoryList = $qcCategoryListAct->act_getCategoryList('*', $where); /*$menu = new Tree(); $menu->icon = array('', '', ''); $menu->nbsp = ' '; foreach ($categoryList as $n => $t) { $result[$n]['checked'] = '';//($this->is_checked($t, $roleid, $priv_data)) ? ' checked' : ''; $result[$n]['level'] = $t['file']; $result[$n]['parentid'] = $t['pid'] ? $t['pid'] : 0; $result[$n]['id'] = $t['id']; $result[$n]['name'] = $t['name']; $result[$n]['sampleTypeId'] = $t['sampleTypeId']; $result[$n]['sampleType'] = isset($sampleTypeList[$t['sampleTypeId']]) ? $sampleTypeList[$t['sampleTypeId']] : ''; $result[$n]['parentid_node'] = ($t['pid']) ? ' class="child-of-node-' . $t['pid'] . '"' : ''; } $str = "<tr data-tt-id='\$id' \$parentid_node> <td style='padding-left:30px;'>\$name</td> <td style='padding-left:30px;'>\$level</td> <td> ".tep_selectHTML_show($sampleTypeList, 'choiceSampleType_\$id', '\$sampleTypeId')." </td> <td style='padding-left:30px;'>\$sampleType</td> </tr>"; $str = "<tr id='node-\$id' \$parentid_node> <td style='padding-left:30px;' align='left'>\$spacer \$name</td> <td> <a class='btn' href='__URL__/add?id={\$id}' target='_blank'><i class='icon-plus'></i></a> <a class='btn' href='__URL__/edit?id={\$id}'><i class='icon-pencil'></i></a> <a class='btn' href='__URL__/delete?id={\$id}'><i class='icon-trash'></i></a> </td> </tr>"; $menu->init($result); $categoryList = $menu->get_tree(0, $str);*/ //'<i class="icon-plus"></i>' //var_dump($categoryList); if (!empty($_GET['page'])) { if (intval($_GET['page']) <= 1 || intval($_GET['page']) > ceil($total / $num)) { $n = 1; } else { $n = (intval($_GET['page']) - 1) * $num + 1; } } else { $n = 1; } if ($total > $num) { //输出分页显示 $show_page = $page->fpage(array(0, 2, 3, 4, 5, 6, 7, 8, 9)); } else { $show_page = $page->fpage(array(0, 2, 3)); } $this->smarty->assign('show_page', $show_page); $this->smarty->assign('sampleTypeList', $sampleTypeList); //print_r($sampleTypeList); //二级导航 $this->smarty->assign('secnev', '4'); $this->smarty->assign('module', '产品分类列表'); $this->smarty->assign('username', $_SESSION['userName']); $navarr = array("<a href='index.php?mod=nowSampleStandard&act=nowSampleType'>QC检测标准</a>", ">>", "产品分类列表"); $this->smarty->assign('navarr', $navarr); $category1 = qcCategoryListModel::getCategory1(); $this->smarty->assign("category1", $category1); $this->smarty->assign('categoryList', $categoryList); $this->smarty->display('qcCategoryList.htm'); }