function act_delName() { $whereStr = ""; $billArr = array_filter(explode(",", trim($_POST['bill']))); $whereStr = " where id in (" . implode(',', $billArr) . ")"; $listArr = NameSystemModel::delName($whereStr); if ($listArr['reNum'] == '200') { self::$errCode = $listArr['reNum']; self::$errMsg = $listArr['reStr']; return true; } else { self::$errCode = NameSystemModel::$errCode; self::$errMsg = NameSystemModel::$errMsg; return false; } }
public static function nameSystemVerify($addNewName) { self::initDB(); $reInfo = array(); $sql = "select * from " . self::$table1 . " where is_delete != 1 and name = '{$addNewName}'"; $query = self::$dbConn->query($sql); if ($query) { $ret = self::$dbConn->fetch_array_all($query); if (empty($ret)) { $reInfo['reNum'] = "200"; $reInfo['reStr'] = "此帐号名称可以使用!"; } else { $sql2 = "select * from " . self::$table2 . " where is_delete != 1 and id = {$ret[0]['systemTypeId']}"; $query2 = self::$dbConn->query($sql2); $ret2 = self::$dbConn->fetch_array_all($query2); $reInfo['reNum'] = "400"; $reInfo['reStr'] = "此名称已被其他人使用在[{$ret2[0]['systemName']}]系统!"; } return $reInfo; } else { self::$errCode = "4444"; self::$errMsg = "mysql:" . $sql . " error"; return false; } }