function dashboard_rektor(){ function studentBody() { /////////////////////////STUDENT BODY//////////////////////////////////////////////// var ds_prodi = store_prodiregall(); var ds_stsmt = store_thnakademik2(); var ds_fak = store_fakultas(); function setChartSB(){ if(RH.isEmpty('cb.fak')) return; if(RH.isEmpty('cb.stsmt')) return; var kdfakultas = RH.getCompValue('cb.fak'); var kdstsemester = RH.getCompValue('cb.stsmt'); //Ext.Msg.alert("DEBUG", thmasuk + '-' + idklsmhs);return; ds_SB.reload({ params: { kdfakultas: kdfakultas, kdstsemester: kdstsemester, } }); } function setChartTBLsb(){ //if(RH.isEmpty('cb.prodi')) return; if(RH.isEmpty('cb.fak')) return; if(RH.isEmpty('cb.stsmt')) return; //var kdprodi = RH.getCompValue('cb.prodi'); var kdfakultas = RH.getCompValue('cb.fak'); var kdstsemester = RH.getCompValue('cb.stsmt'); //Ext.Msg.alert("DEBUG", thmasuk + '-' + idklsmhs);return; ds_TBLsb.reload({ params: { kdfakultas: kdfakultas, kdstsemester: kdstsemester, }, callback: function(records, operation, success) { var cuti = 0, jumlah = 0, aktif = 0, DO = 0, keluar = 0, lulus = 0, nonaktif = 0, sdd = 0; ds_TBLsb.each(function (rec) { jumlah += parseFloat(rec.get('jumlah')); cuti += parseFloat(rec.get('cuti')); aktif += parseFloat(rec.get('aktif')); DO += parseFloat(rec.get('do')); keluar += parseFloat(rec.get('keluar')); lulus += parseFloat(rec.get('lulus')); nonaktif += parseFloat(rec.get('nonaktif')); sdd += parseFloat(rec.get('sdd')); }); Ext.getCmp('jumlah2').setValue(jumlah); Ext.getCmp('cuti2').setValue(cuti); Ext.getCmp('aktif2').setValue(aktif); Ext.getCmp('do2').setValue(DO); Ext.getCmp('keluar2').setValue(keluar); Ext.getCmp('lulus2').setValue(lulus); Ext.getCmp('sdd2').setValue(sdd); Ext.getCmp('nonaktif2').setValue(nonaktif); Ext.MessageBox.hide(); } }); } var ds_SB = new Ext.data.JsonStore({ proxy: new Ext.data.HttpProxy({ url: BASE_URL + 'chart_rektor/get_chart_studentbody', method: 'POST', success: function(response){ var r = Ext.decode(response.responseText); if(r.status == false){ Ext.Ajax.request({ url: BASE_URL + 'user/ext_logout', method: 'POST', success: function(xhr) { localStorage.removeItem('access_token'); window.location = BASE_URL + 'user/login'; } }); } } }), //baseParams: { kdprodi:'' }, totalProperty: 'results', autoLoad : true, root: 'data', fields: [ { name: 'kdfakultas' } , { name: 'nmfakultas' } , { name: 'fakultas' } , { name: 'jumlah' } , { name: 'aktif' } , { name: 'cuti' } , { name: 'do' } , { name: 'keluar' } , { name: 'lulus' } , { name: 'nonaktif' } , { name: 'sdd' } ] }); var reader = new Ext.data.JsonReader({ root:'data', idProperty: '', totalProperty: 'results', remoteGroup: true, fields: [ { name: 'fakultas' } , { name: 'nourutprodi' } , { name: 'nmprodi' } , { name: 'nmjenjangstudi' } , { name: 'kdstsemester' } , { name: 'jumlah' } , { name: 'aktif' } , { name: 'cuti' } , { name: 'do' } , { name: 'keluar' } , { name: 'lulus' } , { name: 'nonaktif' } , { name: 'sdd' } ], }); var ds_TBLsb = new Ext.data.GroupingStore({ proxy: new Ext.data.HttpProxy({ url: BASE_URL + 'chart_rektor/get_chart_studentbody_tbl', method: 'POST', success: function(response){ var r = Ext.decode(response.responseText); if(r.status == false){ Ext.Ajax.request({ url: BASE_URL + 'user/ext_logout', method: 'POST', success: function(xhr) { localStorage.removeItem('access_token'); window.location = BASE_URL + 'user/login'; } }); } } }), totalProperty: 'results', autoLoad : true, root: 'data', reader: reader, groupField:'fakultas', remoteSort: true, }); /* var ds_TBLsb = new Ext.data.JsonStore({ proxy: new Ext.data.HttpProxy({ url: BASE_URL + 'chart_rektor/get_chart_studentbody_tbl', method: 'POST', }), //baseParams: { kdprodi:'' }, totalProperty: 'results', autoLoad : true, root: 'data', fields: [ { name: 'nourutprodi' } , { name: 'nmprodi' } , { name: 'nmjenjangstudi' } , { name: 'kdstsemester' } , { name: 'jumlah' } , { name: 'aktif' } , { name: 'cuti' } , { name: 'do' } , { name: 'keluar' } , { name: 'lulus' } , { name: 'nonaktif' } , { name: 'sdd' } ] }); */ //Ext.chart.Chart.CHART_URL = BASE_PATH + 'resources/js/ext/resources/charts.swf'; var chartSB = new Ext.Panel({ layout: 'fit', autoWidth:true, //width:400, height:500, title: 'Grafik Student Body', tbar: [{ //text: 'Grafik', /* handler: function(){ ds_SB.loadData(); } */ }], items: { xtype: 'columnchart', store: ds_SB, //yField: 'biaya', series: [ { yField: 'jumlah', displayName: 'Jumlah' },{ yField: 'aktif', displayName: 'Aktif' },{ yField: 'cuti', displayName: 'Cuti' },{ yField: 'do', displayName: 'DO' },{ yField: 'keluar', displayName: 'Keluar' },{ yField: 'lulus', displayName: 'Lulus' },{ yField: 'nonaktif', displayName: 'Non-Aktif' }/* ,{ yField: 'sdd', displayName: 'Sedang Double Degree' } */ ], url: '../../resources/js/ext/resources/charts.swf', xField: 'nmfakultas', xAxis: new Ext.chart.CategoryAxis({ title: 'Fakultas' }), yAxis: new Ext.chart.NumericAxis({ title: 'Jml.', //labelRenderer : Ext.util.Format.numberRenderer('0,0') }), extraStyle: { xAxis: { labelRotation: 0 } } } /* items: { xtype: 'columnchart', store: ds_SB, yField: 'jml', url: '../../resources/js/ext/resources/charts.swf', xField: 'kdstaktivitasmhs', xAxis: new Ext.chart.CategoryAxis({ title: 'Fakultas' }), yAxis: new Ext.chart.NumericAxis({ title: 'Jumlah Mahasiswa' }), extraStyle: { xAxis: { labelRotation: 0 } } } */ }); var cm_TblSb = new Ext.grid.ColumnModel({ // specify any defaults for each column defaults: { sortable: true // columns are not sortable by default }, columns: [{ header: 'Fakultas/Program Studi', width: 205, dataIndex: 'fakultas', //sortable: true }, { header: '
No.Prodi
', width: 85, dataIndex: 'nourutprodi', sortable: true, hidden: true }, { header: '
Fakultas/Program Studi
', width: 300, dataIndex: 'nmprodi', sortable: true }, { header: '
Jenjang Studi
', width: 100, dataIndex: 'nmjenjangstudi', sortable: true }, { header: '
Jumlah
', width: 85, dataIndex: 'jumlah', sortable: true }, { header: '
Aktif
', width: 85, dataIndex: 'aktif', sortable: true }, { header: '
Cuti
', width: 85, dataIndex: 'cuti', sortable: true }, { header: '
Drop Out
', width: 85, dataIndex: 'do', sortable: true }, { header: '
Keluar
', width: 85, dataIndex: 'keluar', sortable: true }, { header: '
Lulus
', width: 85, dataIndex: 'lulus', sortable: true }, { header: '
Non Aktif
', width: 85, dataIndex: 'nonaktif', sortable: true }, { header: '
Sedang Double Degree
', width: 140, dataIndex: 'sdd', sortable: true, hidden: true, }] }); var gp_TblSb = new Ext.grid.GridPanel({ id: 'gp.SbTbl', title: 'Tabel Student Body', ds: ds_TBLsb, cm: cm_TblSb, sm: new Ext.grid.RowSelectionModel({ singleSelect: true}), view: new Ext.grid.GroupingView({ forceFit:true, groupTextTpl: '{text} ({[values.rs.length]} {["Prodi"]})', enableGroupingMenu: false, // don't show a grouping menu enableNoGroups: false, // don't let the user ungroup hideGroupedColumn: true, // don't show the column that is being used to create the heading showGroupName: false, // don't show the field name with the group heading startCollapsed: false // the groups start closed/no }), //view: new Ext.grid.GridView({ emptyText: '< Belum ada Data >'}), //forceFit: true, autoHeight: true, width: 720, autoWidth:true, //width:400, height:250, frame:false, autoScroll: true, autoSizeColumns: true, enableColumnResize: true, enableColumnHide: false, enableColumnMove: false, enableHdaccess: false, columnLines: true, loadMask: true, bbar:[ { xtype: 'label', text : "Total", style: 'margin-left:23px;margin-right:390px;' },{ xtype: 'textfield', name: 'jumlah2', id: 'jumlah2', width: 88, readOnly: true },{ xtype: 'textfield', name: 'aktif2', id: 'aktif2', width: 90, readOnly: true },{ xtype: 'textfield', name: 'cuti2', id: 'cuti2', width: 90, readOnly: true },{ xtype: 'textfield', name: 'do2', id: 'do2', width: 90, readOnly: true },{ xtype: 'textfield', name: 'keluar2', id: 'keluar2', width: 90, readOnly: true },{ xtype: 'textfield', name: 'lulus2', id: 'lulus2', width: 90, readOnly: true },{ xtype: 'textfield', name: 'nonaktif2', id: 'nonaktif2', width: 90, readOnly: true },{ xtype: 'textfield', name: 'sdd2', id: 'sdd2', width: 140, readOnly: true, hidden: true } ], layout: 'anchor', }); var panel_filter_SB = new Ext.Panel({ //title: 'Grafik Student Body', id: 'fp.filter', layout: 'fit', autoWidth:true, autoHeight:true, frame:false, autoScroll: true, autoSizeColumns: true, enableColumnResize: true, enableColumnHide: false, enableColumnMove: false, enableHdaccess: false, columnLines: true, loadMask: true, defaults: { labelWidth: 200, labelAlign: 'right'}, items: [ { xtype: 'fieldset', layout:'column', autoHeight:true, margin: '0px 0px 5px', items: [ { columnWidth:.5, layout: 'form', items: [ /* { xtype: 'combo', id: 'cb.prodi', fieldLabel: 'Program Studi', store: ds_prodi, valueField: 'kdprodi', displayField: 'lnmprodi', triggerAction: 'all',editable: false, width: 250, forceSelection: true, submitValue: true, mode: 'local', emptyText:'Pilih...', listeners:{ scope: this, 'select': function(){ setChartSB(); setChartTBLsb(); } } }, */ { xtype: 'combo', id: 'cb.fak', fieldLabel: 'Fakultas', store: ds_fak, valueField: 'kdfakultas', displayField: 'nmfakultas', triggerAction: 'all',editable: false, width: 250, forceSelection: true, submitValue: true, mode: 'local', emptyText:'Pilih...', listeners:{ scope: this, 'select': function(){ setChartSB(); setChartTBLsb(); } } } ] }, { columnWidth:.5, layout: 'form', items: [ { xtype: 'combo', fieldLabel: 'Th.Akademik-Smt', id: 'cb.stsmt', store: ds_stsmt, width: 170, valueField: 'kdstsemester', displayField: 'nmthnakademik',//'nmsmt', editable: false, triggerAction: 'all', forceSelection: true, submitValue: true, mode: 'local', emptyText:'Pilih...', listeners:{ scope: this, 'select': function(){ setChartSB(); setChartTBLsb(); } } } ] } ] }, { items:[{ items: [{ columnWidth: .50, layout: 'form', border: false, items: [{ xtype: 'fieldset', layout: 'fit', //autoWidth:true, items: [gp_TblSb] }] }, { columnWidth: .50, layout: 'form', border: false, items: [{ xtype: 'fieldset', layout: 'fit', //autoWidth:true, items: [chartSB] }] }] }] } ] }); var fSB = { //new Ext.form.FormPanel({ //{ xtype: 'panel', //'container', id: 'content.absen', layout: 'form', border:false, defaults: { labelWidth: 150, labelAlign: 'right' }, items: [panel_filter_SB] }; //); return fSB; ///////////////////---------------------------------------------------////////////////////// } function DPK() { /////////////////////////DPK//////////////////////////////////////////////// var ds_years = store_tahun(); var ds_jkls = store_klsmhsplusall(); var ds_fak = store_fakultas(); function onRowDpkClick(grid, rowIdx){ var record = ds_TBLdpk.getAt(rowIdx); RH.setCompValue('c-prod.kdprodi-dpk',record.data['kdprodi']); RH.setCompValue('c-prod.nmprodi-dpk',record.data['nmprodi']); RH.setCompValue('c-prod.kdprodi-dpk-mhs',record.data['kdprodi']); RH.setCompValue('c-prod.nmprodi-dpk-mhs',record.data['nmprodi']); setChartDPKprod(); setChartDPKprodMhs(); } function setTBLdpk(){ if(RH.isEmpty('cb.thmasuk-dpk')) return; if(RH.isEmpty('cb.fak-dpk')) return; if(RH.isEmpty('cb.jkelas-dpk')) return; var thmasuk = RH.getCompValue('cb.thmasuk-dpk'); var kdfakultas = RH.getCompValue('cb.fak-dpk'); var idklsmhs = RH.getCompValue('cb.jkelas-dpk'); //Ext.Msg.alert("DEBUG", thmasuk + '-' + idklsmhs);return; ds_TBLdpk.reload({ params: { thmasuk: thmasuk, kdfakultas: kdfakultas, idklsmhs: idklsmhs, }, callback: function(results){ RH.setCompValue('tbl.to-biaya-tagihan-dpk', RH.sumRecVal(ds_TBLdpk, 'biaya')); RH.setCompValue('tbl.to-bayar-dpk', RH.sumRecVal(ds_TBLdpk, 'jmlbayar')); RH.setCompValue('tbl.to-tunggakan-dpk', RH.sumRecVal(ds_TBLdpk, 'sisa')); RH.setCompValue('tbl.to-diskon-dpk', RH.sumRecVal(ds_TBLdpk, 'diskon')); RH.setCompValue('tbl.to-sukarela-dpk', RH.sumRecVal(ds_TBLdpk, 'sukarela')); RH.setCompValue('tbl.mhs-lunas-dpk', RH.sumRecVal(ds_TBLdpk, 'jmllunas')); RH.setCompValue('tbl.mhs-blmlunas-dpk', RH.sumRecVal(ds_TBLdpk, 'jmlblmlunas')); RH.setCompValue('tbl.jml-mhs-dpk', RH.sumRecVal(ds_TBLdpk, 'jmlmhs')); } }); } function setChartDPKfak(){ if(RH.isEmpty('cb.thmasuk-dpk')) return; if(RH.isEmpty('cb.fak-dpk')) return; if(RH.isEmpty('cb.jkelas-dpk')) return; var thmasuk = RH.getCompValue('cb.thmasuk-dpk'); var kdfakultas = RH.getCompValue('cb.fak-dpk'); var idklsmhs = RH.getCompValue('cb.jkelas-dpk'); //Ext.Msg.alert("DEBUG", thmasuk + '-' + idklsmhs);return; ds_DPKfak.reload({ params: { thmasuk: thmasuk, kdfakultas: kdfakultas, idklsmhs: idklsmhs, }, callback: function(results){ RH.setCompValue('c-fak.biaya-tagihan-dpk', RH.sumRecVal(ds_DPKfak, 'biaya')); RH.setCompValue('c-fak.bayar-dpk', RH.sumRecVal(ds_DPKfak, 'jmlbayar')); RH.setCompValue('c-fak.tunggakan-dpk', RH.sumRecVal(ds_DPKfak, 'sisa')); RH.setCompValue('c-fak.diskon-dpk', RH.sumRecVal(ds_DPKfak, 'diskon')); RH.setCompValue('c-fak.sukarela-dpk', RH.sumRecVal(ds_DPKfak, 'sukarela')); RH.setCompValue('c-fak.mhs-lunas-dpk', RH.sumRecVal(ds_DPKfak, 'jmllunas')); RH.setCompValue('c-fak.mhs-blm-lunas-dpk', RH.sumRecVal(ds_DPKfak, 'jmlblmlunas')); RH.setCompValue('c-fak.mhs-dpk', RH.sumRecVal(ds_DPKfak, 'jmlmhs')); } }); } function setChartDPKprod(){ if(RH.isEmpty('cb.thmasuk-dpk')) return; if(RH.isEmpty('c-prod.kdprodi-dpk')) return; if(RH.isEmpty('cb.jkelas-dpk')) return; var thmasuk = RH.getCompValue('cb.thmasuk-dpk'); var kdprodi = RH.getCompValue('c-prod.kdprodi-dpk'); var idklsmhs = RH.getCompValue('cb.jkelas-dpk'); //Ext.Msg.alert("DEBUG", thmasuk + '-' + idklsmhs);return; ds_DPKprod.reload({ params: { thmasuk: thmasuk, kdprodi: kdprodi, idklsmhs: idklsmhs, } }); } function setChartDPKprodMhs(){ if(RH.isEmpty('cb.thmasuk-dpk')) return; if(RH.isEmpty('c-prod.kdprodi-dpk')) return; if(RH.isEmpty('cb.jkelas-dpk')) return; var thmasuk = RH.getCompValue('cb.thmasuk-dpk'); var kdprodi = RH.getCompValue('c-prod.kdprodi-dpk'); var idklsmhs = RH.getCompValue('cb.jkelas-dpk'); //Ext.Msg.alert("DEBUG", thmasuk + '-' + idklsmhs);return; ds_DPKprodMhs.reload({ params: { thmasuk: thmasuk, kdprodi: kdprodi, idklsmhs: idklsmhs, } }); } var reader = new Ext.data.JsonReader({ root:'data', idProperty: '', totalProperty: 'results', remoteGroup: true, fields: [ { name: 'kdfakultas' } , { name: 'nmfakultas' } , { name: 'fakultas' } , { name: 'kdprodi' } , { name: 'nourutprodi' } , { name: 'nmprodi' } , { name: 'lnmprodi' } , { name: 'biaya' } , { name: 'jmlbayar' } , { name: 'persenbayar' } , { name: 'sisa' } , { name: 'persensisa' } , { name: 'diskon' } , { name: 'sukarela' } , { name: 'jmlmhs' } , { name: 'jmllunas' } , { name: 'jmlblmlunas' } ], }); var ds_TBLdpk = new Ext.data.GroupingStore({ proxy: new Ext.data.HttpProxy({ url: BASE_URL + 'chart_rektor/get_chart_dpk_fak_tbl', method: 'POST', success: function(response){ var r = Ext.decode(response.responseText); if(r.status == false){ Ext.Ajax.request({ url: BASE_URL + 'user/ext_logout', method: 'POST', success: function(xhr) { localStorage.removeItem('access_token'); window.location = BASE_URL + 'user/login'; } }); } } }), totalProperty: 'results', autoLoad : true, root: 'data', reader: reader, groupField:'fakultas', remoteSort: true, }); var ds_DPKfak = new Ext.data.JsonStore({ proxy: new Ext.data.HttpProxy({ url: BASE_URL + 'chart_rektor/get_chart_dpk_fak', method: 'POST', success: function(response){ var r = Ext.decode(response.responseText); if(r.status == false){ Ext.Ajax.request({ url: BASE_URL + 'user/ext_logout', method: 'POST', success: function(xhr) { localStorage.removeItem('access_token'); window.location = BASE_URL + 'user/login'; } }); } } }), //baseParams: { kdprodi:'' }, totalProperty: 'results', autoLoad : true, root: 'data', fields: [ { name: 'nmfakultas' } , { name: 'biaya' } , { name: 'jmlbayar' } , { name: 'sisa' } , { name: 'diskon' } , { name: 'sukarela' } , { name: 'jmllunas' } , { name: 'jmlblmlunas' } , { name: 'jmlmhs' } ] }); var ds_DPKprod = new Ext.data.JsonStore({ proxy: new Ext.data.HttpProxy({ url: BASE_URL + 'chart_rektor/get_chart_dpk_prodi', method: 'POST', }), //baseParams: { kdprodi:'' }, totalProperty: 'results', autoLoad : true, root: 'data', fields: [ { name: 'item' } , { name: 'value' } ] }); var ds_DPKprodMhs = new Ext.data.JsonStore({ proxy: new Ext.data.HttpProxy({ url: BASE_URL + 'chart_rektor/get_chart_dpk_prodi_mhs', method: 'POST', success: function(response){ var r = Ext.decode(response.responseText); if(r.status == false){ Ext.Ajax.request({ url: BASE_URL + 'user/ext_logout', method: 'POST', success: function(xhr) { localStorage.removeItem('access_token'); window.location = BASE_URL + 'user/login'; } }); } } }), //baseParams: { kdprodi:'' }, totalProperty: 'results', autoLoad : true, root: 'data', fields: [ { name: 'item' } , { name: 'value' } ] }); var cm_TblDpk = new Ext.grid.ColumnModel({ columns: [{ header: 'Fakultas/Program Studi', width: 205, dataIndex: 'fakultas', //sortable: true }, { header: '
Fakultas/Program Studi
', width: 210, dataIndex: 'lnmprodi', //sortable: true }, { header: '
Biaya Tagihan
', width: 100, dataIndex: 'biaya', xtype: 'numbercolumn', format:'0,000', align:'right' }, { header: '
Bayar
', width: 100, dataIndex: 'jmlbayar', xtype: 'numbercolumn', format:'0,000', align:'right' }, { header: '
% Bayar
', width: 100, dataIndex: 'persenbayar', xtype: 'numbercolumn', format:'0.%', align:'right' }, { header: '
Tunggakan
', width: 100, dataIndex: 'sisa', xtype: 'numbercolumn', format:'0,000', align:'right' }, { header: '
% Tunggakan
', width: 100, dataIndex: 'persensisa', xtype: 'numbercolumn', format:'0.%', align:'right' }, { header: '
Diskon
', width: 100, dataIndex: 'diskon', xtype: 'numbercolumn', format:'0,000', align:'right' }, { header: '
Sukarela
', width: 100, dataIndex: 'sukarela', xtype: 'numbercolumn', format:'0,000', align:'right' },{ header: '
Jml.Mhs Lunas
', width: 100, dataIndex: 'jmllunas', sortable: true, align:'right' },{ header: '
Jml.Mhs Blm Lunas
', width: 100, dataIndex: 'jmlblmlunas', sortable: true, align:'right' },{ header: '
Jml.Mahasiswa
', width: 100, dataIndex: 'jmlmhs', sortable: true, align:'right' }] }); var chartDPKfak = new Ext.Panel({ layout: 'fit', autoWidth:true, frame:false, //autoScroll: true, autoSizeColumns: true, enableColumnResize: true, enableColumnHide: false, enableColumnMove: false, enableHdaccess: false, columnLines: true, loadMask: true, height:250, //title: 'Grafik DPK Fakultas', tbar: [{text: 'Grafik DPK Per Fakultas',},'->', {xtype: 'label', text: 'Fakultas : '}, {xtype: 'textfield',id: 'c-fak.fakultas-dpk',readOnly:true, width:265},'-', {xtype: 'label', text: 'Tahun Masuk/Angkatan : '}, {xtype: 'textfield',id: 'c-fak.thn-dpk',readOnly:true, width:80},'-', {xtype: 'label', text: 'Jenis Kelas : '}, {xtype: 'textfield',id: 'c-fak.jkls-dpk',readOnly:true}], bbar: [{xtype: 'label', text: 'Tot.Biaya Tagihan : '}, {xtype: 'numericfield', decimalSeparator: ',', decimalPrecision: 0, alwaysDisplayDecimals: true, useThousandSeparator: true, thousandSeparator: '.',id: 'c-fak.biaya-tagihan-dpk',readOnly:true, width:80},'-', {xtype: 'label', text: 'Tot.Bayar : '}, {xtype: 'numericfield', decimalSeparator: ',', decimalPrecision: 0, alwaysDisplayDecimals: true, useThousandSeparator: true, thousandSeparator: '.',id: 'c-fak.bayar-dpk',readOnly:true, width:80},'-', {xtype: 'label', text: 'Tot.Tunggakan : '}, {xtype: 'numericfield', decimalSeparator: ',', decimalPrecision: 0, alwaysDisplayDecimals: true, useThousandSeparator: true, thousandSeparator: '.',id: 'c-fak.tunggakan-dpk',readOnly:true, width:80},'-', {xtype: 'label', text: 'Tot.Diskon : '}, {xtype: 'numericfield', decimalSeparator: ',', decimalPrecision: 0, alwaysDisplayDecimals: true, useThousandSeparator: true, thousandSeparator: '.',id: 'c-fak.diskon-dpk',readOnly:true, width:80},'-', {xtype: 'label', text: 'Tot.Sukarela : '}, {xtype: 'numericfield', decimalSeparator: ',', decimalPrecision: 0, alwaysDisplayDecimals: true, useThousandSeparator: true, thousandSeparator: '.',id: 'c-fak.sukarela-dpk',readOnly:true, width:80}], items: { xtype: 'columnchart', store: ds_DPKfak, //yField: 'biaya', series: [ { yField: 'biaya', displayName: 'Tot.Biaya Tagihan' },{ yField: 'jmlbayar', displayName: 'Tot.Bayar' },{ yField: 'sisa', displayName: 'Tot.Tunggakan' },{ yField: 'diskon', displayName: 'Tot.Diskon' },{ yField: 'sukarela', displayName: 'Tot.Sukarela' } ], url: '../../resources/js/ext/resources/charts.swf', xField: 'nmfakultas', xAxis: new Ext.chart.CategoryAxis({ title: 'Fakultas' }), yAxis: new Ext.chart.NumericAxis({ title: 'Rp.', labelRenderer : Ext.util.Format.numberRenderer('0,0') }), extraStyle: { xAxis: { labelRotation: 0 } } } }); var pieChartMhsDPKfak = new Ext.Panel({ layout: 'fit', autoWidth:true, frame:false, //autoScroll: true, autoSizeColumns: true, enableColumnResize: true, enableColumnHide: false, enableColumnMove: false, enableHdaccess: false, columnLines: true, loadMask: true, height:250, //title: 'Grafik DPK Fakultas', tbar: [{text: 'Grafik Total Mahasiswa Per Fakultas',},'->', {xtype: 'label', text: 'Fakultas : '}, {xtype: 'textfield',id: 'c-fak.fakultas-dpk-mhs',readOnly:true, width:270},'-', {xtype: 'label', text: 'Tahun Masuk/Angkatan : '}, {xtype: 'textfield',id: 'c-fak.thn-dpk-mhs',readOnly:true, width:80},'-', {xtype: 'label', text: 'Jenis Kelas : '}, {xtype: 'textfield',id: 'c-fak.jkls-dpk-mhs',readOnly:true}], bbar: [{xtype: 'label', text: 'Tot.Mhs Lunas : '}, {xtype: 'textfield',id: 'c-fak.mhs-lunas-dpk',readOnly:true, width:80},'-', {xtype: 'label', text: 'Tot.Mhs Blm Lunas : '}, {xtype: 'textfield',id: 'c-fak.mhs-blm-lunas-dpk',readOnly:true, width:80},'-', {xtype: 'label', text: 'Tot.Mahasiswa : '}, {xtype: 'textfield',id: 'c-fak.mhs-dpk',readOnly:true, width:80}], items: { xtype: 'columnchart', store: ds_DPKfak, //yField: 'biaya', series: [ { yField: 'jmllunas', displayName: 'Tot.Mhs Lunas' },{ yField: 'jmlblmlunas', displayName: 'Tot.Mhs Blm Lunas' },{ yField: 'jmlmhs', displayName: 'Tot.Mahasiswa' } ], url: '../../resources/js/ext/resources/charts.swf', xField: 'nmfakultas', xAxis: new Ext.chart.CategoryAxis({ title: 'Fakultas' }), yAxis: new Ext.chart.NumericAxis({ title: 'Jml Mhs.', labelRenderer : Ext.util.Format.numberRenderer('0,0') }), extraStyle: { xAxis: { labelRotation: 0 } } } }); var chartDPKprod = new Ext.Panel({ layout: 'fit', autoWidth:true, frame:false, //autoScroll: true, autoSizeColumns: true, enableColumnResize: true, enableColumnHide: false, enableColumnMove: false, enableHdaccess: false, columnLines: true, loadMask: true, height:250, tbar: [{text: 'Grafik DPK Per Program Studi'}, {xtype: 'textfield',id: 'c-prod.kdprodi-dpk',hidden:true},'->', {xtype: 'label', text: 'Program Studi : '}, {xtype: 'textfield',id: 'c-prod.nmprodi-dpk',readOnly:true, width:270},'-', {xtype: 'label', text: 'Tahun Masuk/Angkatan : '}, {xtype: 'textfield',id: 'c-prod.smt-dpk',readOnly:true, width:80},'-', {xtype: 'label', text: 'Jenis Kelas : '}, {xtype: 'textfield',id: 'c-prod.jnskls-dpk',readOnly:true}], items: { xtype: 'columnchart', store: ds_DPKprod, categoryField: 'item', yField: 'value', url: '../../resources/js/ext/resources/charts.swf', xField: 'item', xAxis: new Ext.chart.CategoryAxis({ title: 'Keterangan' }), yAxis: new Ext.chart.NumericAxis({ title: 'Rp.', labelRenderer : Ext.util.Format.numberRenderer('0,0') }), extraStyle: { xAxis: { labelRotation: 0 } } } }); var pieChartDPKprodMhs = new Ext.Panel({ layout: 'fit', autoWidth:true, frame:false, //autoScroll: true, autoSizeColumns: true, enableColumnResize: true, enableColumnHide: false, enableColumnMove: false, enableHdaccess: false, columnLines: true, loadMask: true, height:250, tbar: [{text: 'Grafik Total Mahasiswa Per Program Studi'}, {xtype: 'textfield',id: 'c-prod.kdprodi-dpk-mhs',hidden:true},'->', {xtype: 'label', text: 'Program Studi : '}, {xtype: 'textfield',id: 'c-prod.nmprodi-dpk-mhs',readOnly:true, width:265},'-', {xtype: 'label', text: 'Tahun Masuk/Angkatan : '}, {xtype: 'textfield',id: 'c-prod.smt-dpk-mhs',readOnly:true, width:80},'-', {xtype: 'label', text: 'Jenis Kelas : '}, {xtype: 'textfield',id: 'c-prod.jnskls-dpk-mhs',readOnly:true}], items: { xtype: 'columnchart', store: ds_DPKprodMhs, categoryField: 'item', yField: 'value', url: '../../resources/js/ext/resources/charts.swf', xField: 'item', xAxis: new Ext.chart.CategoryAxis({ title: 'Keterangan' }), yAxis: new Ext.chart.NumericAxis({ title: 'Jml Mhs.', labelRenderer : Ext.util.Format.numberRenderer('0,0') }), extraStyle: { xAxis: { labelRotation: 0 } } } }); var cari_data_nya = [new Ext.ux.grid.Search({ iconCls: 'btn_search', minChars: 1, autoFocus: true, autoHeight: true, position: 'top', mode: 'local', width: 200 })]; var gp_TblDpk = new Ext.grid.GridPanel({ id: 'gp.DpkTbl', title: 'Tabel DPK Fakultas/ Program Studi', plugins: cari_data_nya, ds: ds_TBLdpk, cm: cm_TblDpk, sm: new Ext.grid.RowSelectionModel({ singleSelect: true}), tbar: [{},'->'], view: new Ext.grid.GroupingView({ forceFit:true, groupTextTpl: '{text} ({[values.rs.length]} {["Prodi"]})', enableGroupingMenu: false, // don't show a grouping menu enableNoGroups: false, // don't let the user ungroup hideGroupedColumn: true, // don't show the column that is being used to create the heading showGroupName: false, // don't show the field name with the group heading startCollapsed: false // the groups start closed/no }), autoWidth:true, clicksToEdit: 1, //for cell editing (single click =1, dblclick=2) forceFit: true, //autoHeight: true, autoScroll: true, autoSizeColumns: true, enableColumnResize: true, enableColumnHide: false, enableColumnMove: false, enableHdaccess: false, columnLines: true, loadMask: true, layout: 'anchor', bbar: [ { xtype: 'label', text : "Tot.Biaya Tagihan :", },{ xtype: 'numericfield', //fieldLabel: 'Tot.Biaya Tagihan', id:'tbl.to-biaya-tagihan-dpk', readOnly: true, width:90, decimalSeparator: ',', decimalPrecision: 0, alwaysDisplayDecimals: true, useThousandSeparator: true, thousandSeparator: '.', },'-', { xtype: 'label', text : "Tot.Bayar :", },{ xtype: 'numericfield', //fieldLabel: 'Tot.Bayar', id:'tbl.to-bayar-dpk', readOnly: true, width:90, decimalSeparator: ',', decimalPrecision: 0, alwaysDisplayDecimals: true, useThousandSeparator: true, thousandSeparator: '.', },'-', { xtype: 'label', text : "Tot.Tunggakan :", },{ xtype: 'numericfield', //fieldLabel: 'Tot.Tunggakan', id:'tbl.to-tunggakan-dpk', readOnly: true, width:90, decimalSeparator: ',', decimalPrecision: 0, alwaysDisplayDecimals: true, useThousandSeparator: true, thousandSeparator: '.', },'-', { xtype: 'label', text : "Tot.Diskon :", },{ xtype: 'numericfield', //fieldLabel: 'Tot.Diskon', id:'tbl.to-diskon-dpk', readOnly: true, width:90, decimalSeparator: ',', decimalPrecision: 0, alwaysDisplayDecimals: true, useThousandSeparator: true, thousandSeparator: '.', },'-', { xtype: 'label', text : "Tot.Sukarela :", },{ xtype: 'numericfield', //fieldLabel: 'Tot.Sukarela', id:'tbl.to-sukarela-dpk', readOnly: true, width:90, decimalSeparator: ',', decimalPrecision: 0, alwaysDisplayDecimals: true, useThousandSeparator: true, thousandSeparator: '.', },'-', { xtype: 'label', text : "Tot.Mhs Lunas :", },{ xtype: 'textfield', //fieldLabel: 'Tot.Mhs Lunas', id:'tbl.mhs-lunas-dpk', readOnly: true, width:50, },'-', { xtype: 'label', text : "Tot.Mhs Blm Lunas :", },{ xtype: 'textfield', //fieldLabel: 'Tot.Mhs Blm Lunas', id:'tbl.mhs-blmlunas-dpk', readOnly: true, width:50, },'-', { xtype: 'label', text : "Tot.Mahasiswa :", },{ xtype: 'textfield', //fieldLabel: 'Tot.Mahasiswa', id:'tbl.jml-mhs-dpk', readOnly: true, width:50, } ], listeners: { rowclick: onRowDpkClick } }); var panel_filter_DPK = new Ext.Panel({ id: 'fp.RptDPK', title:'Laporan Keuangan DPK', layout: 'anchor', forceFit: true, maskDisabled: false, monitorValid: true, autoScroll: true, //width:500, height:400, margin: '0 0 10', frame: true, xtype: 'form', defaults: { labelWidth: 115, labelAlign: 'right'}, items: [ { xtype: 'fieldset', flex: 1, region:'north', layout:'column', autoHeight:true, items: [ { columnWidth:.3, layout: 'form', items: [ { xtype: 'combo', id: 'cb.fak-dpk', fieldLabel: 'Fakultas', store: ds_fak, valueField: 'kdfakultas', displayField: 'nmfakultas', triggerAction: 'all',editable: false, width: 205, forceSelection: true, submitValue: true, mode: 'local', emptyText:'Pilih...', listeners:{ scope: this, 'select': function(){ setChartDPKfak(); setTBLdpk(); setChartDPKprod(); Ext.getCmp('c-fak.fakultas-dpk').setValue(Ext.getCmp('cb.fak-dpk').getRawValue()); Ext.getCmp('c-fak.fakultas-dpk-mhs').setValue(Ext.getCmp('cb.fak-dpk').getRawValue());} } } ] }, { columnWidth:.3, layout: 'form', items: [ { xtype: 'combo', id: 'cb.thmasuk-dpk', fieldLabel: 'Th.Msk/Angkatan', store: ds_years, triggerAction: 'all', width: 100, valueField: 'tahun', displayField: 'tahun', forceSelection: true, submitValue: true, mode: 'local', emptyText:'Pilih...', //selectOnFocus:true, listeners:{ scope: this, 'select': function(){ setChartDPKfak(); setTBLdpk(); setChartDPKprod(); Ext.getCmp('c-fak.thn-dpk').setValue(Ext.getCmp('cb.thmasuk-dpk').getRawValue()); Ext.getCmp('c-fak.thn-dpk-mhs').setValue(Ext.getCmp('cb.thmasuk-dpk').getRawValue()); Ext.getCmp('c-prod.smt-dpk').setValue(Ext.getCmp('cb.thmasuk-dpk').getRawValue()); Ext.getCmp('c-prod.smt-dpk-mhs').setValue(Ext.getCmp('cb.thmasuk-dpk').getRawValue());} } } ] }, { columnWidth:.3, layout: 'form', items: [ { xtype: 'combo', id: 'cb.jkelas-dpk', fieldLabel: 'Jenis Kelas', store: ds_jkls, valueField: 'idklsmhs', displayField: 'kdnm', triggerAction: 'all',editable: false, forceSelection: true, submitValue: true, mode: 'local', emptyText:'Pilih...', //selectOnFocus:true, listeners:{ scope: this, 'select': function(){ setChartDPKfak(); setTBLdpk(); setChartDPKprod(); Ext.getCmp('c-fak.jkls-dpk').setValue(Ext.getCmp('cb.jkelas-dpk').getRawValue()); Ext.getCmp('c-fak.jkls-dpk-mhs').setValue(Ext.getCmp('cb.jkelas-dpk').getRawValue()); Ext.getCmp('c-prod.jnskls-dpk').setValue(Ext.getCmp('cb.jkelas-dpk').getRawValue()); Ext.getCmp('c-prod.jnskls-dpk-mhs').setValue(Ext.getCmp('cb.jkelas-dpk').getRawValue());} } } ] } ] }, { xtype: 'panel', layout:'fit', id:'fp.dpk-fakultas', frame:true, height: 435, items:[gp_TblDpk] }, { items:[chartDPKfak,pieChartMhsDPKfak,RH.vSpacer(50), chartDPKprod,pieChartDPKprodMhs] } ] }); var fDPK = { //new Ext.form.FormPanel({ //{ xtype: 'panel', //'container', id: 'content.dpk', layout: 'form', border:false, autoScroll: true, defaults: { labelWidth: 150, labelAlign: 'right' }, items: [panel_filter_DPK] }; //); return fDPK; ///////////////////---------------------------------------------------////////////////////// } function DPP() { /////////////////////////DPP//////////////////////////////////////////////// var ds_stsmt_dpp = store_thnakademik2(); var ds_jkls = store_klsmhsplusall(); var ds_fak = store_fakultas(); function onRowDppClick(grid, rowIdx){ var record = ds_TBLdpp.getAt(rowIdx); RH.setCompValue('c-prod.kdprodi-dpp',record.data['kdprodi']); RH.setCompValue('c-prod.nmprodi-dpp',record.data['nmprodi']); RH.setCompValue('c-prod.kdprodi-dpp-mhs',record.data['kdprodi']); RH.setCompValue('c-prod.nmprodi-dpp-mhs',record.data['nmprodi']); setChartDPPprod(); setChartDPPprodMhs(); } function setTBLdpp(){ if(RH.isEmpty('c-fak.stsmt-dpp')) return; if(RH.isEmpty('c-fak.fak-dpp')) return; if(RH.isEmpty('c-fak.jkelas-dpp')) return; var kdstsemester = RH.getCompValue('c-fak.stsmt-dpp'); var kdfakultas = RH.getCompValue('c-fak.fak-dpp'); var idklsmhs = RH.getCompValue('c-fak.jkelas-dpp'); //Ext.Msg.alert("DEBUG", thmasuk + '-' + idklsmhs);return; ds_TBLdpp.reload({ params: { kdstsemester: kdstsemester, kdfakultas: kdfakultas, idklsmhs: idklsmhs, }, callback: function(results){ RH.setCompValue('tbl.to-biaya-tagihan-dpp', RH.sumRecVal(ds_TBLdpp, 'biaya')); RH.setCompValue('tbl.to-bayar-dpp', RH.sumRecVal(ds_TBLdpp, 'jmlbayar')); RH.setCompValue('tbl.to-tunggakan-dpp', RH.sumRecVal(ds_TBLdpp, 'sisa')); RH.setCompValue('tbl.to-diskon-dpp', RH.sumRecVal(ds_TBLdpp, 'diskon')); RH.setCompValue('tbl.mhs-lunas-dpp', RH.sumRecVal(ds_TBLdpp, 'jmllunas')); RH.setCompValue('tbl.mhs-blmlunas-dpp', RH.sumRecVal(ds_TBLdpp, 'jmlblmlunas')); RH.setCompValue('tbl.jml-mhs-dpp', RH.sumRecVal(ds_TBLdpp, 'jmlmhs')); } }); } function setChartDPPfak(){ if(RH.isEmpty('c-fak.stsmt-dpp')) return; if(RH.isEmpty('c-fak.fak-dpp')) return; if(RH.isEmpty('c-fak.jkelas-dpp')) return; var kdstsemester = RH.getCompValue('c-fak.stsmt-dpp'); var kdfakultas = RH.getCompValue('c-fak.fak-dpp'); var idklsmhs = RH.getCompValue('c-fak.jkelas-dpp'); //Ext.Msg.alert("DEBUG", thmasuk + '-' + idklsmhs);return; ds_DPPfak.reload({ params: { kdstsemester: kdstsemester, kdfakultas: kdfakultas, idklsmhs: idklsmhs, }, callback: function(results){ RH.setCompValue('c-fak.biaya-tagihan-dpp', RH.sumRecVal(ds_DPPfak, 'biaya')); RH.setCompValue('c-fak.bayar-dpp', RH.sumRecVal(ds_DPPfak, 'jmlbayar')); RH.setCompValue('c-fak.tunggakan-dpp', RH.sumRecVal(ds_DPPfak, 'sisa')); RH.setCompValue('c-fak.diskon-dpp', RH.sumRecVal(ds_DPPfak, 'diskon')); RH.setCompValue('c-fak.mhs-lunas-dpp', RH.sumRecVal(ds_DPPfak, 'jmllunas')); RH.setCompValue('c-fak.mhs-blm-lunas-dpp', RH.sumRecVal(ds_DPPfak, 'jmlblmlunas')); RH.setCompValue('c-fak.mhs-dpp', RH.sumRecVal(ds_DPPfak, 'jmlmhs')); } }); } function setChartDPPprod(){ if(RH.isEmpty('c-fak.stsmt-dpp')) return; if(RH.isEmpty('c-prod.kdprodi-dpp')) return; if(RH.isEmpty('c-fak.jkelas-dpp')) return; var kdstsemester = RH.getCompValue('c-fak.stsmt-dpp'); var kdprodi = RH.getCompValue('c-prod.kdprodi-dpp'); var idklsmhs = RH.getCompValue('c-fak.jkelas-dpp'); //Ext.Msg.alert("DEBUG", thmasuk + '-' + idklsmhs);return; ds_DPPprod.reload({ params: { kdstsemester: kdstsemester, kdprodi: kdprodi, idklsmhs: idklsmhs, } }); } function setChartDPPprodMhs(){ if(RH.isEmpty('c-fak.stsmt-dpp')) return; if(RH.isEmpty('c-prod.kdprodi-dpp')) return; if(RH.isEmpty('c-fak.jkelas-dpp')) return; var kdstsemester = RH.getCompValue('c-fak.stsmt-dpp'); var kdprodi = RH.getCompValue('c-prod.kdprodi-dpp'); var idklsmhs = RH.getCompValue('c-fak.jkelas-dpp'); //Ext.Msg.alert("DEBUG", thmasuk + '-' + idklsmhs);return; ds_DPPprodMhs.reload({ params: { kdstsemester: kdstsemester, kdprodi: kdprodi, idklsmhs: idklsmhs, } }); } var reader = new Ext.data.JsonReader({ root:'data', idProperty: '', totalProperty: 'results', remoteGroup: true, fields: [ { name: 'kdfakultas' } , { name: 'nmfakultas' } , { name: 'fakultas' } , { name: 'kdprodi' } , { name: 'nourutprodi' } , { name: 'nmprodi' } , { name: 'lnmprodi' } , { name: 'biaya' } , { name: 'jmlbayar' } , { name: 'persenbayar' } , { name: 'sisa' } , { name: 'persensisa' } , { name: 'diskon' } , { name: 'jmllunas' } , { name: 'jmlblmlunas' } , { name: 'jmlmhs' } ], }); var ds_TBLdpp = new Ext.data.GroupingStore({ proxy: new Ext.data.HttpProxy({ url: BASE_URL + 'chart_rektor/get_chart_dpp_fak_tbl', method: 'POST', success: function(response){ var r = Ext.decode(response.responseText); if(r.status == false){ Ext.Ajax.request({ url: BASE_URL + 'user/ext_logout', method: 'POST', success: function(xhr) { localStorage.removeItem('access_token'); window.location = BASE_URL + 'user/login'; } }); } } }), totalProperty: 'results', autoLoad : true, root: 'data', reader: reader, groupField:'fakultas', remoteSort: true, }); var ds_DPPfak = new Ext.data.JsonStore({ proxy: new Ext.data.HttpProxy({ url: BASE_URL + 'chart_rektor/get_chart_dpp_fak', method: 'POST', success: function(response){ var r = Ext.decode(response.responseText); if(r.status == false){ Ext.Ajax.request({ url: BASE_URL + 'user/ext_logout', method: 'POST', success: function(xhr) { localStorage.removeItem('access_token'); window.location = BASE_URL + 'user/login'; } }); } } }), //baseParams: { kdprodi:'' }, totalProperty: 'results', autoLoad : true, root: 'data', fields: [ { name: 'nmfakultas' } , { name: 'biaya' } , { name: 'jmlbayar' } , { name: 'sisa' } , { name: 'diskon' } , { name: 'jmllunas' } , { name: 'jmlblmlunas' } , { name: 'jmlmhs' } ] }); var ds_DPPprod = new Ext.data.JsonStore({ proxy: new Ext.data.HttpProxy({ url: BASE_URL + 'chart_rektor/get_chart_dpp_prodi', method: 'POST', success: function(response){ var r = Ext.decode(response.responseText); if(r.status == false){ Ext.Ajax.request({ url: BASE_URL + 'user/ext_logout', method: 'POST', success: function(xhr) { localStorage.removeItem('access_token'); window.location = BASE_URL + 'user/login'; } }); } } }), //baseParams: { kdprodi:'' }, totalProperty: 'results', autoLoad : true, root: 'data', fields: [ { name: 'item' } , { name: 'value' } ] }); var ds_DPPprodMhs = new Ext.data.JsonStore({ proxy: new Ext.data.HttpProxy({ url: BASE_URL + 'chart_rektor/get_chart_dpp_prodi_mhs', method: 'POST', success: function(response){ var r = Ext.decode(response.responseText); if(r.status == false){ Ext.Ajax.request({ url: BASE_URL + 'user/ext_logout', method: 'POST', success: function(xhr) { localStorage.removeItem('access_token'); window.location = BASE_URL + 'user/login'; } }); } } }), //baseParams: { kdprodi:'' }, totalProperty: 'results', autoLoad : true, root: 'data', fields: [ { name: 'item' } , { name: 'value' } ] }); var cm_TblDpp = new Ext.grid.ColumnModel({ columns: [{ header: 'Fakultas/Program Studi', width: 205, dataIndex: 'fakultas', //sortable: true }, { header: '
Fakultas/Program Studi
', width: 210, dataIndex: 'lnmprodi', //sortable: true }, { header: '
Biaya Tagihan
', width: 100, dataIndex: 'biaya', xtype: 'numbercolumn', format:'0,000', align:'right' }, { header: '
Bayar
', width: 100, dataIndex: 'jmlbayar', xtype: 'numbercolumn', format:'0,000', align:'right' }, { header: '
% Bayar
', width: 100, dataIndex: 'persenbayar', xtype: 'numbercolumn', format:'0.%', align:'right' }, { header: '
Tunggakan
', width: 100, dataIndex: 'sisa', xtype: 'numbercolumn', format:'0,000', align:'right' }, { header: '
% Tunggakan
', width: 100, dataIndex: 'persensisa', xtype: 'numbercolumn', format:'0.%', align:'right' }, { header: '
Diskon
', width: 100, dataIndex: 'diskon', xtype: 'numbercolumn', format:'0,000', align:'right' }, { header: '
Jml.Mhs Lunas
', width: 100, dataIndex: 'jmllunas', sortable: true, align:'right' },{ header: '
Jml.Mhs Blm Lunas
', width: 100, dataIndex: 'jmlblmlunas', sortable: true, align:'right' },{ header: '
Jml.Mahasiswa
', width: 100, dataIndex: 'jmlmhs', sortable: true, align:'right' }] }); var chartDPPfak = new Ext.Panel({ layout: 'fit', autoWidth:true, frame:false, //autoScroll: true, autoSizeColumns: true, enableColumnResize: true, enableColumnHide: false, enableColumnMove: false, enableHdaccess: false, columnLines: true, loadMask: true, height:250, //title: 'Grafik DPK Fakultas', tbar: [{text: 'Grafik DPP Per Fakultas',},'->', {xtype: 'label', text: 'Fakultas : '}, {xtype: 'textfield',id: 'c-fak.fakultas-dpp',readOnly:true, width:265},'-', {xtype: 'label', text: 'Tahun Akademik-Semester : '}, {xtype: 'textfield',id: 'c-fak.thn-dpp',readOnly:true, width:130},'-', {xtype: 'label', text: 'Jenis Kelas : '}, {xtype: 'textfield',id: 'c-fak.jkls-dpp',readOnly:true}], bbar: [{xtype: 'label', text: 'Tot.Biaya Tagihan : '}, {xtype: 'numericfield', decimalSeparator: ',', decimalPrecision: 0, alwaysDisplayDecimals: true, useThousandSeparator: true, thousandSeparator: '.',id: 'c-fak.biaya-tagihan-dpp',readOnly:true, width:80},'-', {xtype: 'label', text: 'Tot.Bayar : '}, {xtype: 'numericfield', decimalSeparator: ',', decimalPrecision: 0, alwaysDisplayDecimals: true, useThousandSeparator: true, thousandSeparator: '.',id: 'c-fak.bayar-dpp',readOnly:true, width:80},'-', {xtype: 'label', text: 'Tot.Tunggakan : '}, {xtype: 'numericfield', decimalSeparator: ',', decimalPrecision: 0, alwaysDisplayDecimals: true, useThousandSeparator: true, thousandSeparator: '.',id: 'c-fak.tunggakan-dpp',readOnly:true, width:80},'-', {xtype: 'label', text: 'Tot.Diskon : '}, {xtype: 'numericfield', decimalSeparator: ',', decimalPrecision: 0, alwaysDisplayDecimals: true, useThousandSeparator: true, thousandSeparator: '.',id: 'c-fak.diskon-dpp',readOnly:true, width:80}], items: { xtype: 'columnchart', store: ds_DPPfak, //yField: 'biaya', series: [ { yField: 'biaya', displayName: 'Tot.Biaya Tagihan' },{ yField: 'jmlbayar', displayName: 'Tot.Bayar' },{ yField: 'sisa', displayName: 'Tot.Tunggakan' },{ yField: 'diskon', displayName: 'Tot.Diskon' } ], url: '../../resources/js/ext/resources/charts.swf', xField: 'nmfakultas', xAxis: new Ext.chart.CategoryAxis({ title: 'Fakultas' }), yAxis: new Ext.chart.NumericAxis({ title: 'Rp.', labelRenderer : Ext.util.Format.numberRenderer('0,0') }), extraStyle: { xAxis: { labelRotation: 0 } } } }); var pieChartMhsDPPfak = new Ext.Panel({ layout: 'fit', autoWidth:true, frame:false, //autoScroll: true, autoSizeColumns: true, enableColumnResize: true, enableColumnHide: false, enableColumnMove: false, enableHdaccess: false, columnLines: true, loadMask: true, height:250, //title: 'Grafik DPK Fakultas', tbar: [{text: 'Grafik Total Mahasiswa Per Fakultas',},'->', {xtype: 'label', text: 'Fakultas : '}, {xtype: 'textfield',id: 'c-fak.fakultas-dpp-mhs',readOnly:true, width:270},'-', {xtype: 'label', text: 'Tahun Akademik-Semester : '}, {xtype: 'textfield',id: 'c-fak.thn-dpp-mhs',readOnly:true, width:130},'-', {xtype: 'label', text: 'Jenis Kelas : '}, {xtype: 'textfield',id: 'c-fak.jkls-dpp-mhs',readOnly:true}], bbar: [{xtype: 'label', text: 'Tot.Mhs Lunas : '}, {xtype: 'textfield',id: 'c-fak.mhs-lunas-dpp',readOnly:true, width:80},'-', {xtype: 'label', text: 'Tot.Mhs Blm Lunas : '}, {xtype: 'textfield',id: 'c-fak.mhs-blm-lunas-dpp',readOnly:true, width:80},'-', {xtype: 'label', text: 'Tot.Mahasiswa : '}, {xtype: 'textfield',id: 'c-fak.mhs-dpp',readOnly:true, width:80}], items: { xtype: 'columnchart', store: ds_DPPfak, //yField: 'biaya', series: [ { yField: 'jmllunas', displayName: 'Tot.Mhs Lunas' },{ yField: 'jmlblmlunas', displayName: 'Tot.Mhs Blm Lunas' },{ yField: 'jmlmhs', displayName: 'Tot.Mahasiswa' } ], url: '../../resources/js/ext/resources/charts.swf', xField: 'nmfakultas', xAxis: new Ext.chart.CategoryAxis({ title: 'Fakultas' }), yAxis: new Ext.chart.NumericAxis({ title: 'Jml Mhs.', labelRenderer : Ext.util.Format.numberRenderer('0,0') }), extraStyle: { xAxis: { labelRotation: 0 } } } }); var chartDPPprod = new Ext.Panel({ layout: 'fit', autoWidth:true, frame:false, //autoScroll: true, autoSizeColumns: true, enableColumnResize: true, enableColumnHide: false, enableColumnMove: false, enableHdaccess: false, columnLines: true, loadMask: true, height:250, tbar: [{text: 'Grafik DPP Per Program Studi'}, {xtype: 'textfield',id: 'c-prod.kdprodi-dpp',hidden:true},'->', {xtype: 'label', text: 'Program Studi : '}, {xtype: 'textfield',id: 'c-prod.nmprodi-dpp',readOnly:true, width:270},'-', {xtype: 'label', text: 'Tahun Akademik-Semester : '}, {xtype: 'textfield',id: 'c-prod.smt-dpp',readOnly:true, width:130},'-', {xtype: 'label', text: 'Jenis Kelas : '}, {xtype: 'textfield',id: 'c-prod.jnskls-dpp',readOnly:true}], items: { xtype: 'columnchart', store: ds_DPPprod, categoryField: 'item', yField: 'value', url: '../../resources/js/ext/resources/charts.swf', xField: 'item', xAxis: new Ext.chart.CategoryAxis({ title: 'Keterangan' }), yAxis: new Ext.chart.NumericAxis({ title: 'Rp.', labelRenderer : Ext.util.Format.numberRenderer('0,0') }), extraStyle: { xAxis: { labelRotation: 0 } } } }); var pieChartDPPprodMhs = new Ext.Panel({ layout: 'fit', autoWidth:true, frame:false, //autoScroll: true, autoSizeColumns: true, enableColumnResize: true, enableColumnHide: false, enableColumnMove: false, enableHdaccess: false, columnLines: true, loadMask: true, height:250, tbar: [{text: 'Grafik Total Mahasiswa Per Program Studi'}, {xtype: 'textfield',id: 'c-prod.kdprodi-dpp-mhs',hidden:true},'->', {xtype: 'label', text: 'Program Studi : '}, {xtype: 'textfield',id: 'c-prod.nmprodi-dpp-mhs',readOnly:true, width:265},'-', {xtype: 'label', text: 'Tahun Akademik-Semestern : '}, {xtype: 'textfield',id: 'c-prod.smt-dpp-mhs',readOnly:true, width:130},'-', {xtype: 'label', text: 'Jenis Kelas : '}, {xtype: 'textfield',id: 'c-prod.jnskls-dpp-mhs',readOnly:true}], items: { xtype: 'columnchart', store: ds_DPPprodMhs, categoryField: 'item', yField: 'value', url: '../../resources/js/ext/resources/charts.swf', xField: 'item', xAxis: new Ext.chart.CategoryAxis({ title: 'Keterangan' }), yAxis: new Ext.chart.NumericAxis({ title: 'Jml Mhs.', labelRenderer : Ext.util.Format.numberRenderer('0,0') }), extraStyle: { xAxis: { labelRotation: 0 } } } }); var cari_data_nyaa = [new Ext.ux.grid.Search({ iconCls: 'btn_search', minChars: 1, autoFocus: true, autoHeight: true, position: 'top', mode: 'local', width: 200 })]; var gp_TblDpp = new Ext.grid.GridPanel({ id: 'gp.DppTbl', title: 'Tabel DPK Fakultas/ Program Studi', plugins: cari_data_nyaa, ds: ds_TBLdpp, cm: cm_TblDpp, sm: new Ext.grid.RowSelectionModel({ singleSelect: true}), tbar: [{},'->'], view: new Ext.grid.GroupingView({ forceFit:true, groupTextTpl: '{text} ({[values.rs.length]} {["Prodi"]})', enableGroupingMenu: false, // don't show a grouping menu enableNoGroups: false, // don't let the user ungroup hideGroupedColumn: true, // don't show the column that is being used to create the heading showGroupName: false, // don't show the field name with the group heading startCollapsed: false // the groups start closed/no }), autoWidth:true, clicksToEdit: 1, //for cell editing (single click =1, dblclick=2) forceFit: true, //autoHeight: true, autoScroll: true, autoSizeColumns: true, enableColumnResize: true, enableColumnHide: false, enableColumnMove: false, enableHdaccess: false, columnLines: true, loadMask: true, layout: 'anchor', bbar: [ { xtype: 'label', text : "Tot.Biaya Tagihan :", },{ xtype: 'numericfield', //fieldLabel: 'Tot.Biaya Tagihan', id:'tbl.to-biaya-tagihan-dpp', readOnly: true, width:90, decimalSeparator: ',', decimalPrecision: 0, alwaysDisplayDecimals: true, useThousandSeparator: true, thousandSeparator: '.', },'-', { xtype: 'label', text : "Tot.Bayar :", },{ xtype: 'numericfield', //fieldLabel: 'Tot.Bayar', id:'tbl.to-bayar-dpp', readOnly: true, width:90, decimalSeparator: ',', decimalPrecision: 0, alwaysDisplayDecimals: true, useThousandSeparator: true, thousandSeparator: '.', },'-', { xtype: 'label', text : "Tot.Tunggakan :", },{ xtype: 'numericfield', //fieldLabel: 'Tot.Tunggakan', id:'tbl.to-tunggakan-dpp', readOnly: true, width:90, decimalSeparator: ',', decimalPrecision: 0, alwaysDisplayDecimals: true, useThousandSeparator: true, thousandSeparator: '.', },'-', { xtype: 'label', text : "Tot.Diskon :", },{ xtype: 'numericfield', //fieldLabel: 'Tot.Diskon', id:'tbl.to-diskon-dpp', readOnly: true, width:90, decimalSeparator: ',', decimalPrecision: 0, alwaysDisplayDecimals: true, useThousandSeparator: true, thousandSeparator: '.', },'-', { xtype: 'label', text : "Tot.Mhs Lunas :", },{ xtype: 'textfield', //fieldLabel: 'Tot.Mhs Lunas', id:'tbl.mhs-lunas-dpp', readOnly: true, width:50, },'-', { xtype: 'label', text : "Tot.Mhs Blm Lunas :", },{ xtype: 'textfield', //fieldLabel: 'Tot.Mhs Blm Lunas', id:'tbl.mhs-blmlunas-dpp', readOnly: true, width:50, },'-', { xtype: 'label', text : "Tot.Mahasiswa :", },{ xtype: 'textfield', //fieldLabel: 'Tot.Mahasiswa', id:'tbl.jml-mhs-dpp', readOnly: true, width:50, } ], listeners: { rowclick: onRowDppClick } }); var panel_filter_DPP = new Ext.Panel({ id: 'fp.RptDPP', title:'Laporan Keuangan DPP', layout: 'anchor', forceFit: true, maskDisabled: false, monitorValid: true, autoScroll: true, //width:500, height:400, margin: '0 0 10', frame: true, xtype: 'form', defaults: { labelWidth: 115, labelAlign: 'right'}, items: [ { xtype: 'fieldset', flex: 1, region:'north', layout:'column', autoHeight:true, items: [ { columnWidth:.3, layout: 'form', items: [ { xtype: 'combo', id: 'c-fak.fak-dpp', fieldLabel: 'Fakultas', store: ds_fak, valueField: 'kdfakultas', displayField: 'nmfakultas', triggerAction: 'all',editable: false, width: 205, forceSelection: true, submitValue: true, mode: 'local', emptyText:'Pilih...', listeners:{ scope: this, 'select': function(){ setChartDPPfak(); setTBLdpp(); setChartDPPprod(); Ext.getCmp('c-fak.fakultas-dpp').setValue(Ext.getCmp('c-fak.fak-dpp').getRawValue()); Ext.getCmp('c-fak.fakultas-dpp-mhs').setValue(Ext.getCmp('c-fak.fak-dpp').getRawValue());} } } ] }, { columnWidth:.3, layout: 'form', items: [ { xtype: 'combo', id: 'c-fak.stsmt-dpp', fieldLabel: 'Th.Akademik-Smt', store: ds_stsmt_dpp, triggerAction: 'all', width: 170, valueField: 'kdstsemester', displayField: 'nmthnakademik', forceSelection: true, submitValue: true, mode: 'local', emptyText:'Pilih...', //selectOnFocus:true, listeners:{ scope: this, 'select': function(){ setChartDPPfak(); setTBLdpp(); setChartDPPprod(); Ext.getCmp('c-fak.thn-dpp').setValue(Ext.getCmp('c-fak.stsmt-dpp').getRawValue()); Ext.getCmp('c-fak.thn-dpp-mhs').setValue(Ext.getCmp('c-fak.stsmt-dpp').getRawValue()); Ext.getCmp('c-prod.smt-dpp').setValue(Ext.getCmp('c-fak.stsmt-dpp').getRawValue()); Ext.getCmp('c-prod.smt-dpp-mhs').setValue(Ext.getCmp('c-fak.stsmt-dpp').getRawValue());} } } ] }, { columnWidth:.3, layout: 'form', items: [ { xtype: 'combo', id: 'c-fak.jkelas-dpp', fieldLabel: 'Jenis Kelas', store: ds_jkls, valueField: 'idklsmhs', displayField: 'kdnm', triggerAction: 'all',editable: false, forceSelection: true, submitValue: true, mode: 'local', emptyText:'Pilih...', //selectOnFocus:true, listeners:{ scope: this, 'select': function(){ setChartDPPfak(); setTBLdpp(); setChartDPPprod(); Ext.getCmp('c-fak.jkls-dpp').setValue(Ext.getCmp('c-fak.jkelas-dpp').getRawValue()); Ext.getCmp('c-fak.jkls-dpp-mhs').setValue(Ext.getCmp('c-fak.jkelas-dpp').getRawValue()); Ext.getCmp('c-prod.jnskls-dpp').setValue(Ext.getCmp('c-fak.jkelas-dpp').getRawValue()); Ext.getCmp('c-prod.jnskls-dpp-mhs').setValue(Ext.getCmp('c-fak.jkelas-dpp').getRawValue());} } } ] } ] }, { xtype: 'panel', layout:'fit', id:'fp.dpp-fakultas', frame:true, height: 435, items:[gp_TblDpp] }, { items:[chartDPPfak,pieChartMhsDPPfak,RH.vSpacer(50), chartDPPprod,pieChartDPPprodMhs] } ] }); var fDPP = { //new Ext.form.FormPanel({ //{ xtype: 'panel', //'container', id: 'content.dpp', layout: 'form', border:false, autoScroll: true, defaults: { labelWidth: 150, labelAlign: 'right' }, items: [panel_filter_DPP] }; //); return fDPP; ///////////////////---------------------------------------------------////////////////////// } var rektorTabs = { //new Ext.TabPanel({ //{ //Ext.widget('tabpanel', { //for Extjs-4 xtype: 'tabpanel', id: 'tabpanel-rektor', defaults :{ bodyPadding: 10, autoScroll: true, frame: true }, activeTab: 0, items: [{ title: 'Student Body', id: 'tab.sb', autoScroll: true, //forceLayout: true, //INI MAKSA LAYOUT, YG HBOX JADI INVISIBLE items: [studentBody()] //[fStudentbody] },{ title: 'DPK', id: 'tab.dpk', autoScroll: true, //disabled:true, //to disable for selecting a tab items: [DPK()] //[fDpk] },{ title: 'DPP', id: 'tab.dpp', autoScroll: true, items: [DPP()] //[fDpp] }] }; var dpkTabPanel = new Ext.form.FormPanel({ xtype: 'form', id: 'fp.dpkTabPanel', region: 'center', buttonAlign: 'left', bodyStyle: 'padding: 0px', border: false, autoScroll: true, //disabled: true, waitMsg: 'Waiting...', maskDisabled: false, monitorValid: true, layout: 'fit', /*items: [{ layout: 'form', border: false, items: [mhsTabs] }],*/ items: [rektorTabs], }); var rekTabPanel = new Ext.Panel({ bodyStyle: 'padding: 5px', title: 'Dashboard', iconCls: 'silk-dash', frame: false, defaults: { //anchor: '-10' }, border: true, autoScroll: true, margins: '0 0 5 0', plain: true, forceFit: true, layout: 'border', //'column', items: [dpkTabPanel] }); get_content(rekTabPanel); }