Messages

1

Help for ParamQuery Pro / Re: summary data

« on: June 08, 2022, 08:14:00 am »

I would be grateful if you could answer the above questions.

2

Help for ParamQuery Pro / Re: summary data

« on: June 03, 2022, 11:12:40 am »

Hi paramvir

By applying the solution you gave me as follows, I am grateful for the program I want.
I have a few additional issues that need to be addressed, so I'd appreciate it if you could let me know.

1. If the data is not saved when the user selects one from the Year-Month List,
    after asking 'Do you want to save the data?',
    if the answer is 'Yes', go through the same procedure as when clicking the 'Save' button,
    and then I want to display the data corresponding to the item on the screen.
    However, when I apply the following, an error occurs. What is the problem?

2. If the user selects the '◀ Previous' button, the user selects an item before the current in the LIST to search the DB
   for the corresponding data and display it on the screen.
   I want to know how to get the entire data of the LIST and the Index of the selected item.

Code: [Select]

{ // 14-2)
type: 'select',
cls: 'list_year_month',
label: '<b>Year-Month: ', options: [{ '2022-02': '2022-02', '2022-03': '2022-03', '2022-04': '2022-04', '2022-05': '2022-05' }],
listeners: function (evt) {
if(this.toolbar().find("button.changes").is(":enabled") == true){
if(confirm("After data is entered or modified, it is not saved in the DB.\nDo you want to save data?")){
saveChanges();
save_memo();
save_column_state();
}
}

this.option("dataModel.postDataOnce", {
mt_product: $(evt.target).val(),
cd_wc: "W120"
});
this.refreshDataAndView(); //this sends the above post data and reloads the response in the grid
}
},
{ // 14-3)
type: 'button',
label: '<b>◀ Previous',
listener: function (evt) {
//alert(this.toolbar().find("select.list_year_month").val());


}
},
{ // 13-3)
type: 'button',
label: '<b>Next ▶',
listener: function (evt) {
//alert(this.toolbar().find("select.list_year_month").val());


}
},
{ type: 'separator' },
{ // 15)
type: 'button',
icon: 'ui-icon-disk',
label: 'Save',
cls: 'changes',
listeners: [saveChanges,
save_memo,
save_column_state],
options: { disabled: true },
},

3

Help for ParamQuery Pro / Re: summary data

« on: June 02, 2022, 08:48:00 am »

Hi paramvir

I'm sorry I didn't seem to convey exactly what I wanted.
What I want is to know how to check whether the Save button is in Enable or Disable state
when the user selects one from the YEAR-MONTH List.

I would really appreciate it if you could let me how.

4

Help for ParamQuery Pro / Re: summary data

« on: May 26, 2022, 02:21:59 pm »

Hi paramvir

I'm really grateful to you for applying what you said and getting the results I want.

An additional matter to be resolved is that if the user selects a different Year-Month
from the one displayed in the Year-Month LIST in the state where the cell data is modified,
a warning message stating that 'Data is not saved!!' appears.
After doing so, we want to skip the part that searches the DB data and displays it on the screen.

I would really appreciate it if you could let me how to solve this.

Code: [Select]

{ // 13-2)
type: 'select',
label: '<b>Year-Month: ', options: [{ '2022-05': '2022-05', '2022-04': '2022-04' }],
listener: function (evt) {

this.option("dataModel.postDataOnce", {
mt_product: $(evt.target).val(),
cd_wc: "W120"
});
this.refreshDataAndView(); //this sends the above post data and reloads the response in the grid
}
},

5

Help for ParamQuery Pro / Re: summary data

« on: May 25, 2022, 06:09:24 am »

Hi paramvir

The key point of what I want is how to look up the corresponding data in DB and display it on the screen if I choose one from the Year-Month List.
That is, it is how the dataModel portion from the source below is transferred to the year-month selected by call.
I'd really appreciate it if you could let me the solution.

Code: [Select]

{ // 13-2)
type: 'select',
label: '<b>Year-Month: ',options: [{ '2022-02': '2022-02', '2022-03': '2022-03', '2022-04': '2022-04', '2022-05': '2022-05' }],
listener: function (evt) {
// $(evt.target).val()


}
},

(Skip the middle)

