获得徽章 0
vue+Sortable.js拖拽排序数组时拖拽后在onEnd里立刻更新vue数组的顺序的话会导致显示顺序错乱。所以需要将新顺序的数组放临时变量里,把数组清空,渲染完后再把内容填回去。代码如下:
onEnd: function (event) {
var nIndex = event.newIndex, oIndex = event.oldIndex;
me.list.splice(nIndex, 0, me.list.splice(oIndex, 1)[0]);
var newArray = me.list.slice(0);
me.list = [];
vue.$nextTick(function () {
me.list = newArray;
});
}
其中me是vue对象
onEnd: function (event) {
var nIndex = event.newIndex, oIndex = event.oldIndex;
me.list.splice(nIndex, 0, me.list.splice(oIndex, 1)[0]);
var newArray = me.list.slice(0);
me.list = [];
vue.$nextTick(function () {
me.list = newArray;
});
}
其中me是vue对象
展开
评论
点赞
赞了这篇文章
赞了这篇文章
mysql,生成整个table_name库内所有表所有文字字段的a替换成b的update句的sql句,用来作偶尔是全库关键字替换挺不错的。
SET GLOBAL group_concat_max_len=5120;
SET SESSION group_concat_max_len=5120;
SELECT
CONCAT('update ',table_name,' set ',GROUP_CONCAT(CONCAT('`',column_name,'`=replace(`',column_name, '`,''a''',',''b'')') SEPARATOR ','), ';') a
FROM information_schema.COLUMNS WHERE table_schema = 'table_name' AND
-- data_type NOT IN ('int', 'varchar', 'longtext', 'tinyint', 'smallint', 'text', 'tinytext', 'mediumtext', 'char', 'decimal', 'double', 'bigint', 'date', 'float')
data_type NOT IN ('int', 'tinyint', 'smallint', 'decimal', 'double', 'bigint', 'date', 'float')
GROUP BY table_name;
SET GLOBAL group_concat_max_len=5120;
SET SESSION group_concat_max_len=5120;
SELECT
CONCAT('update ',table_name,' set ',GROUP_CONCAT(CONCAT('`',column_name,'`=replace(`',column_name, '`,''a''',',''b'')') SEPARATOR ','), ';') a
FROM information_schema.COLUMNS WHERE table_schema = 'table_name' AND
-- data_type NOT IN ('int', 'varchar', 'longtext', 'tinyint', 'smallint', 'text', 'tinytext', 'mediumtext', 'char', 'decimal', 'double', 'bigint', 'date', 'float')
data_type NOT IN ('int', 'tinyint', 'smallint', 'decimal', 'double', 'bigint', 'date', 'float')
GROUP BY table_name;
展开
评论
点赞
赞了这篇文章
Yii
API
创业
响应式设计