WTableDyn

Description:

Props

Name Type Default value Required? Description
pathItems Array ['詳見原始碼'] No 輸入w-aggrid-vue-dyn組件js檔案位置字串陣列,預設詳見原始碼處props->pathItems->default
enableInfor Boolean true No 輸入是否使用資訊區(資料名稱name與資料描述description)布林值,預設為true
name String '' No 輸入資料名稱字串,預設''
description String '' No 輸入資料描述字串,預設''
inforPaddingStyle Object {v:0,h:0} No 輸入資訊區(資料名稱name與資料描述description)內寬距離物件,可用鍵值為v、h、left、right、top、bottom,v代表同時設定top與bottom,h代表設定left與right,若有重複設定時後面鍵值會覆蓋前面,各鍵值為寬度數字,單位為px,預設{v:0,h:0}
enableMenu Boolean true No 輸入是否使用選單按鈕區布林值,預設為true
menuPaddingStyle Object {v:3,h:3} No 輸入選單按鈕區內寬距離物件,可用鍵值為v、h、left、right、top、bottom,v代表同時設定top與bottom,h代表設定left與right,若有重複設定時後面鍵值會覆蓋前面,各鍵值為寬度數字,單位為px,預設{v:3,h:3}
menuBackgroundColor String 'transparent' No 輸入選單按鈕區背景顏色字串,預設'transparent'
sortColIds String|Array '' No 輸入初始化時自動排序數據的欄位,為字串或陣列,若輸入陣列時則依照順序排序,故最末者代表最終排序。預設''
hideIds String|Array '' No 輸入欲隱藏欄位字串或陣列,可被opt.kpHeadHide複寫,預設''
fixIds String|Array '' No 輸入欲固定於左側欄位字串或陣列,可被opt.kpHeadFixLeft複寫,預設''
checkId String '' No 輸入欲使用核選方塊欄位字串,可被opt.kpHeadCheckBox複寫,預設''
removeIdsWhenDownload String|Array '' No 輸入下載Excel檔案時欲移除的欄位字串或陣列,預設''
funGetLtdtHookWhenDownload Boolean null No 輸入下載Excel檔案時針對ltdt數據階段的攔截處理函數,預設為null
funGetMatHookWhenDownload Boolean null No 輸入下載Excel檔案時針對mat數據階段的攔截處理函數,預設為null
enableHeadWhenDownload Boolean false No 輸入下載Excel檔案時是否將欄位鍵值轉換成head布林值,此需提供opt.kpHead物件,預設為false
fileNameWhenDownload String 'data.xlsx' No 輸入下載Excel檔案時儲存檔名稱字串,預設'data.xlsx'
sheetNameWhenDownload String 'data' No 輸入下載Excel檔案時sheet名稱字串,預設'data'
editable Boolean false No 輸入是否可編輯布林值,可被opt.defCellEditable複寫,預設為false
textLabelDataName String 'Data name No 輸入數據名稱字串,預設'Data name'
textPlaceholderDataName String 'Please enter data name' No 輸入數據名稱placeholder字串,預設'Please enter data name'
textLabelDataDescription String 'Data description' No 輸入數據說明字串,預設'Data description'
textPlaceholderDataDescription String 'Please enter data description' No 輸入數據說明placeholder字串,預設'Please enter data description'
tooltipAddRow String 'add new row' No 輸入新增數據按鈕tooltip字串,預設'add new row'
tooltipDeleteSelectedRows String 'delete selected rows' No 輸入刪除選擇數據按鈕tooltip字串,預設'delete selected rows'
tooltipDownloadExcelFile String 'download data to Excel file' No 輸入下載數據成為Excel檔案按鈕tooltip字串,預設'download data to Excel file'
tooltipDownloadExcelFileForDisplay String 'download filtered data to Excel file' No 輸入下載過濾後數據成為Excel檔案按鈕tooltip字串,預設'download filtered data to Excel file'
tooltipUploadExcelFile String 'upload data to Excel file' No 輸入上傳Excel數據檔案按鈕tooltip字串,預設'upload data to Excel file'
successMsgFromAddRow String 'add row successfully' No 輸入新增數據成功事件訊息字串,預設'add row successfully'
errorMsgFromAddRow String 'can not add row' No 輸入無法新增數據事件訊息字串,預設'can not add row'
errorMsgFromRemoveRow String 'can not remove selected rows' No 輸入移除數據失敗事件訊息字串,預設'can not remove selected rows'
successMsgFromUploadData String 'upload data successfully' No 輸入上傳數據成功事件訊息字串,預設'upload data successfully'
errorMsgFromUploadData String 'can not upload data' No 輸入無法上傳數據事件訊息字串,預設'can not upload data'
errorMsgFromUploadEmptyData String 'no effective data' No 輸入上傳檔案中無有效數據事件訊息字串,預設'no effective data'
successMsgFromDownloadData String 'download data successfully' No 輸入下載檔案成功事件訊息字串,預設'download data successfully'
errorMsgFromDownloadData String 'can not download data' No 輸入無法下載檔案事件訊息字串,預設'can not download data'
errorMsgFromNoName String 'no data name' No 輸入未輸入數據名稱事件訊息字串,預設'no data name'
errorMsgFromNoData String 'no data' No 輸入未給予有效數據事件訊息字串,預設'no data'
uploadModeTitle String 'Choose mode of upload:' No 輸入選擇上傳模式彈窗標題字串,預設'Choose mode of upload:'
uploadModeTextForReplace String 'Replace' No 輸入取代上傳模式文字字串,預設'Replace'
uploadModeTextForAppend String 'Append' No 輸入插入於最後上傳模式文字字串,預設'Append'
opt Object {} No 輸入w-aggrid-vue設定物件,預設{}
opt.keys Array - Yes 輸入資料各欄位keys
opt.rows Array - Yes 輸入資料列,各列為物件,內含各欄位keys之值,例[{},{},...,{}]
opt.kpHead Object {} No 輸入key對應head物件,預設各key值為本身key值
opt.kpHeadTooltip Object {} No 輸入key對應需tooltip的html字串物件,於各head處滑鼠移入時觸發,預設各key值為undefined
opt.defHeadAlighH String 'center' No 輸入head預設之左右對齊字串,預設為'center'
opt.kpHeadAlighH Object {} No 輸入key對應head之左右對齊字串物件,預設各key值為defHeadAlighH
opt.defHeadSort Boolean true No 輸入head預設之是否允許排序布林值,預設為true
opt.kpHeadSort Object {} No 輸入key對應head之是否允許排序物件,預設各key值為defHeadSort
opt.defHeadSortMethod function|String null No 輸入head預設之排序方式函數或字串,若需自行定義則給予函數,若需使用內建的自動轉型判斷方式則給予'auto'字串,預設為null
opt.kpHeadSortMethod Object {} No 輸入key對應head之排序方式函數或字串,若需自行定義則給予函數,若需使用內建的自動轉型判斷方式則給予'auto'字串,預設各key值為defHeadSortMethod
opt.kpHeadFixLeft Object {} No 輸入key對應head之是否固定於左側物件,預設各key值為false
opt.defHeadFilter Boolean true No 輸入head預設之是否允許過濾布林值,預設為true
opt.kpHeadFilter Object {} No 輸入key對應head之是否允許過濾物件,預設各key值為defHeadFilter
opt.defHeadDrag Boolean true No 輸入head預設之是否允許拖曳布林值,預設為true
opt.kpHeadDrag Object {} No 輸入key對應head之是否允許拖曳物件,預設各key值為defHeadDrag
opt.kpHeadCheckBox Object {} No 輸入key對應head與key的各列是否使用核選方塊物件,預設各key值為false
opt.kpHeadHide Object {} No 輸入key對應head是否隱藏物件,預設各key值為false
opt.kpRowStyle Object {} No 輸入key對應row style之物件,可設定各key欄之函數,函數給予cell值需回傳之row style,預設各key值為undefined
opt.kpRowDrag Object {} No 輸入key對應col之是否能拖曳排序物件,預設各key值為false
opt.kpColStyle Object {} No 輸入key對應row style之物件,可設定各key欄之col style,預設各key值為undefined
opt.defHeadMinWidth Number null No 輸入cell預設最小寬度數字,預設為null
opt.kpHeadWidth Object {} No 輸入key對應cell之寬度物件,預設各key值為undefined
opt.kpCellRender Object {} No 輸入key對應cell之渲染函數物件,預設各key值為undefined
opt.kpCellTooltip Object {} No 輸入key對應cell之tooltip的html字串物件,於各cell處滑鼠移入時觸發,預設各key值為undefined
opt.defCellAlighH String 'center' No 輸入cell預設之左右對齊字串,預設為'center'
opt.kpCellAlighH Object {} No 輸入key對應cell之左右對齊字串物件,預設各key值為defCellAlighH
opt.defCellEditable Boolean false No 輸入cell預設之是否可編輯布林值,預設為false
opt.kpCellEditable Object {} No 輸入key對應cell之是否可編輯物件,預設各key值為defCellEditable
opt.kpConvertKeysWhenUploadData Object {} No 輸入上傳Excel檔案時,當key轉會成對應新key值物件,預設{}
opt.rowClick function function(){} No 輸入row click之觸發事件,預設為function(){}
opt.rowDbClick function function(){} No 輸入row double click之觸發事件,預設為function(){}
opt.rowChange function function(){} No 輸入row change之觸發事件,預設為function(){}
opt.rowChecked function function(){} No 輸入row checked之觸發事件,需使用kpHeadCheckBox開啟指定key的head與對應rows使用checkbox,預設為function(){}
opt.rowMouseEnter function function(){} No 輸入row mouseenter之觸發事件,預設為function(){}
opt.rowMouseLeave function function(){} No 輸入row mouseleave之觸發事件,預設為function(){}
opt.cellClick function function(){} No 輸入cell click之觸發事件,預設為function(){}
opt.cellDbClick function function(){} No 輸入cell double click之觸發事件,預設為function(){}
opt.cellChange function function(){} No 輸入cell change之觸發事件,預設為function(){}
opt.cellMouseEnter function function(){} No 輸入cell mouseenter之觸發事件,預設為function(){}
opt.cellMouseLeave function function(){} No 輸入cell mouseleave之觸發事件,預設為function(){}
opt.filterChange function ()=>{} No 輸入filter change之觸發事件,預設為()=>{}
opt.autoFitColumn Boolean false No 輸入當表格尺寸變更時自動調整欄寬布林值,預設false
opt.language String 'en' No 輸入指定語系字串,可選'en'、'zh-tw'、'zh-cn',預設為'en'
opt.optForUploadData Object {} No 輸入呼叫組件uploadData上傳檔案時用的設定物件,物件可給予鍵值:pathItems代表調用wsemi的getDataFromExcelFileU8ArrDyn所傳入的xlsx的來源網址陣列,beforeUpload代表上傳前的處理數據函數,parseSheetInd代表提取Excel檔案的第幾個sheet整數(預設為0),optForUploadData預設{}
opt.modifyDataWhenSave function - No 輸入當儲存時修改儲存數據事件,輸入rows,輸出rows,預設為undefined
opt.checkNoDataWhenSave Boolean false No 輸入當儲存時是否檢核無數據布林值,預設false