dataModel: {
dataType: 'JSON',
location: 'remote',
recIndx: 'id',
url: "pp2_product_plan_save.php?mt_product=2022-05&cd_wc=W120",

getData: function (response){
debugger;
response.data.forEach(function (rd) {
// comment data
if (rd.pq_cellattr) rd.pq_cellattr = JSON.parse(rd.pq_cellattr);
if (rd.pq_cellstyle) rd.pq_cellstyle = JSON.parse(rd.pq_cellstyle);


if (rd.cd_kind < 4) { // stock data
Object.defineProperty(rd, 'total_this_month1', {
get (){
//return tot_this_month;
var rd = this, total = 0;
for(var i=1;i<=31;i++){
total += rd['qty' + i];
}
return total;
}
})
Object.defineProperty(rd, 'total_this_month2', {
get (){
//return tot_this_month;
var rd = this, total = 0;
for(var i=1;i<=31;i++){
total += rd['qty' + i];
}
return total;
}
})
}
else if(rd.cd_kind == 4){ // stock data

Object.defineProperty(rd, 'qty1', {
enumerable: true, get() {
var rd = this, ri = rd.pq_ri, pdata = grid.pageData(),
pre_month_stock = rd['total_pre_month'],
day = (pdata && pdata[ri - 4]) ? pdata[ri - 4].qty1 : 0,
night = (pdata && pdata[ri - 3]) ? pdata[ri - 3].qty1 : 0,
shipment = (pdata && pdata[ri - 2]) ? pdata[ri - 2].qty1 : 0,
etc = (pdata && pdata[ri - 1]) ? pdata[ri - 1].qty1 : 0;

return pre_month_stock + day + night - shipment - etc;
}
});

for(var i=2; i<=31; i++){

(function(qty, i){
Object.defineProperty(rd, qty, {
enumerable: true, get() {
var rd = this, ri = rd.pq_ri, pdata = grid.pageData(),
pre_day_stock = (pdata && pdata[ri]) ? pdata[ri]['qty'+(i-1)] : 0,
day = (pdata && pdata[ri - 4]) ? pdata[ri - 4][qty] : 0,
night = (pdata && pdata[ri - 3]) ? pdata[ri - 3][qty] : 0,
shipment = (pdata && pdata[ri - 2]) ? pdata[ri - 2][qty] : 0,
etc = (pdata && pdata[ri - 1]) ? pdata[ri - 1][qty] : 0;

return stock_this_month = pre_day_stock + day + night - shipment - etc;
}
});
})('qty'+i, i)
}

Object.defineProperty(rd, 'total_this_month1', {
get (){
var stock_this_month = rd['qty31'];
return stock_this_month;
}
})
Object.defineProperty(rd, 'total_this_month2', {
get (){
var stock_this_month = rd['qty31'];
return stock_this_month;
}
})
}
})

this.option('summaryData', calculateSummary(this));
return response;
}
},

(The following is omitted)

6

Help for ParamQuery Pro / Re: summary data

« on: May 19, 2022, 11:37:02 am »

Hi paramvir

Thank you so much for your active help and for solving the problem I've been struggling with.
If you live close to me, I want to buy you delicious food.
Thank you so much.

But for me, there are a few issues that need to be addressed:

1) As shown in the attached image, if one is selected from the Year-Month List,
   the data registered in the DB corresponding to the selected Year-Month is retrieved and displayed on the screen.

2) When the user presses the Previous or Next button,
   the data registered in the DB corresponding to the Previous or Next button of Year-Month currently selected
   from the list in front of the button is retrieved and displayed on the screen.

3) If the user enters daily data or comment data into the cell
   and selects another Year-Month in the list or presses the Previous or Next button without saving data (when the Save button is activated)
   after displaying the warning message, subsequent steps should be ignored.

I've been thinking about it, but unfortunately I can't find a solution.
I would really appreciate it if you could let me how to solve it.

7

Help for ParamQuery Pro / Re: summary data

« on: May 17, 2022, 07:19:15 am »

Hi paramvir

I've shared the code you requested on jsfiddle, so please review it.

https://jsfiddle.net/elcid1/bz3atjgx/

The problem with my code is that when the user accesses the screen,
data is not displayed at (A) and (B) as in the attached image.
However, if the user enters daily data, the data is displayed normally.

