Recent Posts

Pages: [1] 2 3 ... 10

Help for ParamQuery Pro / Re: Error when setting href link on a group total column

« Last post by paramvir on February 18, 2025, 10:58:14 pm »

you need to check code in OpenTranWindow function and use Group().option() method to set groupModel options.

https://paramquery.com/pro/api#method-Group

Help for ParamQuery Pro / Re: Error when setting href link on a group total column

« Last post by pbassey on February 18, 2025, 09:24:20 pm »

just to clarify, the error is occurring when I click on the rendered link, not when the grid is rendered...

Help for ParamQuery Pro / Re: Error when setting href link on a group total column

« Last post by paramvir on February 18, 2025, 02:40:44 pm »

Apparently column render looks fine in your code and I don't see any reason why it would raise that error.

Could you share a jsfiddle / stackblitz reproducing the error.

ParamQuery Pro Evaluation Support / Re: Preventing Row Height Transition When Applying CSS Styles to a Table

« Last post by cui on February 18, 2025, 02:22:03 pm »

I set animModel: { on: false }, but it still hasn't solved the issue.

ParamQuery Pro Evaluation Support / Preventing Row Height Transition When Applying CSS Styles to a Table

« Last post by cui on February 18, 2025, 07:31:15 am »

Hi,

I am writing to seek advice on an issue I have encountered while using the CSS deep attribute to modify the style of a table. Upon applying the new styles, I noticed that there is a visible transition or change in the row height, which is not desirable for my project.

Code: [Select]

<style scoped>
#grid_json4 {
  height: calc(100vh - 150px);
}

:deep(.pq-grid-row > td.pq-grid-number-cell) {
  text-align: center;
}
:deep(.pq-grid-number-col) {
  text-align: center;
}

:global(.pq-grid),
:global(.pq-grid *) {
  transition: none !important;
}

:global(.pq-theme .pq-grid-footer) {
  display: flex;
  justify-content: space-around;
  margin-top: 5px;
}

:global(.pq-loading) {
  display: none !important;
}

:global(.pq-icon-col-sort) {
  margin-right: 0px;
  margin-left: 0px;
}

:global(#grid_json4) {
  border-radius: 5px;
}

