1 //<script type="text/javascript">
3 // Auto generated file - created by app.Builder.js- do not edit directly (at present!)
5 Pman.Tab.XtuplePurchaseRecv = new Roo.XComponent({
6 part : ["Xtuple","PurchaseRecv"],
7 order : '001-Pman.Tab.XtuplePurchaseRecv',
9 parent : 'Pman.Tab.XtuplePurchases',
10 name : "Pman.Tab.XtuplePurchaseRecv",
18 xtype: 'NestedLayoutPanel',
22 title : "PO / Recieve Stock",
24 xtype: 'BorderLayout',
31 activate : function() {
34 _this.grid.footer.onClick('first');
43 title : "PO Receive Stock",
51 //_this.dialog = Pman.Dialog.FILL_IN
52 if (_this.ppanel.active) {
53 this.footer.onClick('first');
56 cellclick : function (_self, rowIndex, columnIndex, e)
59 var applyVoucher = function(){
60 Roo.MessageBox.confirm("Confirm", "Are you sure to apply voucher for the selected PO completely?",
67 url: baseURL+'/Roo/Pohead.php',
71 'pohead_id' : s.data.pohead_id,
74 success : function () {
75 _this.grid.footer.onClick('refresh');
83 var di = _this.grid.getColumnModel().getDataIndex(columnIndex);
84 var s = _this.grid.ds.getAt(rowIndex);
86 if(di == 'pohead_vouchered'){
87 if(s.data.pohead_status != 'O'){
88 Roo.MessageBox.alert('Error', 'Please Open this PO first');
91 if(Math.round(s.data.pohead_vouchered*100) == Math.round(s.data.pohead_val*100)){
92 Roo.MessageBox.alert('Error', 'This PO has been apply completely!');
100 if(di == 'pohead_paid'){ // comming soon...
106 _this.rggrid.ds.load({});
109 autoExpandColumn : 'pohead_vend_id_vend_name',
111 trackMouseOver : true,
113 xtype: 'CellSelectionModel',
120 beforeload : function (_self, o)
122 o.params._with_recv = 1;
125 o.params['query[number]'] = _this.searchBox.getValue();
127 // only filter by type if the number is empty..
128 if (!o.params['query[number]'].length) {
129 o.params.pohead_status = _this.status.getValue();
134 load : function (_self, records, options)
137 (function() { _this.rggrid.ds.load({}); }).defer(100);
141 sortInfo : { field : 'pohead_orderdate', direction: 'DESC' },
146 url : baseURL + '/Roo/pohead.php'
151 totalProperty : 'total',
160 'name': 'pohead_status',
164 'name': 'pohead_number',
168 'name': 'pohead_orderdate',
170 'dateFormat': 'Y-m-d'
173 'name': 'pohead_vend_id',
177 'name': 'pohead_fob',
181 'name': 'pohead_shipvia',
185 'name': 'pohead_comments',
189 'name': 'pohead_freight',
193 'name': 'pohead_printed',
197 'name': 'pohead_terms_id',
201 'name': 'pohead_warehous_id',
205 'name': 'pohead_vendaddr_id',
209 'name': 'pohead_agent_username',
213 'name': 'pohead_curr_id',
217 'name': 'pohead_saved',
221 'name': 'pohead_taxzone_id',
225 'name': 'pohead_taxtype_id',
229 'name': 'pohead_dropship',
233 'name': 'pohead_vend_cntct_id',
237 'name': 'pohead_vend_cntct_honorific',
241 'name': 'pohead_vend_cntct_first_name',
245 'name': 'pohead_vend_cntct_middle',
249 'name': 'pohead_vend_cntct_last_name',
253 'name': 'pohead_vend_cntct_suffix',
257 'name': 'pohead_vend_cntct_phone',
261 'name': 'pohead_vend_cntct_title',
265 'name': 'pohead_vend_cntct_fax',
269 'name': 'pohead_vend_cntct_email',
273 'name': 'pohead_vendaddress1',
277 'name': 'pohead_vendaddress2',
281 'name': 'pohead_vendaddress3',
285 'name': 'pohead_vendcity',
289 'name': 'pohead_vendstate',
293 'name': 'pohead_vendzipcode',
297 'name': 'pohead_vendcountry',
301 'name': 'pohead_shipto_cntct_id',
305 'name': 'pohead_shipto_cntct_honorific',
309 'name': 'pohead_shipto_cntct_first_name',
313 'name': 'pohead_shipto_cntct_middle',
317 'name': 'pohead_shipto_cntct_last_name',
321 'name': 'pohead_shipto_cntct_suffix',
325 'name': 'pohead_shipto_cntct_phone',
329 'name': 'pohead_shipto_cntct_title',
333 'name': 'pohead_shipto_cntct_fax',
337 'name': 'pohead_shipto_cntct_email',
341 'name': 'pohead_shiptoddress_id',
345 'name': 'pohead_shiptoaddress1',
349 'name': 'pohead_shiptoaddress2',
353 'name': 'pohead_shiptoaddress3',
357 'name': 'pohead_shiptocity',
361 'name': 'pohead_shiptostate',
365 'name': 'pohead_shiptozipcode',
369 'name': 'pohead_shiptocountry',
373 'name': 'pohead_cohead_id',
377 'name': 'pohead_released',
379 'dateFormat': 'Y-m-d'
382 'name': 'pohead_curr_id_curr_id',
386 'name': 'pohead_curr_id_curr_base',
390 'name': 'pohead_curr_id_curr_name',
394 'name': 'pohead_curr_id_curr_symbol',
398 'name': 'pohead_curr_id_curr_abbr',
402 'name': 'pohead_warehous_id_warehous_id',
406 'name': 'pohead_warehous_id_warehous_code',
410 'name': 'pohead_warehous_id_warehous_descrip',
414 'name': 'pohead_warehous_id_warehous_fob',
418 'name': 'pohead_warehous_id_warehous_active',
422 'name': 'pohead_warehous_id_warehous_counttag_prefix',
426 'name': 'pohead_warehous_id_warehous_counttag_number',
430 'name': 'pohead_warehous_id_warehous_bol_prefix',
434 'name': 'pohead_warehous_id_warehous_bol_number',
438 'name': 'pohead_warehous_id_warehous_shipping',
442 'name': 'pohead_warehous_id_warehous_useslips',
446 'name': 'pohead_warehous_id_warehous_usezones',
450 'name': 'pohead_warehous_id_warehous_aislesize',
454 'name': 'pohead_warehous_id_warehous_aislealpha',
458 'name': 'pohead_warehous_id_warehous_racksize',
462 'name': 'pohead_warehous_id_warehous_rackalpha',
466 'name': 'pohead_warehous_id_warehous_binsize',
470 'name': 'pohead_warehous_id_warehous_binalpha',
474 'name': 'pohead_warehous_id_warehous_locationsize',
478 'name': 'pohead_warehous_id_warehous_locationalpha',
482 'name': 'pohead_warehous_id_warehous_enforcearbl',
486 'name': 'pohead_warehous_id_warehous_default_accnt_id',
490 'name': 'pohead_warehous_id_warehous_shipping_commission',
494 'name': 'pohead_warehous_id_warehous_cntct_id',
498 'name': 'pohead_warehous_id_warehous_addr_id',
502 'name': 'pohead_warehous_id_warehous_transit',
506 'name': 'pohead_warehous_id_warehous_shipform_id',
510 'name': 'pohead_warehous_id_warehous_shipvia_id',
514 'name': 'pohead_warehous_id_warehous_shipcomments',
518 'name': 'pohead_warehous_id_warehous_costcat_id',
522 'name': 'pohead_warehous_id_warehous_costcat_id',
526 'name': 'pohead_warehous_id_warehous_sitetype_id',
530 'name': 'pohead_warehous_id_warehous_taxzone_id',
534 'name': 'pohead_warehous_id_warehous_sequence',
538 'name': 'pohead_vendaddr_id_vendaddr_id',
542 'name': 'pohead_vendaddr_id_vendaddr_vend_id',
546 'name': 'pohead_vendaddr_id_vendaddr_code',
550 'name': 'pohead_vendaddr_id_vendaddr_name',
554 'name': 'pohead_vendaddr_id_vendaddr_comments',
558 'name': 'pohead_vendaddr_id_vendaddr_cntct_id',
562 'name': 'pohead_vendaddr_id_vendaddr_addr_id',
566 'name': 'pohead_vendaddr_id_vendaddr_taxzone_id',
570 'name': 'pohead_vend_id_vend_id',
574 'name': 'pohead_vend_id_vend_name',
578 'name': 'pohead_vend_id_vend_lastpurchdate',
582 'name': 'pohead_vend_id_vend_active',
586 'name': 'pohead_vend_id_vend_po',
590 'name': 'pohead_vend_id_vend_comments',
594 'name': 'pohead_vend_id_vend_pocomments',
598 'name': 'pohead_vend_id_vend_number',
602 'name': 'pohead_vend_id_vend_1099',
606 'name': 'pohead_vend_id_vend_exported',
610 'name': 'pohead_vend_id_vend_fobsource',
614 'name': 'pohead_vend_id_vend_fob',
618 'name': 'pohead_vend_id_vend_terms_id',
622 'name': 'pohead_vend_id_vend_shipvia',
626 'name': 'pohead_vend_id_vend_vendtype_id',
630 'name': 'pohead_vend_id_vend_qualified',
634 'name': 'pohead_vend_id_vend_ediemail',
638 'name': 'pohead_vend_id_vend_ediemailbody',
642 'name': 'pohead_vend_id_vend_edisubject',
646 'name': 'pohead_vend_id_vend_edifilename',
650 'name': 'pohead_vend_id_vend_accntnum',
654 'name': 'pohead_vend_id_vend_emailpodelivery',
658 'name': 'pohead_vend_id_vend_restrictpurch',
662 'name': 'pohead_vend_id_vend_edicc',
666 'name': 'pohead_vend_id_vend_curr_id',
670 'name': 'pohead_vend_id_vend_cntct1_id',
674 'name': 'pohead_vend_id_vend_cntct2_id',
678 'name': 'pohead_vend_id_vend_addr_id',
682 'name': 'pohead_vend_id_vend_match',
686 'name': 'pohead_vend_id_vend_ach_enabled',
690 'name': 'pohead_vend_id_vend_ach_accnttype',
694 'name': 'pohead_vend_id_vend_ach_use_vendinfo',
698 'name': 'pohead_vend_id_vend_ach_indiv_number',
702 'name': 'pohead_vend_id_vend_ach_indiv_name',
706 'name': 'pohead_vend_id_vend_ediemailhtml',
710 'name': 'pohead_vend_id_vend_ach_routingnumber',
714 'name': 'pohead_vend_id_vend_ach_accntnumber',
718 'name': 'pohead_vend_id_vend_taxzone_id',
722 'name': 'pohead_vend_cntct_id_cntct_id',
726 'name': 'pohead_vend_cntct_id_cntct_crmacct_id',
730 'name': 'pohead_vend_cntct_id_cntct_addr_id',
734 'name': 'pohead_vend_cntct_id_cntct_first_name',
738 'name': 'pohead_vend_cntct_id_cntct_last_name',
742 'name': 'pohead_vend_cntct_id_cntct_honorific',
746 'name': 'pohead_vend_cntct_id_cntct_initials',
750 'name': 'pohead_vend_cntct_id_cntct_active',
754 'name': 'pohead_vend_cntct_id_cntct_phone',
758 'name': 'pohead_vend_cntct_id_cntct_phone2',
762 'name': 'pohead_vend_cntct_id_cntct_fax',
766 'name': 'pohead_vend_cntct_id_cntct_email',
770 'name': 'pohead_vend_cntct_id_cntct_webaddr',
774 'name': 'pohead_vend_cntct_id_cntct_notes',
778 'name': 'pohead_vend_cntct_id_cntct_title',
782 'name': 'pohead_vend_cntct_id_cntct_number',
786 'name': 'pohead_vend_cntct_id_cntct_middle',
790 'name': 'pohead_vend_cntct_id_cntct_suffix',
794 'name': 'pohead_vend_cntct_id_cntct_owner_username',
798 'name': 'pohead_vend_cntct_id_cntct_name',
802 'name': 'pohead_terms_id_terms_id',
806 'name': 'pohead_terms_id_terms_code',
810 'name': 'pohead_terms_id_terms_descrip',
814 'name': 'pohead_terms_id_terms_type',
818 'name': 'pohead_terms_id_terms_duedays',
822 'name': 'pohead_terms_id_terms_discdays',
826 'name': 'pohead_terms_id_terms_discprcnt',
830 'name': 'pohead_terms_id_terms_cutoffday',
834 'name': 'pohead_terms_id_terms_ap',
838 'name': 'pohead_terms_id_terms_ar',
842 'name': 'pohead_taxzone_id_taxzone_id',
846 'name': 'pohead_taxzone_id_taxzone_code',
850 'name': 'pohead_taxzone_id_taxzone_descrip',
854 'name': 'pohead_taxtype_id_taxtype_id',
858 'name': 'pohead_taxtype_id_taxtype_name',
862 'name': 'pohead_taxtype_id_taxtype_descrip',
866 'name': 'pohead_taxtype_id_taxtype_sys',
870 'name': 'pohead_shiptoddress_id_addr_id',
874 'name': 'pohead_shiptoddress_id_addr_active',
878 'name': 'pohead_shiptoddress_id_addr_line1',
882 'name': 'pohead_shiptoddress_id_addr_line2',
886 'name': 'pohead_shiptoddress_id_addr_line3',
890 'name': 'pohead_shiptoddress_id_addr_city',
894 'name': 'pohead_shiptoddress_id_addr_state',
898 'name': 'pohead_shiptoddress_id_addr_postalcode',
902 'name': 'pohead_shiptoddress_id_addr_country',
906 'name': 'pohead_shiptoddress_id_addr_notes',
910 'name': 'pohead_shiptoddress_id_addr_number',
914 'name': 'pohead_shipto_cntct_id_cntct_id',
918 'name': 'pohead_shipto_cntct_id_cntct_crmacct_id',
922 'name': 'pohead_shipto_cntct_id_cntct_addr_id',
926 'name': 'pohead_shipto_cntct_id_cntct_first_name',
930 'name': 'pohead_shipto_cntct_id_cntct_last_name',
934 'name': 'pohead_shipto_cntct_id_cntct_honorific',
938 'name': 'pohead_shipto_cntct_id_cntct_initials',
942 'name': 'pohead_shipto_cntct_id_cntct_active',
946 'name': 'pohead_shipto_cntct_id_cntct_phone',
950 'name': 'pohead_shipto_cntct_id_cntct_phone2',
954 'name': 'pohead_shipto_cntct_id_cntct_fax',
958 'name': 'pohead_shipto_cntct_id_cntct_email',
962 'name': 'pohead_shipto_cntct_id_cntct_webaddr',
966 'name': 'pohead_shipto_cntct_id_cntct_notes',
970 'name': 'pohead_shipto_cntct_id_cntct_title',
974 'name': 'pohead_shipto_cntct_id_cntct_number',
978 'name': 'pohead_shipto_cntct_id_cntct_middle',
982 'name': 'pohead_shipto_cntct_id_cntct_suffix',
986 'name': 'pohead_shipto_cntct_id_cntct_owner_username',
990 'name': 'pohead_shipto_cntct_id_cntct_name',
994 'name': 'pohead_cohead_id_cohead_id',
998 'name': 'pohead_cohead_id_cohead_number',
1002 'name': 'pohead_cohead_id_cohead_cust_id',
1006 'name': 'pohead_cohead_id_cohead_custponumber',
1010 'name': 'pohead_cohead_id_cohead_type',
1014 'name': 'pohead_cohead_id_cohead_orderdate',
1018 'name': 'pohead_cohead_id_cohead_warehous_id',
1022 'name': 'pohead_cohead_id_cohead_shipto_id',
1026 'name': 'pohead_cohead_id_cohead_shiptoname',
1030 'name': 'pohead_cohead_id_cohead_shiptoaddress1',
1034 'name': 'pohead_cohead_id_cohead_shiptoaddress2',
1038 'name': 'pohead_cohead_id_cohead_shiptoaddress3',
1042 'name': 'pohead_cohead_id_cohead_shiptoaddress4',
1046 'name': 'pohead_cohead_id_cohead_shiptoaddress5',
1050 'name': 'pohead_cohead_id_cohead_salesrep_id',
1054 'name': 'pohead_cohead_id_cohead_terms_id',
1058 'name': 'pohead_cohead_id_cohead_origin',
1062 'name': 'pohead_cohead_id_cohead_fob',
1066 'name': 'pohead_cohead_id_cohead_shipvia',
1070 'name': 'pohead_cohead_id_cohead_shiptocity',
1074 'name': 'pohead_cohead_id_cohead_shiptostate',
1078 'name': 'pohead_cohead_id_cohead_shiptozipcode',
1082 'name': 'pohead_cohead_id_cohead_freight',
1086 'name': 'pohead_cohead_id_cohead_misc',
1090 'name': 'pohead_cohead_id_cohead_imported',
1094 'name': 'pohead_cohead_id_cohead_ordercomments',
1098 'name': 'pohead_cohead_id_cohead_shipcomments',
1102 'name': 'pohead_cohead_id_cohead_shiptophone',
1106 'name': 'pohead_cohead_id_cohead_shipchrg_id',
1110 'name': 'pohead_cohead_id_cohead_shipform_id',
1114 'name': 'pohead_cohead_id_cohead_billtoname',
1118 'name': 'pohead_cohead_id_cohead_billtoaddress1',
1122 'name': 'pohead_cohead_id_cohead_billtoaddress2',
1126 'name': 'pohead_cohead_id_cohead_billtoaddress3',
1130 'name': 'pohead_cohead_id_cohead_billtocity',
1134 'name': 'pohead_cohead_id_cohead_billtostate',
1138 'name': 'pohead_cohead_id_cohead_billtozipcode',
1142 'name': 'pohead_cohead_id_cohead_misc_accnt_id',
1146 'name': 'pohead_cohead_id_cohead_misc_accnt_id',
1150 'name': 'pohead_cohead_id_cohead_misc_descrip',
1154 'name': 'pohead_cohead_id_cohead_commission',
1158 'name': 'pohead_cohead_id_cohead_miscdate',
1162 'name': 'pohead_cohead_id_cohead_holdtype',
1166 'name': 'pohead_cohead_id_cohead_packdate',
1170 'name': 'pohead_cohead_id_cohead_prj_id',
1174 'name': 'pohead_cohead_id_cohead_wasquote',
1178 'name': 'pohead_cohead_id_cohead_lastupdated',
1182 'name': 'pohead_cohead_id_cohead_shipcomplete',
1186 'name': 'pohead_cohead_id_cohead_created',
1190 'name': 'pohead_cohead_id_cohead_creator',
1194 'name': 'pohead_cohead_id_cohead_quote_number',
1198 'name': 'pohead_cohead_id_cohead_billtocountry',
1202 'name': 'pohead_cohead_id_cohead_shiptocountry',
1206 'name': 'pohead_cohead_id_cohead_curr_id',
1210 'name': 'pohead_cohead_id_cohead_calcfreight',
1214 'name': 'pohead_cohead_id_cohead_shipto_cntct_id',
1218 'name': 'pohead_cohead_id_cohead_shipto_cntct_honorific',
1222 'name': 'pohead_cohead_id_cohead_shipto_cntct_first_name',
1226 'name': 'pohead_cohead_id_cohead_shipto_cntct_middle',
1230 'name': 'pohead_cohead_id_cohead_shipto_cntct_last_name',
1234 'name': 'pohead_cohead_id_cohead_shipto_cntct_suffix',
1238 'name': 'pohead_cohead_id_cohead_shipto_cntct_phone',
1242 'name': 'pohead_cohead_id_cohead_shipto_cntct_title',
1246 'name': 'pohead_cohead_id_cohead_shipto_cntct_fax',
1250 'name': 'pohead_cohead_id_cohead_shipto_cntct_email',
1254 'name': 'pohead_cohead_id_cohead_billto_cntct_id',
1258 'name': 'pohead_cohead_id_cohead_billto_cntct_honorific',
1262 'name': 'pohead_cohead_id_cohead_billto_cntct_first_name',
1266 'name': 'pohead_cohead_id_cohead_billto_cntct_middle',
1270 'name': 'pohead_cohead_id_cohead_billto_cntct_last_name',
1274 'name': 'pohead_cohead_id_cohead_billto_cntct_suffix',
1278 'name': 'pohead_cohead_id_cohead_billto_cntct_phone',
1282 'name': 'pohead_cohead_id_cohead_billto_cntct_title',
1286 'name': 'pohead_cohead_id_cohead_billto_cntct_fax',
1290 'name': 'pohead_cohead_id_cohead_billto_cntct_email',
1294 'name': 'pohead_cohead_id_cohead_taxzone_id',
1298 'name': 'pohead_cohead_id_cohead_taxtype_id',
1302 'name': 'pohead_cohead_id_cohead_ophead_id',
1306 'name': 'pohead_cohead_id_cohead_status',
1310 'name': 'pohead_cohead_id_cohead_targetdate',
1314 'name': 'pohead_cohead_id_cohead_location_src',
1321 xtype: 'PagingToolbar',
1325 displayMsg : "Displaying pohead{0} - {1} of {2}",
1326 emptyMsg : "No pohead found"
1336 render : function (_self)
1338 _this.status = _self;
1340 select : function (combo, record, index)
1343 _this.grid.footer.onClick('first');
1347 displayField : 'fname',
1349 fieldLabel : 'Status',
1350 hiddenName : 'cm_status',
1353 name : 'cm_status_name',
1354 triggerAction : 'all',
1356 valueField : 'ftype',
1359 xtype: 'SimpleStore',
1364 [ 'U', "Unreleased"]
1366 fields : [ 'ftype', 'fname']
1373 specialkey : function (_self, e)
1375 _this.grid.footer.onClick('first');
1377 render : function (_self)
1379 _this.searchBox = _self;
1387 click : function (_self, e)
1389 _this.grid.footer.onClick('first');
1393 icon : rootURL + '/Pman/templates/images/search.gif'
1399 click : function (_self, e)
1401 _this.searchBox.setValue('');
1404 _this.grid.footer.onClick('first');
1408 icon : rootURL + '/Pman/templates/images/edit-clear.gif'
1421 Pman.Dialog.XtuplePurchaseOrderNew.show( {} , function(v) {
1422 Pman.Dialog.XtuplePurchaseOrder.show(v , function() {
1423 _this.grid.footer.onClick('first');
1428 cls : 'x-btn-text-icon',
1430 icon : Roo.rootURL + 'images/default/dd/drop-add.gif'
1442 var c = _this.grid.getSelectionModel().getSelectedCell();
1445 Roo.MessageBox.alert('Error','Select a row');
1449 var r = _this.grid.ds.getAt(c[0]);
1451 Pman.Dialog.XtuplePurchaseOrder.show( { pohead_id : r.data.pohead_id }, function() {
1452 _this.grid.footer.onClick('refresh');
1456 cls : 'x-btn-text-icon',
1458 icon : Roo.rootURL + 'images/default/tree/leaf.gif'
1468 click : function (_self, e)
1470 var c = _this.grid.selModel.getSelectedCell();
1472 Roo.MessageBox.alert("Error", "Select a row");
1476 var sel = _this.grid.ds.getAt(c[0]);
1478 var print = function(){
1480 template: 'Purchase-Order',
1481 filename : 'Purchase-Order-' + sel.data.pohead_number +
1482 '-' + (new Date()).format('Y-m-d'),
1483 'param[0]': "pohead_id:number=" + sel.data.pohead_id
1487 url : baseURL + '/Xtuple/Print',
1492 Roo.MessageBox.alert("Notice", "Report will download shortly");
1497 if(!sel.data.pohead_printed){
1499 url : baseURL + '/Roo/pohead',
1503 pohead_id : sel.data.pohead_id,
1506 success : function() {
1518 cls : 'x-btn-text-icon',
1520 icon : rootURL + '/Pman/templates/images/pdf.gif'
1529 cls : 'x-btn-text-icon',
1530 text : "Change Status",
1531 icon : Roo.rootURL + 'images/default/tree/leaf.gif',
1540 click : function (_self, e)
1542 var c = _this.grid.selModel.getSelectedCell();
1544 Roo.MessageBox.alert("Error", "Select a row");
1548 var sel = _this.grid.ds.getAt(c[0]);
1550 if (sel.data.pohead_status == 'C') {
1551 Roo.MessageBox.alert("Error", "Purchase order is already closed");
1556 url : baseURL + '/Roo/pohead',
1560 pohead_id : sel.data.pohead_id,
1563 success : function() {
1564 _this.grid.footer.onClick('refresh');
1571 text : "Close Selected",
1572 icon : Roo.rootURL + 'images/default/tree/leaf.gif'
1578 click : function (_self, e)
1580 var c = _this.grid.selModel.getSelectedCell();
1582 Roo.MessageBox.alert("Error", "Select a row");
1586 var sel = _this.grid.ds.getAt(c[0]);
1588 if (sel.data.pohead_status != 'O') {
1589 Roo.MessageBox.alert("Error", "Purchase order is not Open");
1594 url : baseURL + '/Roo/pohead',
1595 mask : 'Unreleasing',
1598 pohead_id : sel.data.pohead_id,
1601 success : function() {
1602 _this.grid.footer.onClick('refresh');
1609 text : "Unrelease Selected",
1610 icon : Roo.rootURL + 'images/default/tree/leaf.gif'
1616 click : function (_self, e)
1618 var c = _this.grid.selModel.getSelectedCell();
1620 Roo.MessageBox.alert("Error", "Select a row");
1624 var sel = _this.grid.ds.getAt(c[0]);
1626 if (sel.data.pohead_status == 'O') {
1627 Roo.MessageBox.alert("Error", "Purchase order is already Open");
1632 url : baseURL + '/Roo/pohead',
1636 pohead_id : sel.data.pohead_id,
1639 success : function() {
1640 _this.grid.footer.onClick('refresh');
1648 icon : Roo.rootURL + 'images/default/tree/leaf.gif'
1660 text : "Report Since"
1666 render : function (_self)
1668 _this.reportSince = _self;
1670 this.setValue((new Date()).add(Date.MONTH, -1)) ; //.format('Y-m-d');
1680 cls : 'x-btn-text-icon',
1682 icon : rootURL + '/Pman/templates/images/spreadsheet.gif',
1690 text : "AP Aging Report",
1699 click : function (_self, e)
1701 var dt = (new Date()).format('Y-m-d');
1704 '_group' : 'apAging',
1707 'relDate:text' : dt,
1708 'useDocDate:text' : 'TRUE',
1712 var c = _this.grid.getSelectionModel().getSelectedCell();
1715 var s = _this.grid.ds.getAt(c[0]);
1717 if(s.data.pohead_vend_id > 0){
1718 params['vend_id:number'] = s.data.pohead_vend_id;
1723 new Pman.Download({
\r
1724 url : baseURL + '/Roo/Metasql',
\r
1728 Roo.MessageBox.alert("Notice", "Report will download shortly");
\r
1738 click : function (_self, e)
1742 template: 'APAging',
1743 filename : 'ARAging-' + (new Date()).format('Y-m-d'),
1744 'param[0]': "relDate:string='" + (new Date()).format('Y-m-d') + "'",
1745 'param[1]': "useDocDate:number=1"
1748 var c = _this.grid.getSelectionModel().getSelectedCell();
1751 var s = _this.grid.ds.getAt(c[0]);
1753 if(s.data.pohead_vend_id > 0){
1754 params['param[2]'] = 'vend_id:number=' + s.data.pohead_vend_id;
1760 url : baseURL + '/Xtuple/Print',
1764 Roo.MessageBox.alert("Notice", "Report will download shortly");
1775 text : "Goods Reciept Report",
1784 click : function (_self, e)
1786 var dt = Date.parseDate( _this.reportSince.getValue(), 'Y-m-d');
1789 '_group' : 'recvgrp',
1790 '_name' : 'byorder',
1792 'startDate:text' : dt.format('Y-m-d'),
1793 'endDate:text' : dt.add(Date.MONTH,1).format('Y-m-d'),
1798 new Pman.Download({
\r
1799 url : baseURL + '/Roo/Metasql',
\r
1803 Roo.MessageBox.alert("Notice", "Report will download shortly");
\r
1807 text : "For 1 month"
1813 click : function (_self, e)
1815 var dt = Date.parseDate( _this.reportSince.getValue(), 'Y-m-d');
1818 '_group' : 'recvgrp',
1819 '_name' : 'byorder',
1821 'startDate:text' : dt.format('Y-m-d'),
1822 'endDate:text' : dt.add(Date.YEAR,1).format('Y-m-d'),
1827 new Pman.Download({
\r
1828 url : baseURL + '/Roo/Metasql',
\r
1832 Roo.MessageBox.alert("Notice", "Report will download shortly");
\r
1848 xtype: 'ColumnModel',
1850 dataIndex : 'pohead_number',
1854 renderer : function(v,x,r) {
1857 if (vv.indexOf(',') > -1) {
1858 vv = vv.split(',').shift();
1861 if (vv.match(/^NSPO-/)) {
1862 vv = vv.replace(/^NSPO-/, '');
1866 return String.format('<i>'+ nn +'</i><b qtip="{1}">{0}</b> {2}', vv,v, r.data.pohead_comments );
1872 xtype: 'ColumnModel',
1874 dataIndex : 'pohead_orderdate',
1878 renderer : function(v) { return String.format('{0}', v ? v.format('d/M/Y') : ''); }
1881 xtype: 'ColumnModel',
1883 dataIndex : 'pohead_vend_id_vend_name',
1887 renderer : function(v) { return String.format('{0}', v); }
1890 xtype: 'ColumnModel',
1892 dataIndex : 'pohead_curr_id_curr_abbr',
1893 header : 'Currency',
1895 renderer : function(v) { return String.format('{0}', v); }
1898 xtype: 'ColumnModel',
1901 dataIndex : 'pohead_val',
1902 header : 'PO value',
1904 renderer : function(v,x,r) {
1906 var f = (Math.round(v*100) != Math.round(r.data.pohead_vouchered*100)) ? '<span style="color:red;font-weight:bold">{0}</span>' : '{0}';
1907 return String.format(f, v ? Roo.util.Format.usMoney( v) : '' );
1912 xtype: 'ColumnModel',
1915 dataIndex : 'pohead_vouchered',
1916 header : 'Vouchered',
1918 renderer : function(v,x,r) {
1925 if(Math.round(v*100) != Math.round(r.data.pohead_paid*100)){
1926 style = 'color:red;font-weight:bold';
1929 if(Math.round(v*100) != Math.round(r.data.pohead_val*100)){
1930 f = '<span style="{0}">{1}</span>' + '<img class="x-grid-check-icon" src="' + Roo.BLANK_IMAGE_URL + '"/>'
1933 return String.format(f, style, v * 1 ? Roo.util.Format.usMoney(v) : '' );
1937 xtype: 'ColumnModel',
1940 dataIndex : 'pohead_paid',
1943 renderer : function(v) { return v ? Roo.util.Format.usMoney( v) : ''; }
1946 xtype: 'ColumnModel',
1949 dataIndex : 'landed_cost',
1952 renderer : function(v,x,r) {
1953 if (r.data.landed_missing * 1) {
1954 return v ? ('<b style="color:red">' + Roo.util.Format.usMoney( v) + '</b>') : '';
1957 return v ? Roo.util.Format.usMoney( v) : '';
1961 xtype: 'ColumnModel',
1964 dataIndex : 'pohead_qty',
1965 header : 'Order Qty',
1967 renderer : function(v) { return String.format('{0}', v ? (1*v).toFixed(0) : ''); }
1970 xtype: 'ColumnModel',
1973 dataIndex : 'pohead_qty_in_transit',
1974 header : 'In Transit',
1976 renderer : function(v,x,r) {
1977 var vv = v - (1*r.data.pohead_qty_transfered_unposted) -
1978 (1*r.data.pohead_qty_transfered) ;
1979 return String.format('{0}',vv ? (1*vv).toFixed(0) : '');
1984 xtype: 'ColumnModel',
1987 dataIndex : 'pohead_qty_recv',
1988 header : 'Recieved',
1990 renderer : function(v,x,r) {
1992 // total recieved = recv + recv_transfered - intransit?
1994 // old style = 0 in transit
1995 // all delivered direct to warehouse
1998 // new style = 100 in transit
1999 // it will record 100 in transit, and 100 recieved
2002 // recv 610,unposted = 0 , transfer 610, in transit 610
2004 var recv = (1*r.data.pohead_qty_recv) +
2005 (1*r.data.pohead_qty_transfered_unposted) +
2006 (1*r.data.pohead_qty_transfered) -
2007 (1*r.data.pohead_qty_in_transit) ;
2010 if(r.data.pohead_qty_transfered_unposted * 1 > 0){
2011 return String.format('<b style="color:red" qtip="{1} are Unposted">{0}</b>', recv ? (1*recv).toFixed(0) : '',
2012 r.data.pohead_qty_transfered_unposted);
2016 if(recv != r.data.pohead_qty){
2017 format = '<span style="color:red">{0}</span>';
2020 return String.format(format, recv ? (1*recv).toFixed(0) : '');
2028 xtype: 'NestedLayoutPanel',
2031 fitContainer : true,
2035 xtype: 'BorderLayout',
2042 activate : function() {
2043 _this.rgpanel = this;
2045 //_this.rggrid.ds.load({});
2050 fitContainer : true,
2053 tableName : 'recvgrp',
2061 _this.rggrid = this;
2062 //_this.dialog = Pman.Dialog.FILL_IN
2063 if (_this.rgpanel.active) {
2067 rowdblclick : function (_self, rowIndex, e)
2069 var s = _this.rggrid.ds.getAt(rowIndex);
2071 Pman.Dialog.XtupleRecvGrp.show( {
2072 recvgrp_id : s.data.recvgrp_id
2075 _this.grid.footer.onClick('refresh');
2078 rowclick : function (_self, rowIndex, e)
2080 (function() { _this.rgrid.footer.onClick('first');}).defer(100);
2083 autoExpandColumn : 'recvgrp_number',
2089 beforeload : function (_self, options)
2091 if (!_this.grid || !_this.grid.selModel.getSelectedCell()) {
2094 _this.rgrid.ds.removeAll();
2098 var c = _this.grid.selModel.getSelectedCell();
2100 var r = _this.grid.ds.getAt(c[0]);
2102 options.params = options.params || {};
2103 options.params.recvgrp_pohead_id = r.data.pohead_id;
2106 load : function (_self, records, options)
2108 _this.rgrid.footer.onClick('first');
2112 sortInfo : { field : 'recvgrp_id', direction: 'ASC' },
2117 url : baseURL + '/Roo/recvgrp.php'
2120 xtype: 'JsonReader',
2122 totalProperty : 'total',
2131 'name': 'recv_order_type',
2135 'name': 'recv_order_number',
2139 'name': 'recv_orderitem_id',
2143 'name': 'recv_agent_username',
2147 'name': 'recv_itemsite_id',
2151 'name': 'recv_vend_id',
2155 'name': 'recv_vend_item_number',
2159 'name': 'recv_vend_item_descrip',
2163 'name': 'recv_vend_uom',
2167 'name': 'recv_purchcost',
2171 'name': 'recv_purchcost_curr_id',
2175 'name': 'recv_duedate',
2177 'dateFormat': 'Y-m-d'
2184 'name': 'recv_recvcost',
2188 'name': 'recv_recvcost_curr_id',
2192 'name': 'recv_freight',
2196 'name': 'recv_freight_curr_id',
2200 'name': 'recv_date',
2202 'dateFormat': 'Y-m-d'
2205 'name': 'recv_value',
2209 'name': 'recv_posted',
2213 'name': 'recv_invoiced',
2217 'name': 'recv_vohead_id',
2221 'name': 'recv_voitem_id',
2225 'name': 'recv_trans_usr_name',
2229 'name': 'recv_notes',
2233 'name': 'recv_gldistdate',
2235 'dateFormat': 'Y-m-d'
2238 'name': 'recv_splitfrom_id',
2242 'name': 'recv_rlsd_duedate',
2244 'dateFormat': 'Y-m-d'
2247 'name': 'recv_voitem_id_voitem_id',
2251 'name': 'recv_voitem_id_voitem_vohead_id',
2255 'name': 'recv_voitem_id_voitem_poitem_id',
2259 'name': 'recv_voitem_id_voitem_close',
2263 'name': 'recv_voitem_id_voitem_qty',
2267 'name': 'recv_voitem_id_voitem_freight',
2271 'name': 'recv_voitem_id_voitem_taxtype_id',
2275 'name': 'recv_vohead_id_vohead_id',
2279 'name': 'recv_vohead_id_vohead_number',
2283 'name': 'recv_vohead_id_vohead_pohead_id',
2287 'name': 'recv_vohead_id_vohead_posted',
2291 'name': 'recv_vohead_id_vohead_duedate',
2295 'name': 'recv_vohead_id_vohead_invcnumber',
2299 'name': 'recv_vohead_id_vohead_amount',
2303 'name': 'recv_vohead_id_vohead_docdate',
2307 'name': 'recv_vohead_id_vohead_1099',
2311 'name': 'recv_vohead_id_vohead_distdate',
2315 'name': 'recv_vohead_id_vohead_reference',
2319 'name': 'recv_vohead_id_vohead_terms_id',
2323 'name': 'recv_vohead_id_vohead_vend_id',
2327 'name': 'recv_vohead_id_vohead_curr_id',
2331 'name': 'recv_vohead_id_vohead_adjtaxtype_id',
2335 'name': 'recv_vohead_id_vohead_freighttaxtype_id',
2339 'name': 'recv_vohead_id_vohead_gldistdate',
2343 'name': 'recv_vohead_id_vohead_misc',
2347 'name': 'recv_vohead_id_vohead_taxzone_id',
2351 'name': 'recv_vohead_id_vohead_taxtype_id',
2355 'name': 'recv_vohead_id_vohead_notes',
2359 'name': 'recv_vend_id_vend_id',
2363 'name': 'recv_vend_id_vend_name',
2367 'name': 'recv_vend_id_vend_lastpurchdate',
2371 'name': 'recv_vend_id_vend_active',
2375 'name': 'recv_vend_id_vend_po',
2379 'name': 'recv_vend_id_vend_comments',
2383 'name': 'recv_vend_id_vend_pocomments',
2387 'name': 'recv_vend_id_vend_number',
2391 'name': 'recv_vend_id_vend_1099',
2395 'name': 'recv_vend_id_vend_exported',
2399 'name': 'recv_vend_id_vend_fobsource',
2403 'name': 'recv_vend_id_vend_fob',
2407 'name': 'recv_vend_id_vend_terms_id',
2411 'name': 'recv_vend_id_vend_shipvia',
2415 'name': 'recv_vend_id_vend_vendtype_id',
2419 'name': 'recv_vend_id_vend_qualified',
2423 'name': 'recv_vend_id_vend_ediemail',
2427 'name': 'recv_vend_id_vend_ediemailbody',
2431 'name': 'recv_vend_id_vend_edisubject',
2435 'name': 'recv_vend_id_vend_edifilename',
2439 'name': 'recv_vend_id_vend_accntnum',
2443 'name': 'recv_vend_id_vend_emailpodelivery',
2447 'name': 'recv_vend_id_vend_restrictpurch',
2451 'name': 'recv_vend_id_vend_edicc',
2455 'name': 'recv_vend_id_vend_curr_id',
2459 'name': 'recv_vend_id_vend_cntct1_id',
2463 'name': 'recv_vend_id_vend_cntct2_id',
2467 'name': 'recv_vend_id_vend_addr_id',
2471 'name': 'recv_vend_id_vend_match',
2475 'name': 'recv_vend_id_vend_ach_enabled',
2479 'name': 'recv_vend_id_vend_ach_accnttype',
2483 'name': 'recv_vend_id_vend_ach_use_vendinfo',
2487 'name': 'recv_vend_id_vend_ach_indiv_number',
2491 'name': 'recv_vend_id_vend_ach_indiv_name',
2495 'name': 'recv_vend_id_vend_ediemailhtml',
2499 'name': 'recv_vend_id_vend_ach_routingnumber',
2503 'name': 'recv_vend_id_vend_ach_accntnumber',
2507 'name': 'recv_vend_id_vend_taxzone_id',
2511 'name': 'recv_splitfrom_id_recv_id',
2515 'name': 'recv_splitfrom_id_recv_order_type',
2519 'name': 'recv_splitfrom_id_recv_order_number',
2523 'name': 'recv_splitfrom_id_recv_orderitem_id',
2527 'name': 'recv_splitfrom_id_recv_agent_username',
2531 'name': 'recv_splitfrom_id_recv_itemsite_id',
2535 'name': 'recv_splitfrom_id_recv_vend_id',
2539 'name': 'recv_splitfrom_id_recv_vend_item_number',
2543 'name': 'recv_splitfrom_id_recv_vend_item_descrip',
2547 'name': 'recv_splitfrom_id_recv_vend_uom',
2551 'name': 'recv_splitfrom_id_recv_purchcost',
2555 'name': 'recv_splitfrom_id_recv_purchcost_curr_id',
2559 'name': 'recv_splitfrom_id_recv_duedate',
2563 'name': 'recv_splitfrom_id_recv_qty',
2567 'name': 'recv_splitfrom_id_recv_recvcost',
2571 'name': 'recv_splitfrom_id_recv_recvcost_curr_id',
2575 'name': 'recv_splitfrom_id_recv_freight',
2579 'name': 'recv_splitfrom_id_recv_freight_curr_id',
2583 'name': 'recv_splitfrom_id_recv_date',
2587 'name': 'recv_splitfrom_id_recv_value',
2591 'name': 'recv_splitfrom_id_recv_posted',
2595 'name': 'recv_splitfrom_id_recv_invoiced',
2599 'name': 'recv_splitfrom_id_recv_vohead_id',
2603 'name': 'recv_splitfrom_id_recv_voitem_id',
2607 'name': 'recv_splitfrom_id_recv_trans_usr_name',
2611 'name': 'recv_splitfrom_id_recv_notes',
2615 'name': 'recv_splitfrom_id_recv_gldistdate',
2619 'name': 'recv_splitfrom_id_recv_splitfrom_id',
2623 'name': 'recv_splitfrom_id_recv_rlsd_duedate',
2627 'name': 'recv_recvcost_curr_id_curr_id',
2631 'name': 'recv_recvcost_curr_id_curr_base',
2635 'name': 'recv_recvcost_curr_id_curr_name',
2639 'name': 'recv_recvcost_curr_id_curr_symbol',
2643 'name': 'recv_recvcost_curr_id_curr_abbr',
2647 'name': 'recv_purchcost_curr_id_curr_id',
2651 'name': 'recv_purchcost_curr_id_curr_base',
2655 'name': 'recv_purchcost_curr_id_curr_name',
2659 'name': 'recv_purchcost_curr_id_curr_symbol',
2663 'name': 'recv_purchcost_curr_id_curr_abbr',
2667 'name': 'recv_itemsite_id_itemsite_id',
2671 'name': 'recv_itemsite_id_itemsite_item_id',
2675 'name': 'recv_itemsite_id_itemsite_warehous_id',
2679 'name': 'recv_itemsite_id_itemsite_qtyonhand',
2683 'name': 'recv_itemsite_id_itemsite_reorderlevel',
2687 'name': 'recv_itemsite_id_itemsite_ordertoqty',
2691 'name': 'recv_itemsite_id_itemsite_cyclecountfreq',
2695 'name': 'recv_itemsite_id_itemsite_datelastcount',
2699 'name': 'recv_itemsite_id_itemsite_datelastused',
2703 'name': 'recv_itemsite_id_itemsite_loccntrl',
2707 'name': 'recv_itemsite_id_itemsite_safetystock',
2711 'name': 'recv_itemsite_id_itemsite_minordqty',
2715 'name': 'recv_itemsite_id_itemsite_multordqty',
2719 'name': 'recv_itemsite_id_itemsite_leadtime',
2723 'name': 'recv_itemsite_id_itemsite_abcclass',
2727 'name': 'recv_itemsite_id_itemsite_issuemethod',
2731 'name': 'recv_itemsite_id_itemsite_controlmethod',
2735 'name': 'recv_itemsite_id_itemsite_active',
2739 'name': 'recv_itemsite_id_itemsite_plancode_id',
2743 'name': 'recv_itemsite_id_itemsite_costcat_id',
2747 'name': 'recv_itemsite_id_itemsite_eventfence',
2751 'name': 'recv_itemsite_id_itemsite_sold',
2755 'name': 'recv_itemsite_id_itemsite_stocked',
2759 'name': 'recv_itemsite_id_itemsite_freeze',
2763 'name': 'recv_itemsite_id_itemsite_location_id',
2767 'name': 'recv_itemsite_id_itemsite_useparams',
2771 'name': 'recv_itemsite_id_itemsite_useparamsmanual',
2775 'name': 'recv_itemsite_id_itemsite_soldranking',
2779 'name': 'recv_itemsite_id_itemsite_createpr',
2783 'name': 'recv_itemsite_id_itemsite_location',
2787 'name': 'recv_itemsite_id_itemsite_location_comments',
2791 'name': 'recv_itemsite_id_itemsite_notes',
2795 'name': 'recv_itemsite_id_itemsite_perishable',
2799 'name': 'recv_itemsite_id_itemsite_nnqoh',
2803 'name': 'recv_itemsite_id_itemsite_autoabcclass',
2807 'name': 'recv_itemsite_id_itemsite_ordergroup',
2811 'name': 'recv_itemsite_id_itemsite_disallowblankwip',
2815 'name': 'recv_itemsite_id_itemsite_maxordqty',
2819 'name': 'recv_itemsite_id_itemsite_mps_timefence',
2823 'name': 'recv_itemsite_id_itemsite_createwo',
2827 'name': 'recv_itemsite_id_itemsite_warrpurc',
2831 'name': 'recv_itemsite_id_itemsite_autoreg',
2835 'name': 'recv_itemsite_id_itemsite_costmethod',
2839 'name': 'recv_itemsite_id_itemsite_value',
2843 'name': 'recv_itemsite_id_itemsite_ordergroup_first',
2847 'name': 'recv_itemsite_id_itemsite_supply_itemsite_id',
2851 'name': 'recv_itemsite_id_itemsite_planning_type',
2855 'name': 'recv_itemsite_id_itemsite_wosupply',
2859 'name': 'recv_itemsite_id_itemsite_posupply',
2863 'name': 'recv_itemsite_id_itemsite_lsseq_id',
2867 'name': 'recv_itemsite_id_itemsite_cosdefault',
2871 'name': 'recv_itemsite_id_itemsite_createsopr',
2875 'name': 'recv_itemsite_id_itemsite_createsopo',
2879 'name': 'recv_itemsite_id_itemsite_dropship',
2883 'name': 'recv_freight_curr_id_curr_id',
2887 'name': 'recv_freight_curr_id_curr_base',
2891 'name': 'recv_freight_curr_id_curr_name',
2895 'name': 'recv_freight_curr_id_curr_symbol',
2899 'name': 'recv_freight_curr_id_curr_abbr',
2913 click : function (_self, e)
2916 var sel = _this.rggrid.selModel.getSelected();
2918 Roo.MessageBox.alert("Error", "Select Item receipt");
2924 Pman.Dialog.XtupleTransfer.show({ createFromRev : sel.data.recvgrp_id },
2926 _this.grid.ds.load({});
2931 cls : 'x-btn-text-icon',
2933 text : "Create Transfer",
2934 icon : Roo.rootURL + 'images/default/dd/drop-add.gif'
2946 var c = _this.grid.selModel.getSelectedCell();
2948 Roo.MessageBox.alert("Error", "Select a purchase order");
2952 var s = _this.grid.ds.getAt(c[0]);
2954 Pman.Dialog.XtupleRecvGrp.show( {
2955 recvgrp_pohead_id : s.data.pohead_id ,
2956 recvgrp_pohead_id_pohead_number : s.data.pohead_number
2958 _this.grid.footer.onClick('refresh');
2962 cls : 'x-btn-text-icon',
2963 text : "Add Receipt",
2964 icon : Roo.rootURL + 'images/default/dd/drop-add.gif'
2970 xtype: 'ColumnModel',
2972 dataIndex : 'recvgrp_number',
2975 renderer : function(v,x,r) {
2978 if (vv.indexOf(',') > -1) {
2979 vv = vv.split(',').shift();
2982 if (vv.match(/^NSPO-/)) {
2983 vv = vv.replace(/^NSPO-/, '');
2987 var format = '<i>'+ nn +'</i><b qtip="{1}">{0}</b>';
2988 if (r.data.recvgrp_void *1) {
2989 format = '<s>' + format + '</s>';
2991 return String.format(format, vv,v);
2997 xtype: 'ColumnModel',
2999 dataIndex : 'recvgrp_location_id_location_name',
3002 renderer : function(v,x,r) {
3004 return String.format('{0}', v);
3010 xtype: 'ColumnModel',
3013 dataIndex : 'recvgrp_date',
3016 renderer : function(v) { return v ? v.format('d/M/Y') : ''; }
3019 xtype: 'ColumnModel',
3022 dataIndex : 'total_landed_cost',
3023 header : 'Landed Cost',
3025 renderer : function(v,x,r) {
3026 return String.format('{1}{0}', v, r.data.base_curr_symbol);
3036 activate : function() {
3037 _this.rpanel = this;
3039 _this.rgrid.footer.onClick('first');
3044 fitContainer : true,
3047 tableName : 'poitem',
3056 //_this.dialog = Pman.Dialog.FILL_IN
3057 if (_this.rpanel.active) {
3058 this.footer.onClick('first');
3062 autoExpandColumn : 'item_number',
3068 beforeload : function (_self, options)
3070 if (!_this.grid || !_this.grid.selModel.getSelectedCell()) {
3074 var c = _this.grid.selModel.getSelectedCell();
3076 var r = _this.grid.ds.getAt(c[0]);
3078 options.params.poitem_pohead_id = r.data.pohead_id;
3080 var rr = _this.rggrid.selModel.getSelected();
3082 options.params.recvgrp_id = 0;
3084 options.params.recvgrp_id = rr.data.recvgrp_id;
3087 options.params._with_item = 1;
3088 options.params.item_type = 'P';
3092 sortInfo : { field : 'recv_order_type', direction: 'ASC' },
3097 url : baseURL + '/Roo/poitem.php'
3100 xtype: 'JsonReader',
3102 totalProperty : 'total',
3111 'name': 'recv_order_type',
3115 'name': 'recv_order_number',
3119 'name': 'recv_orderitem_id',
3123 'name': 'recv_agent_username',
3127 'name': 'recv_itemsite_id',
3131 'name': 'recv_vend_id',
3135 'name': 'recv_vend_item_number',
3139 'name': 'recv_vend_item_descrip',
3143 'name': 'recv_vend_uom',
3147 'name': 'recv_purchcost',
3151 'name': 'recv_purchcost_curr_id',
3155 'name': 'recv_duedate',
3157 'dateFormat': 'Y-m-d'
3164 'name': 'recv_recvcost',
3168 'name': 'recv_recvcost_curr_id',
3172 'name': 'recv_freight',
3176 'name': 'recv_freight_curr_id',
3180 'name': 'recv_date',
3182 'dateFormat': 'Y-m-d'
3185 'name': 'recv_value',
3189 'name': 'recv_posted',
3193 'name': 'recv_invoiced',
3197 'name': 'recv_vohead_id',
3201 'name': 'recv_voitem_id',
3205 'name': 'recv_trans_usr_name',
3209 'name': 'recv_notes',
3213 'name': 'recv_gldistdate',
3215 'dateFormat': 'Y-m-d'
3218 'name': 'recv_splitfrom_id',
3222 'name': 'recv_rlsd_duedate',
3224 'dateFormat': 'Y-m-d'
3227 'name': 'recv_voitem_id_voitem_id',
3231 'name': 'recv_voitem_id_voitem_vohead_id',
3235 'name': 'recv_voitem_id_voitem_poitem_id',
3239 'name': 'recv_voitem_id_voitem_close',
3243 'name': 'recv_voitem_id_voitem_qty',
3247 'name': 'recv_voitem_id_voitem_freight',
3251 'name': 'recv_voitem_id_voitem_taxtype_id',
3255 'name': 'recv_vohead_id_vohead_id',
3259 'name': 'recv_vohead_id_vohead_number',
3263 'name': 'recv_vohead_id_vohead_pohead_id',
3267 'name': 'recv_vohead_id_vohead_posted',
3271 'name': 'recv_vohead_id_vohead_duedate',
3275 'name': 'recv_vohead_id_vohead_invcnumber',
3279 'name': 'recv_vohead_id_vohead_amount',
3283 'name': 'recv_vohead_id_vohead_docdate',
3287 'name': 'recv_vohead_id_vohead_1099',
3291 'name': 'recv_vohead_id_vohead_distdate',
3295 'name': 'recv_vohead_id_vohead_reference',
3299 'name': 'recv_vohead_id_vohead_terms_id',
3303 'name': 'recv_vohead_id_vohead_vend_id',
3307 'name': 'recv_vohead_id_vohead_curr_id',
3311 'name': 'recv_vohead_id_vohead_adjtaxtype_id',
3315 'name': 'recv_vohead_id_vohead_freighttaxtype_id',
3319 'name': 'recv_vohead_id_vohead_gldistdate',
3323 'name': 'recv_vohead_id_vohead_misc',
3327 'name': 'recv_vohead_id_vohead_taxzone_id',
3331 'name': 'recv_vohead_id_vohead_taxtype_id',
3335 'name': 'recv_vohead_id_vohead_notes',
3339 'name': 'recv_vend_id_vend_id',
3343 'name': 'recv_vend_id_vend_name',
3347 'name': 'recv_vend_id_vend_lastpurchdate',
3351 'name': 'recv_vend_id_vend_active',
3355 'name': 'recv_vend_id_vend_po',
3359 'name': 'recv_vend_id_vend_comments',
3363 'name': 'recv_vend_id_vend_pocomments',
3367 'name': 'recv_vend_id_vend_number',
3371 'name': 'recv_vend_id_vend_1099',
3375 'name': 'recv_vend_id_vend_exported',
3379 'name': 'recv_vend_id_vend_fobsource',
3383 'name': 'recv_vend_id_vend_fob',
3387 'name': 'recv_vend_id_vend_terms_id',
3391 'name': 'recv_vend_id_vend_shipvia',
3395 'name': 'recv_vend_id_vend_vendtype_id',
3399 'name': 'recv_vend_id_vend_qualified',
3403 'name': 'recv_vend_id_vend_ediemail',
3407 'name': 'recv_vend_id_vend_ediemailbody',
3411 'name': 'recv_vend_id_vend_edisubject',
3415 'name': 'recv_vend_id_vend_edifilename',
3419 'name': 'recv_vend_id_vend_accntnum',
3423 'name': 'recv_vend_id_vend_emailpodelivery',
3427 'name': 'recv_vend_id_vend_restrictpurch',
3431 'name': 'recv_vend_id_vend_edicc',
3435 'name': 'recv_vend_id_vend_curr_id',
3439 'name': 'recv_vend_id_vend_cntct1_id',
3443 'name': 'recv_vend_id_vend_cntct2_id',
3447 'name': 'recv_vend_id_vend_addr_id',
3451 'name': 'recv_vend_id_vend_match',
3455 'name': 'recv_vend_id_vend_ach_enabled',
3459 'name': 'recv_vend_id_vend_ach_accnttype',
3463 'name': 'recv_vend_id_vend_ach_use_vendinfo',
3467 'name': 'recv_vend_id_vend_ach_indiv_number',
3471 'name': 'recv_vend_id_vend_ach_indiv_name',
3475 'name': 'recv_vend_id_vend_ediemailhtml',
3479 'name': 'recv_vend_id_vend_ach_routingnumber',
3483 'name': 'recv_vend_id_vend_ach_accntnumber',
3487 'name': 'recv_vend_id_vend_taxzone_id',
3491 'name': 'recv_splitfrom_id_recv_id',
3495 'name': 'recv_splitfrom_id_recv_order_type',
3499 'name': 'recv_splitfrom_id_recv_order_number',
3503 'name': 'recv_splitfrom_id_recv_orderitem_id',
3507 'name': 'recv_splitfrom_id_recv_agent_username',
3511 'name': 'recv_splitfrom_id_recv_itemsite_id',
3515 'name': 'recv_splitfrom_id_recv_vend_id',
3519 'name': 'recv_splitfrom_id_recv_vend_item_number',
3523 'name': 'recv_splitfrom_id_recv_vend_item_descrip',
3527 'name': 'recv_splitfrom_id_recv_vend_uom',
3531 'name': 'recv_splitfrom_id_recv_purchcost',
3535 'name': 'recv_splitfrom_id_recv_purchcost_curr_id',
3539 'name': 'recv_splitfrom_id_recv_duedate',
3543 'name': 'recv_splitfrom_id_recv_qty',
3547 'name': 'recv_splitfrom_id_recv_recvcost',
3551 'name': 'recv_splitfrom_id_recv_recvcost_curr_id',
3555 'name': 'recv_splitfrom_id_recv_freight',
3559 'name': 'recv_splitfrom_id_recv_freight_curr_id',
3563 'name': 'recv_splitfrom_id_recv_date',
3567 'name': 'recv_splitfrom_id_recv_value',
3571 'name': 'recv_splitfrom_id_recv_posted',
3575 'name': 'recv_splitfrom_id_recv_invoiced',
3579 'name': 'recv_splitfrom_id_recv_vohead_id',
3583 'name': 'recv_splitfrom_id_recv_voitem_id',
3587 'name': 'recv_splitfrom_id_recv_trans_usr_name',
3591 'name': 'recv_splitfrom_id_recv_notes',
3595 'name': 'recv_splitfrom_id_recv_gldistdate',
3599 'name': 'recv_splitfrom_id_recv_splitfrom_id',
3603 'name': 'recv_splitfrom_id_recv_rlsd_duedate',
3607 'name': 'recv_recvcost_curr_id_curr_id',
3611 'name': 'recv_recvcost_curr_id_curr_base',
3615 'name': 'recv_recvcost_curr_id_curr_name',
3619 'name': 'recv_recvcost_curr_id_curr_symbol',
3623 'name': 'recv_recvcost_curr_id_curr_abbr',
3627 'name': 'recv_purchcost_curr_id_curr_id',
3631 'name': 'recv_purchcost_curr_id_curr_base',
3635 'name': 'recv_purchcost_curr_id_curr_name',
3639 'name': 'recv_purchcost_curr_id_curr_symbol',
3643 'name': 'recv_purchcost_curr_id_curr_abbr',
3647 'name': 'recv_itemsite_id_itemsite_id',
3651 'name': 'recv_itemsite_id_itemsite_item_id',
3655 'name': 'recv_itemsite_id_itemsite_warehous_id',
3659 'name': 'recv_itemsite_id_itemsite_qtyonhand',
3663 'name': 'recv_itemsite_id_itemsite_reorderlevel',
3667 'name': 'recv_itemsite_id_itemsite_ordertoqty',
3671 'name': 'recv_itemsite_id_itemsite_cyclecountfreq',
3675 'name': 'recv_itemsite_id_itemsite_datelastcount',
3679 'name': 'recv_itemsite_id_itemsite_datelastused',
3683 'name': 'recv_itemsite_id_itemsite_loccntrl',
3687 'name': 'recv_itemsite_id_itemsite_safetystock',
3691 'name': 'recv_itemsite_id_itemsite_minordqty',
3695 'name': 'recv_itemsite_id_itemsite_multordqty',
3699 'name': 'recv_itemsite_id_itemsite_leadtime',
3703 'name': 'recv_itemsite_id_itemsite_abcclass',
3707 'name': 'recv_itemsite_id_itemsite_issuemethod',
3711 'name': 'recv_itemsite_id_itemsite_controlmethod',
3715 'name': 'recv_itemsite_id_itemsite_active',
3719 'name': 'recv_itemsite_id_itemsite_plancode_id',
3723 'name': 'recv_itemsite_id_itemsite_costcat_id',
3727 'name': 'recv_itemsite_id_itemsite_eventfence',
3731 'name': 'recv_itemsite_id_itemsite_sold',
3735 'name': 'recv_itemsite_id_itemsite_stocked',
3739 'name': 'recv_itemsite_id_itemsite_freeze',
3743 'name': 'recv_itemsite_id_itemsite_location_id',
3747 'name': 'recv_itemsite_id_itemsite_useparams',
3751 'name': 'recv_itemsite_id_itemsite_useparamsmanual',
3755 'name': 'recv_itemsite_id_itemsite_soldranking',
3759 'name': 'recv_itemsite_id_itemsite_createpr',
3763 'name': 'recv_itemsite_id_itemsite_location',
3767 'name': 'recv_itemsite_id_itemsite_location_comments',
3771 'name': 'recv_itemsite_id_itemsite_notes',
3775 'name': 'recv_itemsite_id_itemsite_perishable',
3779 'name': 'recv_itemsite_id_itemsite_nnqoh',
3783 'name': 'recv_itemsite_id_itemsite_autoabcclass',
3787 'name': 'recv_itemsite_id_itemsite_ordergroup',
3791 'name': 'recv_itemsite_id_itemsite_disallowblankwip',
3795 'name': 'recv_itemsite_id_itemsite_maxordqty',
3799 'name': 'recv_itemsite_id_itemsite_mps_timefence',
3803 'name': 'recv_itemsite_id_itemsite_createwo',
3807 'name': 'recv_itemsite_id_itemsite_warrpurc',
3811 'name': 'recv_itemsite_id_itemsite_autoreg',
3815 'name': 'recv_itemsite_id_itemsite_costmethod',
3819 'name': 'recv_itemsite_id_itemsite_value',
3823 'name': 'recv_itemsite_id_itemsite_ordergroup_first',
3827 'name': 'recv_itemsite_id_itemsite_supply_itemsite_id',
3831 'name': 'recv_itemsite_id_itemsite_planning_type',
3835 'name': 'recv_itemsite_id_itemsite_wosupply',
3839 'name': 'recv_itemsite_id_itemsite_posupply',
3843 'name': 'recv_itemsite_id_itemsite_lsseq_id',
3847 'name': 'recv_itemsite_id_itemsite_cosdefault',
3851 'name': 'recv_itemsite_id_itemsite_createsopr',
3855 'name': 'recv_itemsite_id_itemsite_createsopo',
3859 'name': 'recv_itemsite_id_itemsite_dropship',
3863 'name': 'recv_freight_curr_id_curr_id',
3867 'name': 'recv_freight_curr_id_curr_base',
3871 'name': 'recv_freight_curr_id_curr_name',
3875 'name': 'recv_freight_curr_id_curr_symbol',
3879 'name': 'recv_freight_curr_id_curr_abbr',
3886 xtype: 'PagingToolbar',
3890 emptyMsg : "No recv found",
3895 xtype: 'ColumnModel',
3898 dataIndex : 'item_number',
3901 renderer : function(v) { return String.format('{0}', v); }
3904 xtype: 'ColumnModel',
3907 dataIndex : 'poitem_qty_ordered',
3910 renderer : function(v) { return String.format('{0}', v); }
3913 xtype: 'ColumnModel',
3916 dataIndex : 'r.data.poitem_qty_received',
3917 header : 'Outstanding',
3919 renderer : function(v,x,r) {
3922 var d = r.data.poitem_qty_ordered - ( r.data.poitem_qty_received - r.data.poitem_qty_returned);
3927 return String.format('<b style="color:red">{0}</b>', d);
3931 xtype: 'ColumnModel',
3934 dataIndex : 'recv_qty_in_transit',
3935 header : 'In Transit',
3937 renderer : function(v,x,r) {
3939 // this should show in transit.. (only applicable to
3940 //var rr = _this.rggrid.selModel.getSelected();
3945 // in transit = recieved, but not transfered.
3949 return String.format('{0}', (v*1).toFixed(0));
3951 // no reciept selected..
3952 d = r.data.poitem_qty_received - r.data.poitem_qty_returned ;
3953 d -= (r.data.poitem_qty_transfered_unposted*1 + r.data.poitem_qty_transfered*1) ;
3958 return String.format('{0}', d);
3963 xtype: 'ColumnModel',
3966 dataIndex : 'recv_qty',
3967 header : 'Recieved',
3969 renderer : function(v,x,r) {
3971 var d = parseInt(v);;
3972 var rr = _this.rggrid.selModel.getSelected();
3975 //d = r.data.poitem_qty_received - r.data.poitem_qty_returned;
3976 // real recived amount = the total that has been transfered out
3980 //d = (r.data.poitem_qty_transfered_unposted*1 + r.data.poitem_qty_transfered*1) ;
3981 //var tot_rec = r.data.poitem_qty_received - r.data.poitem_qty_returned;
3982 //if (d < tot_rec) {
3983 // return String.format('<b style="color:red">{0}</b>', d);
3986 //return String.format('{0}', d);
3995 if (rr && rr.data.recvgrp_void *1 ) {
3996 return String.format('<s>{0}</s>', d);
4002 return String.format('{0}', d);
4010 xtype: 'LayoutRegion',
4012 title : "Item Receipts",
4016 xtype: 'LayoutRegion',
4026 xtype: 'LayoutRegion',
4030 xtype: 'LayoutRegion',