I would really appreciate it if you could let me how to solve it.

8

Help for ParamQuery Pro / Re: summary data

« on: May 14, 2022, 07:23:50 am »

Hi paramvir

The index of the 5/1 (Sun) column is qty1.

When a user inputs daily data into Day, Night, Shipment, Etc Cell by adding this.option('summaryData', calculateSummary(this)); in change: function(),
it is calculated according to the value of cd_wcop and data is displayed in Row cells of Total Stock (Non VC) and Total Stock (VC) confirmed to be.

Code: [Select]

var obj = {
title: '<b>Production Schedule</b>',
menuUI: { singleFilter: true },
filterModel: { on: true, header: true, type: 'local' },
height: 900,
freezeCols: 14,
collapsible: {on: false},
hwrap: true,
trackModel: { on: true },

render: function(){
grid = this;
},

change: function(){
this.option('summaryData', calculateSummary(this));
//grid = this;
this.refresh();
},
hideCols: function (){
var $tb = this.toolbar();
$('button.changes', $tb).button('option', { disabled: false });
},
load: function(){
this.option('summaryData', calculateSummary(this));
},
dataReady: function(){
this.option('summaryData', calculateSummary(this));
},

< omitted below >
}
However, the problem is that when a user accesses the screen for the first time and display DB data,
Total Production and Total Shipment data are displayed on the screen,
but Total Stock (Non VC) and Total Stock (VC) data are not displayed, only 0 is displayed.

In the case of stock data of each Product Name(CC-1, AA-1, BB-1 in the image attached above) as shown in the source below,
it is calculated and displayed for each cell as in pre_month_stock + day + night - shipment - etc.
It is thought that the data is not displayed in the Summary part in the current source code state.

I would really appreciate it if you could let me how to solve it.

Code: [Select]

dataModel: {
dataType: 'JSON',
location: 'remote',
recIndx: 'id',
url: "product_plan_save.php",
getData: function (response){
debugger;
response.data.forEach(function(rd){
if(rd.cd_kind == 4){
var tot_this_month = 0;
Object.defineProperty(rd, 'qty1', {
enumerable: true, get(){
var rd = this, ri = rd.pq_ri, pdata = grid.pageData(),
pre_month_stock = rd['total_pre_month'],
day = (pdata && pdata[ri-4])? pdata[ri-4].qty1: 0,
night = (pdata && pdata[ri-3])? pdata[ri-3].qty1: 0,
shipment = (pdata && pdata[ri-2])? pdata[ri-2].qty1: 0,
etc = (pdata && pdata[ri-1])? pdata[ri-1].qty1: 0;
return pre_month_stock + day + night - shipment - etc;
}
}),

Object.defineProperty(rd, 'qty2', {
enumerable: true, get(){
var rd = this, ri = rd.pq_ri, pdata = grid.pageData(),
pre_day_stock = (pdata && pdata[ri])? pdata[ri].qty1: 0,
day = (pdata && pdata[ri-4])? pdata[ri-4].qty2: 0,
night = (pdata && pdata[ri-3])? pdata[ri-3].qty2: 0,
shipment = (pdata && pdata[ri-2])? pdata[ri-2].qty2: 0,
etc = (pdata && pdata[ri-1])? pdata[ri-1].qty2: 0;
tot_this_month = pre_day_stock + day + night - shipment - etc;
return tot_this_month;
}
}),

< Intermediate omitted >

Object.defineProperty(rd, 'total_this_month1', {
get (){
return tot_this_month;
}
}),
Object.defineProperty(rd, 'total_this_month2', {
get (){
return tot_this_month;
}
})
}
})
return response;
}
},

9

Help for ParamQuery Pro / Re: summary data

« on: May 12, 2022, 02:59:03 pm »

Hi paramvir.

What I want is that daily stock data is added and displayed in Row of Total Stock (Non VC)
when cd_wcop is not P165, and displayed in Row of Total Stock (VC) when cd_wcop is P165.
Results should be displayed as in the attached image.

It seems that there is nothing wrong with the calculation formula,
so I would really appreciate it if you could let me the solution.

10

Help for ParamQuery Pro / Re: summary data