:global(#grid_json4 .pq-cont-lt, .pq-cont-tr),
:global(#grid_json4 .pq-theme .ui-widget-header),
:global(#grid_json4 .pq-grid-cell, .pq-grid-row),
:global(#grid_json4 .pq-body-outer .pq-cont-left) {
  border-color: #ebeef5;
}

:global(#grid_json4 .pq-td-border-top > .pq-grid-row > .pq-grid-cell:not(.pq-focus)),
:global(#grid_json4 .pq-cont-inner > .pq-td-border-top > .pq-grid-row) {
  border-bottom-color: #ebeef5;
}

:global(#grid_json4 .pq-grid-row > .pq-grid-number-cell) {
  border-color: #ebeef5;
}

:global(#grid_json4 .pq-grid-cell > div) {
  height: 100%;
  padding: 15px 5px;
  color: #606266;
}

:global(#grid_json4 .pq-grid-row > .pq-grid-cell) {
  border-top: 0;
  border-bottom: 1px solid transparent;
  border-left: 1px solid transparent;
  border-left: 0px;
}

/* :global(#grid_json4 .pq-grid-title-row .pq-td-div),
:global(#grid_json4 .pq-grid-header-search-row .pq-td-div) {
  padding: 11px 5px;
} */

:global(#grid_json4 .pq-grid-header-search-row .pq-td-div input) {
  height: 30px;
}

:global(#grid_json4 .pq-title-span) {
  font-weight: 600;
  line-height: 30px;
  color: rgb(144, 147, 153);
}

:global(#grid_json4 .ui-button) {
  height: 32px;
  margin: 0 10px 10px 0;
  color: #fff;
  background: #4e88f3;
  border-color: #4e88f3;
  border-radius: 5px;
}

:global(#grid_json4 .pq-toolbar select) {
  height: 32px;
  margin: 0 10px 10px 0;
  color: #fff;
  background: #4e88f3;
  border-color: #4e88f3;
  border-radius: 5px;
}

:global(#grid_json4 .pq-body-outer .pq-grid-number-cell),
:global(#grid_json4 .pq-summary-outer .pq-grid-number-cell) {
  display: flex;
  align-items: center;
  justify-content: center;
}

:global(#grid_json4 .pq-summary-outer) {
  height: 1px;
  border-top: 0px solid transparent;
}

:global(#grid_json4 .pq-no-wrap > .pq-grid-row > .pq-grid-cell),
:global(#grid_json4 .pq-no-wrap > .pq-grid-row > .pq-grid-col > .pq-td-div) {
  text-align: center;
}

/* :global(.ui-button .ui-icon) {
  background-image: url('./download.svg');
} */

:global(.ui-icon.downloadIcon) {
  background: url('./download.png');
}

/* :global(.pq-toolbar .ui-button:last-of-type) {
  pointer-events: none;
} */

:global(.pq-toolbar) {
  padding: 10px 10px 0;
}

:global(#grid_json4 .pq-grid-bottom select),
:global(#grid_json4 .pq-page-current) {
  height: 30px;
}

:global(#grid_json4 .pq-grid-bottom select),
:global(#grid_json4 .pq-page-current),
:global(#grid_json4 div.pq-pager, div.pq-grid-summary) {
  color: #606266;
}

Is there a way to ensure that the CSS styles are fully applied before the table is displayed on the page, thereby preventing this shift in row height from being noticeable? I would appreciate any suggestions or solutions you might have regarding this matter.

Thank you very much for your assistance.

Best regards,

cui

Help for ParamQuery Pro / Error when setting href link on a group total column

« Last post by pbassey on February 17, 2025, 10:11:48 pm »

I have the following column model definition:

colModel: [
{ dataIndx: 'KeyRec', title: 'KeyRec', hidden: true, editable: false },
{ dataIndx: 'ActivityYear', title: 'ActivityYear', hidden: true, editable: false },

{ dataIndx: 'grp', title: 'ActivityId', tpHide: true, editable: false, menuInHide: true, minWidth: 150 },
{ dataIndx: "ActivityId", title: "FAS Activity", editable: false, hidden: true, filter: { groupIndx: 'Region' } },
{ dataIndx: "Project", title: 'Project Code', valign: "top", editable: false, valign: "top", minWidth: 110 },
{ dataIndx: "Source", title: 'Source', valign: "top", editable: false, valign: "top", minWidth: 70 },
{ dataIndx: "ProjBud", title: 'Project Budget', valign: "top", format: '$ #,###,###.00', editable: false, summary: { type: "sum" }, valign: "top", align: "right", minWidth: 100 },

{
dataIndx: "YTD_Tot", title: 'YTD Through @lastMonthName', halign: "center", valign: "top", format: '$ #,###,###.00',
editable: false, summary: { type: "sum" }, valign: "top", align: "right", minWidth: 100,
//render: function (ui) {
// var ActivityID = ui.rowData.ActivityId;
// return "<a href='#' onClick=javascript:OpenTranWindow(" + "'" + ActivityID + "'" + ");>" + ui.cellData + "</a>";
//}
},
{
title: "Projection Months", align: "center", collapsible: { last: true, on: false },
colModel: [

 @foreach (var month in months)
 {
 @: { dataIndx: "@month.DataIndx", title: '@month.Title', editor: { type: 'textbox', attr: 'maxlength="12"' }, valign: "top", format: '$ #,###,###.00', editable: true, summary: { type: "sum" }, valign: "top", align: "right", minWidth: 90 },
 }

{ dataIndx: "RegTotal", title: 'Total Projections', halign: "center", valign: "top", format: '$ #,###,###.00', editable: false, summary: { type: "sum" }, valign: "top", align: "right", minWidth: 100 },
]
},
{ dataIndx: "RegBudget", title: 'Total Projections Spent', halign: "center", valign: "top", format: '$ #,###,###.00', editable: false, summary: { type: "sum" }, valign: "top", align: "right", minWidth: 90 },
{ dataIndx: "curMonAct", title: 'February Actual', halign: "center", valign: "top", format: '$ #,###,###.00', editable: false, summary: { type: "sum" }, valign: "top", align: "right", minWidth: 90 },
],

When I remove the comments on the YTD_Tot col and click on the link, I get the message:
Uncaught use Group().option() method to set groupModel options.

Can you tell me how the "Render" function could be coded?

Help for ParamQuery Pro / Re: How to remove column dragging from history

« Last post by MichalV on February 17, 2025, 09:56:35 pm »

It works well! Many thanks for your help!

Help for ParamQuery Pro / Re: How to remove column dragging from history

« Last post by paramvir on February 17, 2025, 07:12:50 pm »

Please check the corrected example:

https://paramquery.com/pro/demos/editing_batch

Help for ParamQuery Pro / Re: Filter 'Equal' Condition Not Working as Expected in v10.1.0 for datetime columns

« Last post by paramvir on February 17, 2025, 06:37:56 pm »

"yyyy-mm-ddThh:mm" and "yyyy-mm-dd" are parsed differently hence the requirement to add timezone offset manually so as to make them comparable. offset is not to be used when both filter value and column values are in same format. While it may work with/without offset for some timezones, the offered solution is for all timezones.

It's a temporary workaround and might be fixed in upcoming version so that above 2 formats are parsed in same way before passing as arguments to filter compare callback.

Help for ParamQuery Pro / Re: How to remove column dragging from history

« Last post by MichalV on February 17, 2025, 03:00:01 pm »

Thanks for your reply. Any workaround how to activate the Save button (in batch edit mode) just if the grid is really dirty?
I've tried history event with isDirty(), but it runs before the grid gets dirty.

Pages: [1] 2 3 ... 10