Events

Name Payload Type Description
save Array 指調用組件的method,無輸入,會回傳當前的name、description、rows所構成的物件

Props

Name Type Default value Required? Description
pathItems Array ['詳見原始碼'] No 輸入w-aggrid-vue-dyn組件js檔案位置字串陣列,預設詳見原始碼處props->pathItems->default
enableInfor Boolean true No 輸入是否使用資訊區(資料名稱name與資料描述description)布林值,預設為true
name String '' No 輸入資料名稱字串,預設''
description String '' No 輸入資料描述字串,預設''
inforPaddingStyle Object {v:0,h:0} No 輸入資訊區(資料名稱name與資料描述description)內寬距離物件,可用鍵值為v、h、left、right、top、bottom,v代表同時設定top與bottom,h代表設定left與right,若有重複設定時後面鍵值會覆蓋前面,各鍵值為寬度數字,單位為px,預設{v:0,h:0}
enableMenu Boolean true No 輸入是否使用選單按鈕區布林值,預設為true
menuPaddingStyle Object {v:3,h:3} No 輸入選單按鈕區內寬距離物件,可用鍵值為v、h、left、right、top、bottom,v代表同時設定top與bottom,h代表設定left與right,若有重複設定時後面鍵值會覆蓋前面,各鍵值為寬度數字,單位為px,預設{v:3,h:3}
menuBackgroundColor String 'transparent' No 輸入選單按鈕區背景顏色字串,預設'transparent'
sortColIds String|Array '' No 輸入初始化時自動排序數據的欄位,為字串或陣列,若輸入陣列時則依照順序排序,故最末者代表最終排序。預設''
hideIds String|Array '' No 輸入欲隱藏欄位字串或陣列,可被opt.kpHeadHide複寫,預設''
fixIds String|Array '' No 輸入欲固定於左側欄位字串或陣列,可被opt.kpHeadFixLeft複寫,預設''
checkId String '' No 輸入欲使用核選方塊欄位字串,可被opt.kpHeadCheckBox複寫,預設''
removeIdsWhenDownload String|Array '' No 輸入下載Excel檔案時欲移除的欄位字串或陣列,預設''
funGetLtdtHookWhenDownload Boolean null No 輸入下載Excel檔案時針對ltdt數據階段的攔截處理函數,預設為null
funGetMatHookWhenDownload Boolean null No 輸入下載Excel檔案時針對mat數據階段的攔截處理函數,預設為null
enableHeadWhenDownload Boolean false No 輸入下載Excel檔案時是否將欄位鍵值轉換成head布林值,此需提供opt.kpHead物件,預設為false
fileNameWhenDownload String 'data.xlsx' No 輸入下載Excel檔案時儲存檔名稱字串,預設'data.xlsx'
sheetNameWhenDownload String 'data' No 輸入下載Excel檔案時sheet名稱字串,預設'data'
editable Boolean false No 輸入是否可編輯布林值,可被opt.defCellEditable複寫,預設為false
textLabelDataName String 'Data name No 輸入數據名稱字串,預設'Data name'
textPlaceholderDataName String 'Please enter data name' No 輸入數據名稱placeholder字串,預設'Please enter data name'
textLabelDataDescription String 'Data description' No 輸入數據說明字串,預設'Data description'
textPlaceholderDataDescription String 'Please enter data description' No 輸入數據說明placeholder字串,預設'Please enter data description'
tooltipAddRow String 'add new row' No 輸入新增數據按鈕tooltip字串,預設'add new row'
tooltipDeleteSelectedRows String 'delete selected rows' No 輸入刪除選擇數據按鈕tooltip字串,預設'delete selected rows'
tooltipDownloadExcelFile String 'download data to Excel file' No 輸入下載數據成為Excel檔案按鈕tooltip字串,預設'download data to Excel file'
tooltipDownloadExcelFileForDisplay String 'download filtered data to Excel file' No 輸入下載過濾後數據成為Excel檔案按鈕tooltip字串,預設'download filtered data to Excel file'
tooltipUploadExcelFile String 'upload data to Excel file' No 輸入上傳Excel數據檔案按鈕tooltip字串,預設'upload data to Excel file'
successMsgFromAddRow String 'add row successfully' No 輸入新增數據成功事件訊息字串,預設'add row successfully'
errorMsgFromAddRow String 'can not add row' No 輸入無法新增數據事件訊息字串,預設'can not add row'
errorMsgFromRemoveRow String 'can not remove selected rows' No 輸入移除數據失敗事件訊息字串,預設'can not remove selected rows'
successMsgFromUploadData String 'upload data successfully' No 輸入上傳數據成功事件訊息字串,預設'upload data successfully'
errorMsgFromUploadData String 'can not upload data' No 輸入無法上傳數據事件訊息字串,預設'can not upload data'
errorMsgFromUploadEmptyData String 'no effective data' No 輸入上傳檔案中無有效數據事件訊息字串,預設'no effective data'
successMsgFromDownloadData String 'download data successfully' No 輸入下載檔案成功事件訊息字串,預設'download data successfully'
errorMsgFromDownloadData String 'can not download data' No 輸入無法下載檔案事件訊息字串,預設'can not download data'
errorMsgFromNoName String 'no data name' No 輸入未輸入數據名稱事件訊息字串,預設'no data name'
errorMsgFromNoData String 'no data' No 輸入未給予有效數據事件訊息字串,預設'no data'
uploadModeTitle String 'Choose mode of upload:' No 輸入選擇上傳模式彈窗標題字串,預設'Choose mode of upload:'
uploadModeTextForReplace String 'Replace' No 輸入取代上傳模式文字字串,預設'Replace'
uploadModeTextForAppend String 'Append' No 輸入插入於最後上傳模式文字字串,預設'Append'
opt Object {} No 輸入w-aggrid-vue設定物件,預設{}
opt.keys Array - Yes 輸入資料各欄位keys
opt.rows Array - Yes 輸入資料列,各列為物件,內含各欄位keys之值,例[{},{},...,{}]
opt.kpHead Object {} No 輸入key對應head物件,預設各key值為本身key值
opt.kpHeadTooltip Object {} No 輸入key對應需tooltip的html字串物件,於各head處滑鼠移入時觸發,預設各key值為undefined
opt.defHeadAlighH String 'center' No 輸入head預設之左右對齊字串,預設為'center'
opt.kpHeadAlighH Object {} No 輸入key對應head之左右對齊字串物件,預設各key值為defHeadAlighH
opt.defHeadSort Boolean true No 輸入head預設之是否允許排序布林值,預設為true
opt.kpHeadSort Object {} No 輸入key對應head之是否允許排序物件,預設各key值為defHeadSort
opt.defHeadSortMethod function|String null No 輸入head預設之排序方式函數或字串,若需自行定義則給予函數,若需使用內建的自動轉型判斷方式則給予'auto'字串,預設為null
opt.kpHeadSortMethod Object {} No 輸入key對應head之排序方式函數或字串,若需自行定義則給予函數,若需使用內建的自動轉型判斷方式則給予'auto'字串,預設各key值為defHeadSortMethod
opt.kpHeadFixLeft Object {} No 輸入key對應head之是否固定於左側物件,預設各key值為false
opt.defHeadFilter Boolean true No 輸入head預設之是否允許過濾布林值,預設為true
opt.kpHeadFilter Object {} No 輸入key對應head之是否允許過濾物件,預設各key值為defHeadFilter
opt.defHeadDrag Boolean true No 輸入head預設之是否允許拖曳布林值,預設為true
opt.kpHeadDrag Object {} No 輸入key對應head之是否允許拖曳物件,預設各key值為defHeadDrag
opt.kpHeadCheckBox Object {} No 輸入key對應head與key的各列是否使用核選方塊物件,預設各key值為false
opt.kpHeadHide Object {} No 輸入key對應head是否隱藏物件,預設各key值為false
opt.kpRowStyle Object {} No 輸入key對應row style之物件,可設定各key欄之函數,函數給予cell值需回傳之row style,預設各key值為undefined
opt.kpRowDrag Object {} No 輸入key對應col之是否能拖曳排序物件,預設各key值為false
opt.kpColStyle Object {} No 輸入key對應row style之物件,可設定各key欄之col style,預設各key值為undefined
opt.defHeadMinWidth Number null No 輸入cell預設最小寬度數字,預設為null
opt.kpHeadWidth Object {} No 輸入key對應cell之寬度物件,預設各key值為undefined
opt.kpCellRender Object {} No 輸入key對應cell之渲染函數物件,預設各key值為undefined
opt.kpCellTooltip Object {} No 輸入key對應cell之tooltip的html字串物件,於各cell處滑鼠移入時觸發,預設各key值為undefined
opt.defCellAlighH String 'center' No 輸入cell預設之左右對齊字串,預設為'center'
opt.kpCellAlighH Object {} No 輸入key對應cell之左右對齊字串物件,預設各key值為defCellAlighH
opt.defCellEditable Boolean false No 輸入cell預設之是否可編輯布林值,預設為false
opt.kpCellEditable Object {} No 輸入key對應cell之是否可編輯物件,預設各key值為defCellEditable
opt.kpConvertKeysWhenUploadData Object {} No 輸入上傳Excel檔案時,當key轉會成對應新key值物件,預設{}
opt.rowClick function function(){} No 輸入row click之觸發事件,預設為function(){}
opt.rowDbClick function function(){} No 輸入row double click之觸發事件,預設為function(){}
opt.rowChange function function(){} No 輸入row change之觸發事件,預設為function(){}
opt.rowChecked function function(){} No 輸入row checked之觸發事件,需使用kpHeadCheckBox開啟指定key的head與對應rows使用checkbox,預設為function(){}
opt.rowMouseEnter function function(){} No 輸入row mouseenter之觸發事件,預設為function(){}
opt.rowMouseLeave function function(){} No 輸入row mouseleave之觸發事件,預設為function(){}
opt.cellClick function function(){} No 輸入cell click之觸發事件,預設為function(){}
opt.cellDbClick function function(){} No 輸入cell double click之觸發事件,預設為function(){}
opt.cellChange function function(){} No 輸入cell change之觸發事件,預設為function(){}
opt.cellMouseEnter function function(){} No 輸入cell mouseenter之觸發事件,預設為function(){}
opt.cellMouseLeave function function(){} No 輸入cell mouseleave之觸發事件,預設為function(){}
opt.filterChange function ()=>{} No 輸入filter change之觸發事件,預設為()=>{}
opt.autoFitColumn Boolean false No 輸入當表格尺寸變更時自動調整欄寬布林值,預設false
opt.language String 'en' No 輸入指定語系字串,可選'en'、'zh-tw'、'zh-cn',預設為'en'
opt.optForUploadData Object {} No 輸入呼叫組件uploadData上傳檔案時用的設定物件,物件可給予鍵值:pathItems代表調用wsemi的getDataFromExcelFileU8ArrDyn所傳入的xlsx的來源網址陣列,beforeUpload代表上傳前的處理數據函數,parseSheetInd代表提取Excel檔案的第幾個sheet整數(預設為0),optForUploadData預設{}
opt.modifyDataWhenSave function - No 輸入當儲存時修改儲存數據事件,輸入rows,輸出rows,預設為undefined
opt.checkNoDataWhenSave Boolean false No 輸入當儲存時是否檢核無數據布林值,預設false

Events

Name Payload Type Description
save Array 指調用組件的method,無輸入,會回傳當前的name、description、rows所構成的物件