SqlScreen.qml 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446
  1. //TableWidget.qml
  2. import Felgo
  3. import QtQuick
  4. import QtQuick.Controls
  5. import QtQuick.Window
  6. import QtQuick.Dialogs
  7. import QtQuick.LocalStorage
  8. import EasyModel 1.0
  9. import com.example.database 1.0
  10. import "../common"
  11. import "../controls"
  12. //自定义QtQuick 2中的TableView
  13. AppPage {
  14. id: sqlite_page
  15. implicitHeight: 800
  16. implicitWidth: 1280
  17. rightBarItem: IconButtonBarItem {
  18. iconType: IconType.paintbrush
  19. onClicked: {
  20. console.log("database")
  21. sqliteModal.open()
  22. }
  23. }
  24. //行表头-竖向的
  25. property int verHeaderHeight: 30
  26. property int verHeaderWidth: 150
  27. //列表头-横向的
  28. property int horHeaderHeight: 30
  29. //滚动条
  30. property color scrollBarColor: "cyan"
  31. property int scrollBarWidth: 6
  32. //列宽
  33. property variant columnWidthArr: [30,100,100,100,100,100,200,100,100,100,100,100,100]
  34. property variant table_mqtt_Value: ["id","dtype","ip","port","imei","uid","pwd","clientid","qos","keepalive","sub","pub","offline"]
  35. property variant table_ftp_Value: ["id","ip","port","dir","uid","pwd","mode"]
  36. property variant table_location_Value: ["id","lbs_lat","lbs_lng","gps_lat","gps_lng","gps_elevation"]
  37. property variant table_camera_Value: ["camera_type","mode","stitch_photonum","photo_width","photo_height","auto_focus","movz_f","movz_b","movx_f","movz_b"]
  38. property variant table_json_Value: ["id","datetime","json_data","json_data"]
  39. property int datacount: 1
  40. DatabaseInterface
  41. {
  42. id: db_cfg
  43. }
  44. EasyTableModel{
  45. id: table_model
  46. horHeader: table_mqtt_Value
  47. //initData: []//myClass.getdata_JsonArray()
  48. //initData: []
  49. }
  50. //表格内容(不包含表头)
  51. TableView{
  52. id: table_view
  53. height: sqlite_page.implicitHeight
  54. anchors{
  55. left: parent.left
  56. right: parent.right
  57. top: parent.top
  58. leftMargin: 30
  59. topMargin: sqlite_page.horHeaderHeight
  60. }
  61. clip: true
  62. boundsBehavior: Flickable.StopAtBounds
  63. columnSpacing: 1
  64. rowSpacing: 1
  65. //视图的高度
  66. //contentHeight: rowHeightProvider(0) * rows + rowHeightProvider(rows-1)
  67. //视图的宽度
  68. //contentWidth:
  69. //content内容区域边距,但是不影响滚动条的位置
  70. //leftMargin:
  71. //topMargin:
  72. //此属性可以包含一个函数,该函数返回模型中每行的行高
  73. rowHeightProvider: function (row) {
  74. return sqlite_page.verHeaderHeight;
  75. }
  76. //此属性可以保存一个函数,该函数返回模型中每个列的列宽
  77. columnWidthProvider: function (column) {
  78. return sqlite_page.columnWidthArr[column];
  79. //return Math.max(1, (table_view.width - leftMargin) / table_view.columns)
  80. }
  81. ScrollBar.vertical: ScrollBar {
  82. id: scroll_vertical
  83. anchors.right: parent.right
  84. anchors.rightMargin: 2
  85. //active: table_view.ScrollBar.vertical.active
  86. //policy: ScrollBar.AsNeeded
  87. contentItem: Rectangle{
  88. visible: (scroll_vertical.size<1.0)
  89. implicitWidth: sqlite_page.scrollBarWidth
  90. color: sqlite_page.scrollBarColor
  91. }
  92. }
  93. ScrollBar.horizontal: ScrollBar {
  94. id: scroll_horizontal
  95. anchors.bottom: parent.bottom
  96. anchors.bottomMargin: 2
  97. //active: table_view.ScrollBar.vertical.active
  98. //policy: ScrollBar.AsNeeded
  99. contentItem: Rectangle{
  100. visible: (scroll_horizontal.size<1.0)
  101. implicitHeight: sqlite_page.scrollBarWidth
  102. color: sqlite_page.scrollBarColor
  103. }
  104. }
  105. //model是在C++中定义的,和QtC++是类似的
  106. model: table_model
  107. delegate: Rectangle {
  108. color: (model.row%2)?"orange":Qt.darker("orange") //根据行数设置背景颜色
  109. AppText{
  110. id : value_text
  111. anchors.centerIn: parent
  112. verticalAlignment: Text.AlignVCenter
  113. // 水平居中对齐
  114. horizontalAlignment: Text.AlignHCenter
  115. //elide: Text.ElideRight
  116. // selectByMouse: true
  117. // selectedTextColor: "black"
  118. // selectionColor: "white"
  119. //获取单元格对应的值
  120. text: model.value
  121. AppButton {
  122. onClicked: {
  123. var dialog = InputDialog.inputTextSingleLine(app,
  124. "请输入要修改内容",
  125. value_text.text,
  126. function(ok,text){
  127. if(ok){
  128. value_text.text = text
  129. model.edit=text;
  130. //将改变写入到数据库中
  131. console.log("edit",model.value)
  132. if(sqlite_switch.checked)
  133. {
  134. if(table_combox.displayText===table_combox.model[0]||table_combox.displayText===table_combox.model[1])
  135. {
  136. columnWidthArr = [30,100,100,100,100,100,200,100,100,100,100,100,100]
  137. db_cfg.updateData(table_combox.displayText,table_mqtt_Value[index],model.value)
  138. }
  139. if(table_combox.displayText===table_combox.model[2]||table_combox.displayText===table_combox.model[3])
  140. {
  141. db_cfg.updateData(table_combox.displayText,table_ftp_Value[index],model.value)
  142. }
  143. if(table_combox.displayText===table_combox.model[4])
  144. {
  145. db_cfg.updateData(table_combox.displayText,table_location_Value[index],model.value)
  146. }
  147. if(table_combox.displayText===table_combox.model[5]){
  148. db_cfg.updateData(table_combox.displayText,table_camera_Value[index],model.value)
  149. }
  150. }
  151. }
  152. })
  153. // Disable the negative action
  154. dialog.negativeAction = false
  155. // Dismiss when touched outside
  156. dialog.outsideTouchable = true
  157. }
  158. }
  159. // onEditingFinished: {
  160. // model.edit=text;
  161. // //将改变写入到数据库中
  162. // console.log("edit",model.value)
  163. // if(sqlite_switch.checked)
  164. // {
  165. // if(table_combox.displayText===table_combox.model[0]||table_combox.displayText===table_combox.model[1])
  166. // {
  167. // db_cfg.updateData(table_combox.displayText,table_mqtt_Value[index],model.value)
  168. // }
  169. // if(table_combox.displayText===table_combox.model[2]||table_combox.displayText===table_combox.model[3])
  170. // {
  171. // db_cfg.updateData(table_combox.displayText,table_ftp_Value[index],model.value)
  172. // }
  173. // if(table_combox.displayText===table_combox.model[4])
  174. // {
  175. // db_cfg.updateData(table_combox.displayText,table_location_Value[index],model.value)
  176. // }
  177. // }
  178. // }
  179. }
  180. }
  181. }
  182. //横项表头
  183. Item{
  184. id: header_horizontal
  185. anchors{
  186. left: parent.left
  187. right: parent.right
  188. leftMargin: 30//control.verHeaderWidth
  189. }
  190. height: sqlite_page.horHeaderHeight
  191. z: 2
  192. //暂存鼠标拖动的位置
  193. property int posXTemp: 0
  194. MouseArea{
  195. anchors.fill: parent
  196. onPressed: {
  197. header_horizontal.posXTemp=mouseX;
  198. }
  199. onPositionChanged: {
  200. if(table_view.contentX+(header_horizontal.posXTemp-mouseX)>0){
  201. table_view.contentX+=(header_horizontal.posXTemp-mouseX);
  202. }else{
  203. table_view.contentX=0;
  204. }
  205. header_horizontal.posXTemp=mouseX;
  206. }
  207. }
  208. Row {
  209. id: header_horizontal_row
  210. anchors.fill: parent
  211. leftPadding: -table_view.contentX
  212. clip: true
  213. spacing: 0
  214. Repeater {
  215. model: table_view.columns > 0 ? table_view.columns : 0
  216. Rectangle {
  217. id: header_horizontal_item
  218. width: table_view.columnWidthProvider(index)+table_view.columnSpacing
  219. height: sqlite_page.horHeaderHeight
  220. color: "purple"
  221. AppText {
  222. anchors.centerIn: parent
  223. text: table_model.headerData(index, Qt.Horizontal)
  224. }
  225. Rectangle{
  226. width: 1
  227. height: parent.height
  228. anchors.right: parent.right
  229. color: "black"
  230. opacity: 0.5
  231. }
  232. MouseArea{
  233. width: 3
  234. height: parent.height
  235. anchors.right: parent.right
  236. cursorShape: Qt.SplitHCursor
  237. onPressed: header_horizontal.posXTemp=mouseX;
  238. onPositionChanged: {
  239. if((header_horizontal_item.width-(header_horizontal.posXTemp-mouseX))>10){
  240. header_horizontal_item.width-=(header_horizontal.posXTemp-mouseX);
  241. }else{
  242. header_horizontal_item.width=10;
  243. }
  244. header_horizontal.posXTemp=mouseX;
  245. sqlite_page.columnWidthArr[index]=(header_horizontal_item.width-table_view.columnSpacing);
  246. //刷新布局,这样宽度才会改变
  247. table_view.forceLayout();
  248. }
  249. }
  250. }
  251. }
  252. }
  253. }
  254. //竖向表头
  255. Column {
  256. id: header_verical
  257. height: sqlite_page.implicitHeight
  258. anchors{
  259. left: parent.left
  260. top: parent.top
  261. //bottom: parent.bottom
  262. topMargin: sqlite_page.horHeaderHeight
  263. }
  264. topPadding: -table_view.contentY
  265. z: 2
  266. clip: true
  267. spacing: 1
  268. Repeater {
  269. model: table_view.rows > 0 ? table_view.rows : 0
  270. Rectangle {
  271. width: 30
  272. height: table_view.rowHeightProvider(index)
  273. color: "green"
  274. Text {
  275. anchors.centerIn: parent
  276. text: table_model.headerData(index, Qt.Vertical)
  277. }
  278. }
  279. }
  280. }
  281. // JsonListModel {
  282. // id: jsonModel
  283. // source: table_model.initData
  284. // keyField: "id"
  285. // }
  286. // AppListView {
  287. // anchors.fill: parent
  288. // bottomMargin: nativeUtils.safeAreaInsets.bottom
  289. // model: jsonModel
  290. // delegate: SimpleRow {
  291. // text: model.sub
  292. // }
  293. // // Transition animation for adding items
  294. // add: Transition {
  295. // NumberAnimation {
  296. // property: "opacity"
  297. // from: 0
  298. // to: 1
  299. // duration: 1000
  300. // easing.type: Easing.OutQuad
  301. // }
  302. // }
  303. // }
  304. AppModal {
  305. id: sqliteModal
  306. fullscreen: false
  307. modalHeight: dp(380) + nativeUtils.safeAreaInsets.bottom
  308. NavigationStack {
  309. AppPage {
  310. title: "配置信息管理"
  311. rightBarItem: TextButtonBarItem {
  312. text: "关闭"
  313. textItem.font.pixelSize: sp(16)
  314. onClicked: sqliteModal.close()
  315. }
  316. Column {
  317. id: sqliteColumn
  318. width: parent.width
  319. Section {
  320. title: "数据库"
  321. ComboBox {
  322. id: sqlite_combox
  323. height: dp(40)
  324. width: parent.width/2
  325. model: ["config.db", "data.db"]
  326. }
  327. }
  328. Section {
  329. title: "数据表"
  330. ComboBox {
  331. id: table_combox
  332. height: dp(40)
  333. width: parent.width/2
  334. model: ["mqtt", "mqtt_other","ftp","ftp_other","location","camera","data"]
  335. onActivated: {
  336. console.log(displayText)
  337. table_model.table_name = displayText
  338. if(displayText===model[0]||displayText===model[1])
  339. {
  340. columnWidthArr = [30,100,100,100,100,100,200,100,100,100,100,100,100]
  341. table_model.horHeader = table_mqtt_Value
  342. }
  343. else if(displayText===model[2]||displayText===model[3])
  344. {
  345. table_model.horHeader = table_ftp_Value
  346. }
  347. else if(displayText===model[4])
  348. {
  349. table_model.horHeader = table_location_Value
  350. }else if(displayText===model[5]){
  351. columnWidthArr = [100,100,150,100,100,100,100,100,100,100]
  352. table_model.horHeader = table_camera_Value
  353. }
  354. else if(displayText===model[6])
  355. {
  356. table_model.horHeader = table_json_Value
  357. }
  358. table_model.initData=db_cfg.queryData(displayText,datacount)
  359. }
  360. }
  361. }
  362. AppText {
  363. id: sqlite_text
  364. text: "开关:"
  365. }
  366. AppSwitch {
  367. id: sqlite_switch
  368. anchors.left: sqlite_text.light
  369. anchors.leftMargin: 10
  370. onToggled: {
  371. if(sqlite_switch.checked){
  372. var dbs = db_cfg.openDatabase(sqlite_combox.displayText)
  373. if(dbs){
  374. console.log("打开数据库成功");
  375. sqlite_combox.enabled = false
  376. table_combox.enabled = true
  377. if(sqlite_combox.displayText==="data.db")
  378. {
  379. table_combox.displayText=table_combox.model[6];
  380. }
  381. table_model.table_name = table_combox.displayText
  382. table_model.initData=db_cfg.queryData(table_combox.displayText,datacount)
  383. //text_row_count.text = db_cfg.getTable_row(table_combox.displayText)
  384. //rowindex_text.text = datacount
  385. }else{
  386. sqlite_switch.checked = false
  387. sqlite_combox.enabled = true;
  388. console.log("打开数据库失败");
  389. }
  390. }else{
  391. sqlite_combox.enabled = true;
  392. db_cfg.closeDatabase()
  393. console.log("关闭数据库");
  394. }
  395. }
  396. }
  397. }
  398. }
  399. }
  400. }
  401. }