« on: May 11, 2022, 01:17:58 pm »

Hi paramvir

As a result of applying to the program as you commented,
there is a problem that the data of 'Total Production' and 'Total Shipment' are displayed,
but the data of 'Total Stock(Non VC)' and 'Total Stock(VC)' are not displayed.

I would really appreciate it if you could tell me how to solve it.

Code: [Select]

function calculateSummary(grid){

var sum_product_qty = Array.from({length: 42}, () => 0);
var sum_shipment_qty = Array.from({length: 42}, () => 0);
var sum_stock_vc_qty = Array.from({length: 42}, () => 0);
var sum_stock_qty = Array.from({length: 42}, () => 0);

var data = grid.option("dataModel.data");
var CM = grid.option("colModel");
var cd_wcop = CM[2].dataIndx;
var cd_kind = CM[15].dataIndx; // cd_kind (Day(0), Night(1), Shipment(2), Etc(3), Stock(4))

for(var i = 0; i < data.length; i++){
var row = data[i];
var cd_wcop9 = data[i][cd_wcop];
var cd_kind9 = data[i][cd_kind];

if(cd_kind9 < 2){
sum_product_qty[40] += (row['total_pre_month'] * 1);
sum_product_qty[41] += (row['total_this_month1'] * 1);

sum_product_qty[1]  += (row['qty1'] * 1);
sum_product_qty[2]  += (row['qty2'] * 1);
sum_product_qty[3]  += (row['qty3'] * 1);
sum_product_qty[4]  += (row['qty4'] * 1);
sum_product_qty[5]  += (row['qty5'] * 1);
sum_product_qty[6]  += (row['qty6'] * 1);
sum_product_qty[7]  += (row['qty7'] * 1);
sum_product_qty[8]  += (row['qty8'] * 1);
sum_product_qty[9]  += (row['qty9'] * 1);
sum_product_qty[10] += (row['qty10'] * 1);
sum_product_qty[11] += (row['qty11'] * 1);
sum_product_qty[12] += (row['qty12'] * 1);
sum_product_qty[13] += (row['qty13'] * 1);
sum_product_qty[14] += (row['qty14'] * 1);
sum_product_qty[15] += (row['qty15'] * 1);
sum_product_qty[16] += (row['qty16'] * 1);
sum_product_qty[17] += (row['qty17'] * 1);
sum_product_qty[18] += (row['qty18'] * 1);
sum_product_qty[19] += (row['qty19'] * 1);
sum_product_qty[20] += (row['qty20'] * 1);
sum_product_qty[21] += (row['qty21'] * 1);
sum_product_qty[22] += (row['qty22'] * 1);
sum_product_qty[23] += (row['qty23'] * 1);
sum_product_qty[24] += (row['qty24'] * 1);
sum_product_qty[25] += (row['qty25'] * 1);
sum_product_qty[26] += (row['qty26'] * 1);
sum_product_qty[27] += (row['qty27'] * 1);
sum_product_qty[28] += (row['qty28'] * 1);
sum_product_qty[29] += (row['qty29'] * 1);
sum_product_qty[30] += (row['qty30'] * 1);
sum_product_qty[31] += (row['qty31'] * 1);
}
else if(cd_kind9 == 2){
sum_shipment_qty[40] += (row['total_pre_month'] * 1);
sum_shipment_qty[41] += (row['total_this_month1'] * 1);

sum_shipment_qty[1]  += (row['qty1'] * 1);
sum_shipment_qty[2]  += (row['qty2'] * 1);
sum_shipment_qty[3]  += (row['qty3'] * 1);
sum_shipment_qty[4]  += (row['qty4'] * 1);
sum_shipment_qty[5]  += (row['qty5'] * 1);
sum_shipment_qty[6]  += (row['qty6'] * 1);
sum_shipment_qty[7]  += (row['qty7'] * 1);
sum_shipment_qty[8]  += (row['qty8'] * 1);
sum_shipment_qty[9]  += (row['qty9'] * 1);
sum_shipment_qty[10] += (row['qty10'] * 1);
sum_shipment_qty[11] += (row['qty11'] * 1);
sum_shipment_qty[12] += (row['qty12'] * 1);
sum_shipment_qty[13] += (row['qty13'] * 1);
sum_shipment_qty[14] += (row['qty14'] * 1);
sum_shipment_qty[15] += (row['qty15'] * 1);
sum_shipment_qty[16] += (row['qty16'] * 1);
sum_shipment_qty[17] += (row['qty17'] * 1);
sum_shipment_qty[18] += (row['qty18'] * 1);
sum_shipment_qty[19] += (row['qty19'] * 1);
sum_shipment_qty[20] += (row['qty20'] * 1);
sum_shipment_qty[21] += (row['qty21'] * 1);
sum_shipment_qty[22] += (row['qty22'] * 1);
sum_shipment_qty[23] += (row['qty23'] * 1);
sum_shipment_qty[24] += (row['qty24'] * 1);
sum_shipment_qty[25] += (row['qty25'] * 1);
sum_shipment_qty[26] += (row['qty26'] * 1);
sum_shipment_qty[27] += (row['qty27'] * 1);
sum_shipment_qty[28] += (row['qty28'] * 1);
sum_shipment_qty[29] += (row['qty29'] * 1);
sum_shipment_qty[30] += (row['qty30'] * 1);
sum_shipment_qty[31] += (row['qty31'] * 1);
}
else if(cd_kind9 == 4){
if(cd_wcop9  == "P165"){
sum_stock_vc_qty[40] += (row['total_pre_month'] * 1);
sum_stock_vc_qty[41] += (row['total_this_month1'] * 1);

sum_stock_vc_qty[1]  += (row['qty1'] * 1);
sum_stock_vc_qty[2]  += (row['qty2'] * 1);
sum_stock_vc_qty[3]  += (row['qty3'] * 1);
sum_stock_vc_qty[4]  += (row['qty4'] * 1);
sum_stock_vc_qty[5]  += (row['qty5'] * 1);
sum_stock_vc_qty[6]  += (row['qty6'] * 1);
sum_stock_vc_qty[7]  += (row['qty7'] * 1);
sum_stock_vc_qty[8]  += (row['qty8'] * 1);
sum_stock_vc_qty[9]  += (row['qty9'] * 1);
sum_stock_vc_qty[10] += (row['qty10'] * 1);
sum_stock_vc_qty[11] += (row['qty11'] * 1);
sum_stock_vc_qty[12] += (row['qty12'] * 1);
sum_stock_vc_qty[13] += (row['qty13'] * 1);
sum_stock_vc_qty[14] += (row['qty14'] * 1);
sum_stock_vc_qty[15] += (row['qty15'] * 1);
sum_stock_vc_qty[16] += (row['qty16'] * 1);
sum_stock_vc_qty[17] += (row['qty17'] * 1);
sum_stock_vc_qty[18] += (row['qty18'] * 1);
sum_stock_vc_qty[19] += (row['qty19'] * 1);
sum_stock_vc_qty[20] += (row['qty20'] * 1);
sum_stock_vc_qty[21] += (row['qty21'] * 1);
sum_stock_vc_qty[22] += (row['qty22'] * 1);
sum_stock_vc_qty[23] += (row['qty23'] * 1);
sum_stock_vc_qty[24] += (row['qty24'] * 1);
sum_stock_vc_qty[25] += (row['qty25'] * 1);
sum_stock_vc_qty[26] += (row['qty26'] * 1);
sum_stock_vc_qty[27] += (row['qty27'] * 1);
sum_stock_vc_qty[28] += (row['qty28'] * 1);
sum_stock_vc_qty[29] += (row['qty29'] * 1);
sum_stock_vc_qty[30] += (row['qty30'] * 1);
sum_stock_vc_qty[31] += (row['qty31'] * 1);
}
else{
sum_stock_qty[40] += (row['total_pre_month'] * 1);
sum_stock_qty[41] += (row['total_this_month1'] * 1);

sum_stock_qty[1]  += (row['qty1'] * 1);
sum_stock_qty[2]  += (row['qty2'] * 1);
sum_stock_qty[3]  += (row['qty3'] * 1);
sum_stock_qty[4]  += (row['qty4'] * 1);
sum_stock_qty[5]  += (row['qty5'] * 1);
sum_stock_qty[6]  += (row['qty6'] * 1);
sum_stock_qty[7]  += (row['qty7'] * 1);
sum_stock_qty[8]  += (row['qty8'] * 1);
sum_stock_qty[9]  += (row['qty9'] * 1);
sum_stock_qty[10] += (row['qty10'] * 1);
sum_stock_qty[11] += (row['qty11'] * 1);
sum_stock_qty[12] += (row['qty12'] * 1);
sum_stock_qty[13] += (row['qty13'] * 1);
sum_stock_qty[14] += (row['qty14'] * 1);
sum_stock_qty[15] += (row['qty15'] * 1);
sum_stock_qty[16] += (row['qty16'] * 1);
sum_stock_qty[17] += (row['qty17'] * 1);
sum_stock_qty[18] += (row['qty18'] * 1);
sum_stock_qty[19] += (row['qty19'] * 1);
sum_stock_qty[20] += (row['qty20'] * 1);
sum_stock_qty[21] += (row['qty21'] * 1);
sum_stock_qty[22] += (row['qty22'] * 1);
sum_stock_qty[23] += (row['qty23'] * 1);
sum_stock_qty[24] += (row['qty24'] * 1);
sum_stock_qty[25] += (row['qty25'] * 1);
sum_stock_qty[26] += (row['qty26'] * 1);
sum_stock_qty[27] += (row['qty27'] * 1);
sum_stock_qty[28] += (row['qty28'] * 1);
sum_stock_qty[29] += (row['qty29'] * 1);
sum_stock_qty[30] += (row['qty30'] * 1);
sum_stock_qty[31] += (row['qty31'] * 1);
}
}
}

var sum_product_data = {
info_item: "Total Production", total_pre_month: sum_product_qty[40],  total_this_month1: sum_product_qty[41],
qty1:  sum_product_qty[1],  qty2:  sum_product_qty[2],  qty3:  sum_product_qty[3],  qty4:  sum_product_qty[4],    qty5:  sum_product_qty[5],
qty6:  sum_product_qty[6],  qty7:  sum_product_qty[7],  qty8:  sum_product_qty[8],  qty9:  sum_product_qty[9],    qty10: sum_product_qty[10],
qty11: sum_product_qty[11], qty12: sum_product_qty[12], qty13: sum_product_qty[13], qty14: sum_product_qty[14], qty15: sum_product_qty[15],
qty16: sum_product_qty[16], qty17: sum_product_qty[17], qty18: sum_product_qty[18], qty19: sum_product_qty[19], qty20: sum_product_qty[20],
qty21: sum_product_qty[21], qty22: sum_product_qty[22], qty23: sum_product_qty[23], qty24: sum_product_qty[24], qty25: sum_product_qty[25],
qty26: sum_product_qty[26], qty27: sum_product_qty[27], qty28: sum_product_qty[28], qty29: sum_product_qty[29], qty30: sum_product_qty[30],
qty31: sum_product_qty[31]
};
var sum_shipment_data = {
info_item: "Total Shipment", total_pre_month: sum_shipment_qty[40],  total_this_month1: sum_shipment_qty[41],
qty1:  sum_shipment_qty[1],  qty2:  sum_shipment_qty[2],  qty3:  sum_shipment_qty[3],  qty4:  sum_shipment_qty[4], qty5:  sum_shipment_qty[5],
qty6:  sum_shipment_qty[6],  qty7:  sum_shipment_qty[7],  qty8:  sum_shipment_qty[8],  qty9:  sum_shipment_qty[9], qty10: sum_shipment_qty[10],
qty11: sum_shipment_qty[11], qty12: sum_shipment_qty[12], qty13: sum_shipment_qty[13], qty14: sum_shipment_qty[14], qty15: sum_shipment_qty[15],
qty16: sum_shipment_qty[16], qty17: sum_shipment_qty[17], qty18: sum_shipment_qty[18], qty19: sum_shipment_qty[19], qty20: sum_shipment_qty[20],
qty21: sum_shipment_qty[21], qty22: sum_shipment_qty[22], qty23: sum_shipment_qty[23], qty24: sum_shipment_qty[24], qty25: sum_shipment_qty[25],
qty26: sum_shipment_qty[26], qty27: sum_shipment_qty[27], qty28: sum_shipment_qty[28], qty29: sum_shipment_qty[29], qty30: sum_shipment_qty[30],
qty31: sum_shipment_qty[31]
};
var sum_stock_data = {
info_item: "Total Stock(Non VC)", total_pre_month: sum_stock_qty[40],  total_this_month1: sum_stock_qty[41],
qty1:  sum_stock_qty[1],  qty2:  sum_stock_qty[2],  qty3:  sum_stock_qty[3],  qty4:  sum_stock_qty[4], qty5:  sum_stock_qty[5],
qty6:  sum_stock_qty[6],  qty7:  sum_stock_qty[7],  qty8:  sum_stock_qty[8],  qty9:  sum_stock_qty[9], qty10: sum_stock_qty[10],
qty11: sum_stock_qty[11], qty12: sum_stock_qty[12], qty13: sum_stock_qty[13], qty14: sum_stock_qty[14], qty15: sum_stock_qty[15],
qty16: sum_stock_qty[16], qty17: sum_stock_qty[17], qty18: sum_stock_qty[18], qty19: sum_stock_qty[19], qty20: sum_stock_qty[20],
qty21: sum_stock_qty[21], qty22: sum_stock_qty[22], qty23: sum_stock_qty[23], qty24: sum_stock_qty[24], qty25: sum_stock_qty[25],
qty26: sum_stock_qty[26], qty27: sum_stock_qty[27], qty28: sum_stock_qty[28], qty29: sum_stock_qty[29], qty30: sum_stock_qty[30],
qty31: sum_stock_qty[31]
};
var sum_stock_vc_data = {
info_item: "Total Stock(VC)", total_pre_month: sum_stock_vc_qty[40],  total_this_month1: sum_stock_vc_qty[41],
qty1:  sum_stock_vc_qty[1],  qty2:  sum_stock_vc_qty[2],  qty3:  sum_stock_vc_qty[3],  qty4:  sum_stock_vc_qty[4], qty5:  sum_stock_vc_qty[5],
qty6:  sum_stock_vc_qty[6],  qty7:  sum_stock_vc_qty[7],  qty8:  sum_stock_vc_qty[8],  qty9:  sum_stock_vc_qty[9], qty10: sum_stock_vc_qty[10],
qty11: sum_stock_vc_qty[11], qty12: sum_stock_vc_qty[12], qty13: sum_stock_vc_qty[13], qty14: sum_stock_vc_qty[14], qty15: sum_stock_vc_qty[15],
qty16: sum_stock_vc_qty[16], qty17: sum_stock_vc_qty[17], qty18: sum_stock_vc_qty[18], qty19: sum_stock_vc_qty[19], qty20: sum_stock_vc_qty[20],
qty21: sum_stock_vc_qty[21], qty22: sum_stock_vc_qty[22], qty23: sum_stock_vc_qty[23], qty24: sum_stock_vc_qty[24], qty25: sum_stock_vc_qty[25],
qty26: sum_stock_vc_qty[26], qty27: sum_stock_vc_qty[27], qty28: sum_stock_vc_qty[28], qty29: sum_stock_vc_qty[29], qty30: sum_stock_vc_qty[30],
qty31: sum_stock_vc_qty[31]
};
return [sum_product_data, sum_shipment_data, sum_stock_data, sum_stock_vc_data];
};

