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);
}