| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229 |
- Ext.define('saas.view.money.report.VendorCheck', {
- extend: 'saas.view.core.report.ReportPanel',
- xtype: 'monry-report-vendorcheck',
- controller: 'money-report-vendorcheck',
- viewModel: 'money-report-vendorcheck',
- viewName: 'money-report-vendorcheck',
- // groupField: null,
- listUrl: '/api/money/report/vendorCheck',
- defaultCondition: null,
- reportTitle: '供应商对账单',
- QueryWidth:0.4,
- autoLoad:false,
- //筛选:供应商、日期(必填)
- searchItems: [ {
- xtype: 'vendorDbfindTrigger',
- name: 'pi_vendname',
- fieldLabel: '供应商名称',
- columnWidth: 0.2,
- allowBlank:false,
- listeners: {
- beforequery: function(f) {
- return !!f.value;
- }
- }
- }, {
- // xtype: 'monthdatefield',
- // name: 'ym',
- // fieldLabel: '期初日期',
- // columnWidth: 0.2
- // }, {
- xtype: 'condatefield',
- name: 'pi_date',
- fieldLabel: '单据日期',
- columnWidth: 0.4
- }],
- reportColumns: [{
- text: 'id',
- dataIndex: 'pi_id',
- hidden: true
- }, {
- text: '单据日期',
- dataIndex: 'pi_date',
- xtype:'datecolumn',
- width: 110
- }, {
- text: '单号',
- dataIndex: 'pi_inoutno',
- width: 150
- }, {
- text: '序号',
- xtype: 'numbercolumn',
- dataIndex: 'pd_pdno',
- exportFormat: 'Integer',
- width: 80
- },{
- text:'供应商编号',
- dataIndex:'pi_vendcode',
- width: 150,
- hidden:true
- },{
- text:'供应商名称',
- dataIndex:'pi_vendname',
- width: 250,
- hidden:true
- }, {
- text: '物料编号',
- width: 150,
- dataIndex: 'pr_code'
- }, {
- text: '品牌',
- dataIndex: 'pr_brand',
- width: 200
- }, {
- text: '名称',
- dataIndex: 'pr_detail',
- width: 200
- }, {
- text: '型号',
- dataIndex: 'pr_orispeccode',
- width: 200
- }, {
- text: '规格',
- dataIndex: 'pr_spec',
- width: 150
- }, {
- text: '数量',
- dataIndex: 'qty',
- exportFormat: 'Quantity',
- xtype: 'numbercolumn',
- width: 110,
- renderer: function(v) {
- var arr = (v + '.').split('.');
- var xr = (new Array(arr[1].length > 3 ? 3 : arr[1].length)).fill('0');
- var format = '0.' + xr.join('');
- return Ext.util.Format.number(v, format);
- }
- }, {
- text: '单位',
- dataIndex: 'pd_unit',
- width: 80
- }, {
- text: '单价(元)',
- dataIndex: 'pd_orderprice',
- exportFormat: 'Price',
- xtype: 'numbercolumn',
- width: 110,
- renderer: function(v) {
- var arr = (v + '.').split('.');
- var xr = (new Array(arr[1].length > 4 ? 4 : arr[1].length)).fill('0');
- var format = '0,000.' + xr.join('');
- return Ext.util.Format.number(v, format);
- }
- }, {
- text: '税率',
- dataIndex: 'pd_taxrate',
- exportFormat: 'Integer',
- xtype: 'numbercolumn',
- width: 80,
- renderer: function(v) {
- return Ext.util.Format.number(v, '0');
- }
- }, {
- text: '金额(元)',
- xtype: 'numbercolumn',
- exportFormat: 'Amount',
- dataIndex: 'pd_total',
- width: 110,
- renderer : function(v) {
- var arr = (v + '.').split('.');
- var xr = (new Array(arr[1].length > 2 ? 2 : arr[1].length)).fill('0');
- var format = '0,000.' + xr.join('');
- return Ext.util.Format.number(v, format);
- },
- // summaryType: 'sum',
- // summaryRenderer: function(v) {
- // var arr = (v + '.').split('.');
- // var xr = (new Array(arr[1].length > 2 ? 2 : arr[1].length)).fill('0');
- // var format = '0,000.' + xr.join('');
- // return Ext.util.Format.number(v, format);
- // }
- }, {
- text: '不含税单价(元)',
- dataIndex: 'pd_netprice',
- exportFormat: 'Price',
- xtype: 'numbercolumn',
- width: 150,
- renderer: function(v) {
- var arr = (v + '.').split('.');
- var xr = (new Array(arr[1].length > 4 ? 4 : arr[1].length)).fill('0');
- var format = '0,000.' + xr.join('');
- return Ext.util.Format.number(v, format);
- }
- }, {
- text: '不含税金额(元)',
- dataIndex: 'pd_nettotal',
- exportFormat: 'Amount',
- xtype: 'numbercolumn',
- width: 150,
- renderer : function(v) {
- var arr = (v + '.').split('.');
- var xr = (new Array(arr[1].length > 2 ? 2 : arr[1].length)).fill('0');
- var format = '0,000.' + xr.join('');
- return Ext.util.Format.number(v, format);
- },
- }, {
- text: '单据类型',
- dataIndex: 'pi_class',
- width: 110
- }, {
- text: '期初应付',
- dataIndex: 'beginamount',
- hidden: true,
- width: 0,
- summaryType: 'cus',
- }, {
- text: '增加应付',
- dataIndex: 'nowamount',
- hidden: true,
- width: 0,
- summaryType: 'cus',
- }, {
- text: '增加预付',
- dataIndex: 'nowpay',
- hidden: true,
- width: 0,
- summaryType: 'cus',
- }, {
- text: '应付余额',
- dataIndex: 'nowbalance',
- hidden: true,
- width: 0,
- summaryType: 'cus',
- }],
- listeners: {
- afterrender: function(panel) {
- panel.setLoadButtonDisabled(true);
- },
- },
- setLoadButtonDisabled: function (disabled) {
- var panel = this,
- grid = panel.down('grid'),
- p = grid.down('pagingtoolbar'),
- bs = p.query('button'),
- loadButton = Ext.Array.findBy(bs, function (b) {
- return b.iconCls == 'x-tbar-loading';
- });
- if (loadButton) {
- loadButton.setDisabled(disabled);
- }
- },
- applyParams: function(p) {
- var me = this,
- viewModel = me.getViewModel(),
- formData = viewModel.get('form'),
- ym = formData.ym;
- return Ext.Object.merge(p, {
- ym: ym
- });
- }
- });
|