11

Help for ParamQuery Pro / Re: summary data

« on: May 04, 2022, 06:07:20 am »

Hi paramvir

Unfortunately, I do not understand what you were referring to.
I would appreciate it if you could give me a more specific solution.

12

Help for ParamQuery Pro / Re: summary data

« on: May 03, 2022, 08:40:43 am »

Hi paramvir

When I registered the question above,
I tried to register by attaching the image attached below,
but an error occurred and I couldn't attach it.

To register the source in the jsfiddle you requested,
there are parts that need to be modified and the operating environment is different,
such as displaying local data on the screen.

So, I am attaching an image as below, so please refer to it and let me know how to solve it.

13

Help for ParamQuery Pro / summary data

« on: May 02, 2022, 10:15:47 am »

Hi paramvir

I succeeded by applying what you let me know.
Thank you very much.

Let me ask you one more question.
I want to display the summary data calculated by calculating the sum of daily data corresponding to each condition at the bottom of the screen.
I made it like the attached source, but no data is displayed on the screen.
After inquiring DB data or entering daily production data, I want to display summary data by calculating each.

I'd appreciate it if you could let me know what the problem is.

function calculateSummary(grid, refresh){
   var sum_product_qty1  = 0, sum_product_qty2  = 0, sum_product_qty3  = 0;
   var sum_shipment_qty1 = 0, sum_shipment_qty2 = 0, sum_shipment_qty3 = 0;
   var sum_stock_vc_qty1 = 0, sum_stock_vc_qty2 = 0, sum_stock_vc_qty3 = 0;
   var sum_stock_qty1    = 0, sum_stock_qty2    = 0, sum_stock_qty3    = 0;

   var data   = grid.option("dataModel.data");
   var CM   = grid.option("colModel");
   var cd_wcop      = CM[2].dataIndx;
   var cd_kind      = CM[15].dataIndx;   // cd_kind (Day(0), Night(1), Shipment(2), Etc(3), Stock(4))

   for(var i = 0; i < data.length; i++){
      var row         = data;
      var cd_wcop9   = data[cd_wcop];
      var cd_kind9   = data[cd_kind];

      if(cd_kind9 < 2){
         sum_product_qty1 += (row[18] * 1); // May 1st data
         sum_product_qty2 += (row[19] * 1); // May 2nd data
         sum_product_qty3 += (row[20] * 1); // May 3rd data
         // omit the rest
      }
      else if(cd_kind9 == 2){
         sum_shipment_qty1 += (row[18] * 1); // May 1st data
         sum_shipment_qty2 += (row[19] * 1); // May 2nd data
         sum_shipment_qty3 += (row[20] * 1); // May 3rd data
         // omit the rest
      }
      else if(cd_kind9 == 4){
         if(cd_wcop9  == "P165"){
            sum_stock_vc_qty1 += (row[18] * 1); // May 1st data
            sum_stock_vc_qty2 += (row[19] * 1); // May 2nd data
            sum_stock_vc_qty3 += (row[20] * 1); // May 3rd data
            // omit the rest
         }
         else{
            sum_stock_qty1 += (row[18] * 1); // May 1st data
            sum_stock_qty2 += (row[19] * 1); // May 2nd data
            sum_stock_qty3 += (row[20] * 1); // May 3rd data
            // omit the rest
         }
      }
   }

   var sum_product_data      = ["<b>Total Production: </b>",      "", sum_product_qty1,   sum_product_qty2,      sum_product_qty3];
   var sum_shipment_data   = ["<b>Total Shipment: </b>",         "", sum_shipment_qty1,   sum_shipment_qty2,   sum_shipment_qty3];
   var sum_stock_data      = ["<b>Total Stock(Non VC): </b>",   "", sum_stock_qty1,      sum_stock_qty2,      sum_stock_qty3];
   var sum_stock_vc_data   = ["<b>Total Stock(VC): </b>",      "", sum_stock_vc_qty1,   sum_stock_vc_qty2,   sum_stock_vc_qty3];

   return [sum_product_data, sum_shipment_data, sum_stock_data, sum_stock_vc_data];
};

var obj = {
   // some omitted
   load: function(){
      this.option('summaryData', calculateSummary(this));
   },
   dataReady: function(){
      this.option('summaryData', calculateSummary(this));
   },
   summaryData: function () {
      calculateSummary(this);
   }
   // omit the rest
};

14

Help for ParamQuery Pro / Re: compute cell values

« on: April 29, 2022, 06:28:35 am »

Hi paramvir

As a result of applying the method you gave,
there is a problem that the Save button does not change to enable
when checking a column for the first time in the Column List or unchecking it for the first time.
After the second time, the Save button is changed to enable.

Code: [Select]

hideCols: function (){
var $tb = this.toolbar;
$('button.changes', $tb).button('option', { disabled: false });
},

I'd appreciate it if you could let me know what the problem is.

15

Help for ParamQuery Pro / Re: compute cell values

« on: April 28, 2022, 11:26:42 am »

Hi paramvir

I would appreciate it if you could let me how to set the hideCols event to make enable the Save button.
I've tried several methods, but with no success, I'm asking you again.