/** * 返回国家最大序号 * @access public */ function get_orders() { //查询最大序号 $category_1 = get_post_value('category_1'); $m = new Category(); $m->clear(); $m->setTable('vcb_product_category_2'); $m->setWhere('status', '!=', '60000'); $m->setWhere('category_1_id', '=', $category_1); $data = $m->getFieldValue('MAX(orders) '); // 设置新的序号 if (is_null($data)) { $data = 1; } else { $data += 1; } $this->assign('message', $data); $this->setReturnType('message'); //只返回单值 }
/** * 判断是否存在 * @access private * @param string * @return true|false */ private function verifyCategory3($category_3_id = NULL) { $category_3_cn = get_post_value('category_3_cn'); $category_3_th = get_post_value('category_3_th'); $m = new Category(); $m->clear(); $m->setTable('vcb_product_category_3'); $m->setWhere('status', '!=', '60000'); $m->setWhere('category_3_cn', '=', $category_3_cn, 'AND', '('); $m->setWhere('category_3_th', '=', $category_3_th, 'OR', ')'); if ($category_2_id != null) { $m->setWhere('category_3_id', '!=', $category_3_id); } $data = $m->getFieldValue('COUNT(*)'); //直接返回单条记录 return $data > 0 ? false : true; }