I have one Jquery Grid ,
binded data from DB,
the issue is i need to merge cells in column one that has the same values toegter.
Below is my code
xmlns="http://www.w3.org/1999/xhtml" >
id="Head1" runat="server">
rel="stylesheet" type="text/css" media="screen" href="http://ajax.aspnetcdn.com/ajax/jquery.ui/1.10.0/themes/excite-bike/jquery-ui.css" />
rel="stylesheet" type="text/css" media="screen" href="themes/ui.jqgrid.css" />
src="http://ajax.microsoft.com/ajax/jquery/jquery-1.9.0.min.js" type="text/javascript">
src="js/trirand/i18n/grid.locale-en.js"type="text/javascript">
src="js/trirand/jquery.jqGrid.min.js" type="text/javascript">
type="text/css">
.ui-jqgrid tr.jqgrow td{height:100px; font-size:large; font-weight:bold;}
$("#grid").closest("div.ui-jqgrid-view")
.children("div.ui-jqgrid-titlebar")
.css("text-align", "center")
.children("span.ui-jqgrid-title")
.css("float", "none");
type="text/css">
body { font-size: 75px; }
>
id="form1" runat="server">
<% $ connection string value %>"
SelectCommand="select distinct M.MINOR_NM [SVC Type],'In Warranty' WTY,
(select count(*) Total from w_job_header_usg105 a where a.job_status<'60' and a.Cost_type='W1' and Service_type in ('T1')) Total,
(select count(*) from w_job_header_usg105 A where a.job_status<'60' and a.Service_type in ('T1') and DateDiff(dd ,CONVERT(VARCHAR(10),a.RECEIPT_DT,120),getdate())<=3 and Cost_type='W1' ) '0~3 Days',
(select count(*) from w_job_header_usg105 where job_status<'60' and Service_type in ('T1') and DateDiff(dd ,CONVERT(VARCHAR(10),RECEIPT_DT,120),getdate())>3 and DateDiff(dd ,CONVERT(VARCHAR(10),RECEIPT_DT,120),getdate())<=7 and Cost_type='W1' ) '4~7 Days',
(select count(*) from w_job_header_usg105 where job_status<'60' and Service_type in ('T1') and DateDiff(dd ,CONVERT(VARCHAR(10),RECEIPT_DT,120),getdate())>7 and Cost_type='W1' ) 'Over 7 Days'
from mytabe1 J join mytabe2 M on J.Service_type=M.Minor_cd and M.Major_cd='WA003'and J.Service_type in ('T1')
Union
select distinct M.MINOR_NM [SVC Type],'Out Of Warranty' WTY,
(select count(*) Total from w_job_header_usg105 a where a.job_status<'60' and a.Cost_type in('W6','') and Service_type in ('T1')) Total,
(select count(*) from w_job_header_usg105 A where a.job_status<'60' and a.Service_type in ('T1') and DateDiff(dd ,CONVERT(VARCHAR(10),a.RECEIPT_DT,120),getdate())<=3 and Cost_type in ('W6','')) '0~3 Days',
(select count(*) from w_job_header_usg105 where job_status<'60' and Service_type in ('T1') and DateDiff(dd ,CONVERT(VARCHAR(10),RECEIPT_DT,120),getdate())>3 and DateDiff(dd ,CONVERT(VARCHAR(10),RECEIPT_DT,120),getdate())<=7 and Cost_type in ('W6','')) '4~7 Days',
(select count(*) from w_job_header_usg105 where job_status<'60' and Service_type in ('T1') and DateDiff(dd ,CONVERT(VARCHAR(10),RECEIPT_DT,120),getdate())>7 and Cost_type in ('W6','') ) 'Over 7 Days'
from W_JOB_HEADER_USG105 J join B_MINOR M on J.Service_type=M.Minor_cd and M.Major_cd='WA003'and J.Service_type in ('T1')
Union
select distinct M.MINOR_NM [SVC Type],'In Warranty' WTY,
(select count(*) Total from w_job_header_usg105 a where a.job_status<'60' and a.Cost_type='W1' and Service_type in ('T4')) Total,
(select count(*) from w_job_header_usg105 A where a.job_status<'60' and a.Service_type in ('T4') and DateDiff(dd ,CONVERT(VARCHAR(10),a.RECEIPT_DT,120),getdate())<=3 and Cost_type='W1' ) '0~3 Days',
(select count(*) from w_job_header_usg105 where job_status<'60' and Service_type in ('T4') and DateDiff(dd ,CONVERT(VARCHAR(10),RECEIPT_DT,120),getdate())>3 and DateDiff(dd ,CONVERT(VARCHAR(10),RECEIPT_DT,120),getdate())<=7 and Cost_type='W1' ) '4~7 Days',
(select count(*) from w_job_header_usg105 where job_status<'60' and Service_type in ('T4') and DateDiff(dd ,CONVERT(VARCHAR(10),RECEIPT_DT,120),getdate())>7 and Cost_type='W1' ) 'Over 7 Days'
from W_JOB_HEADER_USG105 J join B_MINOR M on J.Service_type=M.Minor_cd and M.Major_cd='WA003'and J.Service_type in ('T4')
Union
select distinct M.MINOR_NM [SVC Type],'Out Of Warranty' WTY,
(select count(*) Total from w_job_header_usg105 a where a.job_status<'60' and a.Cost_type in('W6','') and Service_type in ('T4')) Total,
(select count(*) from w_job_header_usg105 A where a.job_status<'60' and a.Service_type in ('T4') and DateDiff(dd ,CONVERT(VARCHAR(10),a.RECEIPT_DT,120),getdate())<=3 and Cost_type in ('W6','')) '0~3 Days',
(select count(*) from w_job_header_usg105 where job_status<'60' and Service_type in ('T4') and DateDiff(dd ,CONVERT(VARCHAR(10),RECEIPT_DT,120),getdate())>3 and DateDiff(dd ,CONVERT(VARCHAR(10),RECEIPT_DT,120),getdate())<=7 and Cost_type in ('W6','')) '4~7 Days',
(select count(*) from w_job_header_usg105 where job_status<'60' and Service_type in ('T4') and DateDiff(dd ,CONVERT(VARCHAR(10),RECEIPT_DT,120),getdate())>7 and Cost_type in ('W6','') ) 'Over 7 Days'
from W_JOB_HEADER_USG105 J join B_MINOR M on J.Service_type=M.Minor_cd and M.Major_cd='WA003'and J.Service_type in ('T4')
Union
select distinct M.MINOR_NM [SVC Type],'In Warranty' WTY,
(select count(*) Total from w_job_header_usg105 a where a.job_status<'60' and a.Cost_type='W1' and Service_type in ('T2')) Total,
(select count(*) from w_job_header_usg105 A where a.job_status<'60' and a.Service_type in ('T2') and DateDiff(dd ,CONVERT(VARCHAR(10),a.RECEIPT_DT,120),getdate())<=3 and Cost_type='W1' ) '0~3 Days',
(select count(*) from w_job_header_usg105 where job_status<'60' and Service_type in ('T2') and DateDiff(dd ,CONVERT(VARCHAR(10),RECEIPT_DT,120),getdate())>3 and DateDiff(dd ,CONVERT(VARCHAR(10),RECEIPT_DT,120),getdate())<=7 and Cost_type='W1' ) '4~7 Days',
(select count(*) from w_job_header_usg105 where job_status<'60' and Service_type in ('T2') and DateDiff(dd ,CONVERT(VARCHAR(10),RECEIPT_DT,120),getdate())>7 and Cost_type='W1' ) 'Over 7 Days'
from W_JOB_HEADER_USG105 J join B_MINOR M on J.Service_type=M.Minor_cd and M.Major_cd='WA003'and J.Service_type in ('T2')
Union
select distinct M.MINOR_NM [SVC Type],'Out Of Warranty' WTY,
(select count(*) Total from w_job_header_usg105 a where a.job_status<'60' and a.Cost_type in('W6','') and Service_type in ('T2')) Total,
(select count(*) from w_job_header_usg105 A where a.job_status<'60' and a.Service_type in ('T2') and DateDiff(dd ,CONVERT(VARCHAR(10),a.RECEIPT_DT,120),getdate())<=3 and Cost_type in ('W6','')) '0~3 Days',
(select count(*) from w_job_header_usg105 where job_status<'60' and Service_type in ('T2') and DateDiff(dd ,CONVERT(VARCHAR(10),RECEIPT_DT,120),getdate())>3 and DateDiff(dd ,CONVERT(VARCHAR(10),RECEIPT_DT,120),getdate())<=7 and Cost_type in ('W6','')) '4~7 Days',
(select count(*) from w_job_header_usg105 where job_status<'60' and Service_type in ('T2') and DateDiff(dd ,CONVERT(VARCHAR(10),RECEIPT_DT,120),getdate())>7 and Cost_type in ('W6','') ) 'Over 7 Days'
from W_JOB_HEADER_USG105 J join B_MINOR M on J.Service_type=M.Minor_cd and M.Major_cd='WA003'and J.Service_type in ('T2')">
runat="server" ID="JQGrid1" DataSourceID="SqlDataSource1"
Height="100%" KeyboardNavigation="False" Width="1310px" AutoWidth="True" onprerender="JQGrid1_PreRender"
>
Enabled="True" />
Caption="Pending Jobs Report" />
Caption="Pending Jobs" />
DataField="SVC Type" Searchable="False" Sortable="False"
TextAlign="Center" CssClass= "ui-jqgrid" />
DataField="WTY" TextAlign="Center" />
DataField="Total" TextAlign="Center" />
DataField="0~3 Days" TextAlign="Center" />
DataField="4~7 Days" TextAlign="Center">
DataField="Over 7 Days" TextAlign="Center" >
Draggable="False" />