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({});
108 rowdblclick : function (_self, rowIndex, e)
112 var r = _this.grid.ds.getAt(rowIndex);
114 Pman.Dialog.XtuplePurchaseOrder.show( { pohead_id : r.data.pohead_id }, function() {
115 _this.grid.footer.onClick('refresh');
119 autoExpandColumn : 'pohead_vend_id_vend_name',
121 trackMouseOver : true,
123 xtype: 'RowSelectionModel',
131 beforeload : function (_self, o)
133 o.params._with_recv = 1;
136 o.params['query[number]'] = _this.searchBox.getValue();
138 // only filter by type if the number is empty..
139 if (!o.params['query[number]'].length) {
140 o.params.pohead_status = _this.status.getValue();
145 load : function (_self, records, options)
148 (function() { _this.rggrid.ds.load({}); }).defer(100);
152 sortInfo : { field : 'pohead_orderdate', direction: 'DESC' },
157 url : baseURL + '/Roo/pohead.php'
162 totalProperty : 'total',
171 'name': 'pohead_status',
175 'name': 'pohead_number',
179 'name': 'pohead_orderdate',
181 'dateFormat': 'Y-m-d'
184 'name': 'pohead_vend_id',
188 'name': 'pohead_fob',
192 'name': 'pohead_shipvia',
196 'name': 'pohead_comments',
200 'name': 'pohead_freight',
204 'name': 'pohead_printed',
208 'name': 'pohead_terms_id',
212 'name': 'pohead_warehous_id',
216 'name': 'pohead_vendaddr_id',
220 'name': 'pohead_agent_username',
224 'name': 'pohead_curr_id',
228 'name': 'pohead_saved',
232 'name': 'pohead_taxzone_id',
236 'name': 'pohead_taxtype_id',
240 'name': 'pohead_dropship',
244 'name': 'pohead_vend_cntct_id',
248 'name': 'pohead_vend_cntct_honorific',
252 'name': 'pohead_vend_cntct_first_name',
256 'name': 'pohead_vend_cntct_middle',
260 'name': 'pohead_vend_cntct_last_name',
264 'name': 'pohead_vend_cntct_suffix',
268 'name': 'pohead_vend_cntct_phone',
272 'name': 'pohead_vend_cntct_title',
276 'name': 'pohead_vend_cntct_fax',
280 'name': 'pohead_vend_cntct_email',
284 'name': 'pohead_vendaddress1',
288 'name': 'pohead_vendaddress2',
292 'name': 'pohead_vendaddress3',
296 'name': 'pohead_vendcity',
300 'name': 'pohead_vendstate',
304 'name': 'pohead_vendzipcode',
308 'name': 'pohead_vendcountry',
312 'name': 'pohead_shipto_cntct_id',
316 'name': 'pohead_shipto_cntct_honorific',
320 'name': 'pohead_shipto_cntct_first_name',
324 'name': 'pohead_shipto_cntct_middle',
328 'name': 'pohead_shipto_cntct_last_name',
332 'name': 'pohead_shipto_cntct_suffix',
336 'name': 'pohead_shipto_cntct_phone',
340 'name': 'pohead_shipto_cntct_title',
344 'name': 'pohead_shipto_cntct_fax',
348 'name': 'pohead_shipto_cntct_email',
352 'name': 'pohead_shiptoddress_id',
356 'name': 'pohead_shiptoaddress1',
360 'name': 'pohead_shiptoaddress2',
364 'name': 'pohead_shiptoaddress3',
368 'name': 'pohead_shiptocity',
372 'name': 'pohead_shiptostate',
376 'name': 'pohead_shiptozipcode',
380 'name': 'pohead_shiptocountry',
384 'name': 'pohead_cohead_id',
388 'name': 'pohead_released',
390 'dateFormat': 'Y-m-d'
393 'name': 'pohead_curr_id_curr_id',
397 'name': 'pohead_curr_id_curr_base',
401 'name': 'pohead_curr_id_curr_name',
405 'name': 'pohead_curr_id_curr_symbol',
409 'name': 'pohead_curr_id_curr_abbr',
413 'name': 'pohead_warehous_id_warehous_id',
417 'name': 'pohead_warehous_id_warehous_code',
421 'name': 'pohead_warehous_id_warehous_descrip',
425 'name': 'pohead_warehous_id_warehous_fob',
429 'name': 'pohead_warehous_id_warehous_active',
433 'name': 'pohead_warehous_id_warehous_counttag_prefix',
437 'name': 'pohead_warehous_id_warehous_counttag_number',
441 'name': 'pohead_warehous_id_warehous_bol_prefix',
445 'name': 'pohead_warehous_id_warehous_bol_number',
449 'name': 'pohead_warehous_id_warehous_shipping',
453 'name': 'pohead_warehous_id_warehous_useslips',
457 'name': 'pohead_warehous_id_warehous_usezones',
461 'name': 'pohead_warehous_id_warehous_aislesize',
465 'name': 'pohead_warehous_id_warehous_aislealpha',
469 'name': 'pohead_warehous_id_warehous_racksize',
473 'name': 'pohead_warehous_id_warehous_rackalpha',
477 'name': 'pohead_warehous_id_warehous_binsize',
481 'name': 'pohead_warehous_id_warehous_binalpha',
485 'name': 'pohead_warehous_id_warehous_locationsize',
489 'name': 'pohead_warehous_id_warehous_locationalpha',
493 'name': 'pohead_warehous_id_warehous_enforcearbl',
497 'name': 'pohead_warehous_id_warehous_default_accnt_id',
501 'name': 'pohead_warehous_id_warehous_shipping_commission',
505 'name': 'pohead_warehous_id_warehous_cntct_id',
509 'name': 'pohead_warehous_id_warehous_addr_id',
513 'name': 'pohead_warehous_id_warehous_transit',
517 'name': 'pohead_warehous_id_warehous_shipform_id',
521 'name': 'pohead_warehous_id_warehous_shipvia_id',
525 'name': 'pohead_warehous_id_warehous_shipcomments',
529 'name': 'pohead_warehous_id_warehous_costcat_id',
533 'name': 'pohead_warehous_id_warehous_costcat_id',
537 'name': 'pohead_warehous_id_warehous_sitetype_id',
541 'name': 'pohead_warehous_id_warehous_taxzone_id',
545 'name': 'pohead_warehous_id_warehous_sequence',
549 'name': 'pohead_vendaddr_id_vendaddr_id',
553 'name': 'pohead_vendaddr_id_vendaddr_vend_id',
557 'name': 'pohead_vendaddr_id_vendaddr_code',
561 'name': 'pohead_vendaddr_id_vendaddr_name',
565 'name': 'pohead_vendaddr_id_vendaddr_comments',
569 'name': 'pohead_vendaddr_id_vendaddr_cntct_id',
573 'name': 'pohead_vendaddr_id_vendaddr_addr_id',
577 'name': 'pohead_vendaddr_id_vendaddr_taxzone_id',
581 'name': 'pohead_vend_id_vend_id',
585 'name': 'pohead_vend_id_vend_name',
589 'name': 'pohead_vend_id_vend_lastpurchdate',
593 'name': 'pohead_vend_id_vend_active',
597 'name': 'pohead_vend_id_vend_po',
601 'name': 'pohead_vend_id_vend_comments',
605 'name': 'pohead_vend_id_vend_pocomments',
609 'name': 'pohead_vend_id_vend_number',
613 'name': 'pohead_vend_id_vend_1099',
617 'name': 'pohead_vend_id_vend_exported',
621 'name': 'pohead_vend_id_vend_fobsource',
625 'name': 'pohead_vend_id_vend_fob',
629 'name': 'pohead_vend_id_vend_terms_id',
633 'name': 'pohead_vend_id_vend_shipvia',
637 'name': 'pohead_vend_id_vend_vendtype_id',
641 'name': 'pohead_vend_id_vend_qualified',
645 'name': 'pohead_vend_id_vend_ediemail',
649 'name': 'pohead_vend_id_vend_ediemailbody',
653 'name': 'pohead_vend_id_vend_edisubject',
657 'name': 'pohead_vend_id_vend_edifilename',
661 'name': 'pohead_vend_id_vend_accntnum',
665 'name': 'pohead_vend_id_vend_emailpodelivery',
669 'name': 'pohead_vend_id_vend_restrictpurch',
673 'name': 'pohead_vend_id_vend_edicc',
677 'name': 'pohead_vend_id_vend_curr_id',
681 'name': 'pohead_vend_id_vend_cntct1_id',
685 'name': 'pohead_vend_id_vend_cntct2_id',
689 'name': 'pohead_vend_id_vend_addr_id',
693 'name': 'pohead_vend_id_vend_match',
697 'name': 'pohead_vend_id_vend_ach_enabled',
701 'name': 'pohead_vend_id_vend_ach_accnttype',
705 'name': 'pohead_vend_id_vend_ach_use_vendinfo',
709 'name': 'pohead_vend_id_vend_ach_indiv_number',
713 'name': 'pohead_vend_id_vend_ach_indiv_name',
717 'name': 'pohead_vend_id_vend_ediemailhtml',
721 'name': 'pohead_vend_id_vend_ach_routingnumber',
725 'name': 'pohead_vend_id_vend_ach_accntnumber',
729 'name': 'pohead_vend_id_vend_taxzone_id',
733 'name': 'pohead_vend_cntct_id_cntct_id',
737 'name': 'pohead_vend_cntct_id_cntct_crmacct_id',
741 'name': 'pohead_vend_cntct_id_cntct_addr_id',
745 'name': 'pohead_vend_cntct_id_cntct_first_name',
749 'name': 'pohead_vend_cntct_id_cntct_last_name',
753 'name': 'pohead_vend_cntct_id_cntct_honorific',
757 'name': 'pohead_vend_cntct_id_cntct_initials',
761 'name': 'pohead_vend_cntct_id_cntct_active',
765 'name': 'pohead_vend_cntct_id_cntct_phone',
769 'name': 'pohead_vend_cntct_id_cntct_phone2',
773 'name': 'pohead_vend_cntct_id_cntct_fax',
777 'name': 'pohead_vend_cntct_id_cntct_email',
781 'name': 'pohead_vend_cntct_id_cntct_webaddr',
785 'name': 'pohead_vend_cntct_id_cntct_notes',
789 'name': 'pohead_vend_cntct_id_cntct_title',
793 'name': 'pohead_vend_cntct_id_cntct_number',
797 'name': 'pohead_vend_cntct_id_cntct_middle',
801 'name': 'pohead_vend_cntct_id_cntct_suffix',
805 'name': 'pohead_vend_cntct_id_cntct_owner_username',
809 'name': 'pohead_vend_cntct_id_cntct_name',
813 'name': 'pohead_terms_id_terms_id',
817 'name': 'pohead_terms_id_terms_code',
821 'name': 'pohead_terms_id_terms_descrip',
825 'name': 'pohead_terms_id_terms_type',
829 'name': 'pohead_terms_id_terms_duedays',
833 'name': 'pohead_terms_id_terms_discdays',
837 'name': 'pohead_terms_id_terms_discprcnt',
841 'name': 'pohead_terms_id_terms_cutoffday',
845 'name': 'pohead_terms_id_terms_ap',
849 'name': 'pohead_terms_id_terms_ar',
853 'name': 'pohead_taxzone_id_taxzone_id',
857 'name': 'pohead_taxzone_id_taxzone_code',
861 'name': 'pohead_taxzone_id_taxzone_descrip',
865 'name': 'pohead_taxtype_id_taxtype_id',
869 'name': 'pohead_taxtype_id_taxtype_name',
873 'name': 'pohead_taxtype_id_taxtype_descrip',
877 'name': 'pohead_taxtype_id_taxtype_sys',
881 'name': 'pohead_shiptoddress_id_addr_id',
885 'name': 'pohead_shiptoddress_id_addr_active',
889 'name': 'pohead_shiptoddress_id_addr_line1',
893 'name': 'pohead_shiptoddress_id_addr_line2',
897 'name': 'pohead_shiptoddress_id_addr_line3',
901 'name': 'pohead_shiptoddress_id_addr_city',
905 'name': 'pohead_shiptoddress_id_addr_state',
909 'name': 'pohead_shiptoddress_id_addr_postalcode',
913 'name': 'pohead_shiptoddress_id_addr_country',
917 'name': 'pohead_shiptoddress_id_addr_notes',
921 'name': 'pohead_shiptoddress_id_addr_number',
925 'name': 'pohead_shipto_cntct_id_cntct_id',
929 'name': 'pohead_shipto_cntct_id_cntct_crmacct_id',
933 'name': 'pohead_shipto_cntct_id_cntct_addr_id',
937 'name': 'pohead_shipto_cntct_id_cntct_first_name',
941 'name': 'pohead_shipto_cntct_id_cntct_last_name',
945 'name': 'pohead_shipto_cntct_id_cntct_honorific',
949 'name': 'pohead_shipto_cntct_id_cntct_initials',
953 'name': 'pohead_shipto_cntct_id_cntct_active',
957 'name': 'pohead_shipto_cntct_id_cntct_phone',
961 'name': 'pohead_shipto_cntct_id_cntct_phone2',
965 'name': 'pohead_shipto_cntct_id_cntct_fax',
969 'name': 'pohead_shipto_cntct_id_cntct_email',
973 'name': 'pohead_shipto_cntct_id_cntct_webaddr',
977 'name': 'pohead_shipto_cntct_id_cntct_notes',
981 'name': 'pohead_shipto_cntct_id_cntct_title',
985 'name': 'pohead_shipto_cntct_id_cntct_number',
989 'name': 'pohead_shipto_cntct_id_cntct_middle',
993 'name': 'pohead_shipto_cntct_id_cntct_suffix',
997 'name': 'pohead_shipto_cntct_id_cntct_owner_username',
1001 'name': 'pohead_shipto_cntct_id_cntct_name',
1005 'name': 'pohead_cohead_id_cohead_id',
1009 'name': 'pohead_cohead_id_cohead_number',
1013 'name': 'pohead_cohead_id_cohead_cust_id',
1017 'name': 'pohead_cohead_id_cohead_custponumber',
1021 'name': 'pohead_cohead_id_cohead_type',
1025 'name': 'pohead_cohead_id_cohead_orderdate',
1029 'name': 'pohead_cohead_id_cohead_warehous_id',
1033 'name': 'pohead_cohead_id_cohead_shipto_id',
1037 'name': 'pohead_cohead_id_cohead_shiptoname',
1041 'name': 'pohead_cohead_id_cohead_shiptoaddress1',
1045 'name': 'pohead_cohead_id_cohead_shiptoaddress2',
1049 'name': 'pohead_cohead_id_cohead_shiptoaddress3',
1053 'name': 'pohead_cohead_id_cohead_shiptoaddress4',
1057 'name': 'pohead_cohead_id_cohead_shiptoaddress5',
1061 'name': 'pohead_cohead_id_cohead_salesrep_id',
1065 'name': 'pohead_cohead_id_cohead_terms_id',
1069 'name': 'pohead_cohead_id_cohead_origin',
1073 'name': 'pohead_cohead_id_cohead_fob',
1077 'name': 'pohead_cohead_id_cohead_shipvia',
1081 'name': 'pohead_cohead_id_cohead_shiptocity',
1085 'name': 'pohead_cohead_id_cohead_shiptostate',
1089 'name': 'pohead_cohead_id_cohead_shiptozipcode',
1093 'name': 'pohead_cohead_id_cohead_freight',
1097 'name': 'pohead_cohead_id_cohead_misc',
1101 'name': 'pohead_cohead_id_cohead_imported',
1105 'name': 'pohead_cohead_id_cohead_ordercomments',
1109 'name': 'pohead_cohead_id_cohead_shipcomments',
1113 'name': 'pohead_cohead_id_cohead_shiptophone',
1117 'name': 'pohead_cohead_id_cohead_shipchrg_id',
1121 'name': 'pohead_cohead_id_cohead_shipform_id',
1125 'name': 'pohead_cohead_id_cohead_billtoname',
1129 'name': 'pohead_cohead_id_cohead_billtoaddress1',
1133 'name': 'pohead_cohead_id_cohead_billtoaddress2',
1137 'name': 'pohead_cohead_id_cohead_billtoaddress3',
1141 'name': 'pohead_cohead_id_cohead_billtocity',
1145 'name': 'pohead_cohead_id_cohead_billtostate',
1149 'name': 'pohead_cohead_id_cohead_billtozipcode',
1153 'name': 'pohead_cohead_id_cohead_misc_accnt_id',
1157 'name': 'pohead_cohead_id_cohead_misc_accnt_id',
1161 'name': 'pohead_cohead_id_cohead_misc_descrip',
1165 'name': 'pohead_cohead_id_cohead_commission',
1169 'name': 'pohead_cohead_id_cohead_miscdate',
1173 'name': 'pohead_cohead_id_cohead_holdtype',
1177 'name': 'pohead_cohead_id_cohead_packdate',
1181 'name': 'pohead_cohead_id_cohead_prj_id',
1185 'name': 'pohead_cohead_id_cohead_wasquote',
1189 'name': 'pohead_cohead_id_cohead_lastupdated',
1193 'name': 'pohead_cohead_id_cohead_shipcomplete',
1197 'name': 'pohead_cohead_id_cohead_created',
1201 'name': 'pohead_cohead_id_cohead_creator',
1205 'name': 'pohead_cohead_id_cohead_quote_number',
1209 'name': 'pohead_cohead_id_cohead_billtocountry',
1213 'name': 'pohead_cohead_id_cohead_shiptocountry',
1217 'name': 'pohead_cohead_id_cohead_curr_id',
1221 'name': 'pohead_cohead_id_cohead_calcfreight',
1225 'name': 'pohead_cohead_id_cohead_shipto_cntct_id',
1229 'name': 'pohead_cohead_id_cohead_shipto_cntct_honorific',
1233 'name': 'pohead_cohead_id_cohead_shipto_cntct_first_name',
1237 'name': 'pohead_cohead_id_cohead_shipto_cntct_middle',
1241 'name': 'pohead_cohead_id_cohead_shipto_cntct_last_name',
1245 'name': 'pohead_cohead_id_cohead_shipto_cntct_suffix',
1249 'name': 'pohead_cohead_id_cohead_shipto_cntct_phone',
1253 'name': 'pohead_cohead_id_cohead_shipto_cntct_title',
1257 'name': 'pohead_cohead_id_cohead_shipto_cntct_fax',
1261 'name': 'pohead_cohead_id_cohead_shipto_cntct_email',
1265 'name': 'pohead_cohead_id_cohead_billto_cntct_id',
1269 'name': 'pohead_cohead_id_cohead_billto_cntct_honorific',
1273 'name': 'pohead_cohead_id_cohead_billto_cntct_first_name',
1277 'name': 'pohead_cohead_id_cohead_billto_cntct_middle',
1281 'name': 'pohead_cohead_id_cohead_billto_cntct_last_name',
1285 'name': 'pohead_cohead_id_cohead_billto_cntct_suffix',
1289 'name': 'pohead_cohead_id_cohead_billto_cntct_phone',
1293 'name': 'pohead_cohead_id_cohead_billto_cntct_title',
1297 'name': 'pohead_cohead_id_cohead_billto_cntct_fax',
1301 'name': 'pohead_cohead_id_cohead_billto_cntct_email',
1305 'name': 'pohead_cohead_id_cohead_taxzone_id',
1309 'name': 'pohead_cohead_id_cohead_taxtype_id',
1313 'name': 'pohead_cohead_id_cohead_ophead_id',
1317 'name': 'pohead_cohead_id_cohead_status',
1321 'name': 'pohead_cohead_id_cohead_targetdate',
1325 'name': 'pohead_cohead_id_cohead_location_src',
1332 xtype: 'PagingToolbar',
1336 displayMsg : "Displaying pohead{0} - {1} of {2}",
1337 emptyMsg : "No pohead found"
1347 render : function (_self)
1349 _this.status = _self;
1351 select : function (combo, record, index)
1354 _this.grid.footer.onClick('first');
1358 displayField : 'fname',
1360 fieldLabel : 'Status',
1361 hiddenName : 'cm_status',
1364 name : 'cm_status_name',
1365 triggerAction : 'all',
1367 valueField : 'ftype',
1370 xtype: 'SimpleStore',
1375 [ 'U', "Unreleased"]
1377 fields : [ 'ftype', 'fname']
1384 specialkey : function (_self, e)
1386 _this.grid.footer.onClick('first');
1388 render : function (_self)
1390 _this.searchBox = _self;
1398 click : function (_self, e)
1400 _this.grid.footer.onClick('first');
1404 icon : rootURL + '/Pman/templates/images/search.gif'
1410 click : function (_self, e)
1412 _this.searchBox.setValue('');
1415 _this.grid.footer.onClick('first');
1419 icon : rootURL + '/Pman/templates/images/edit-clear.gif'
1432 Pman.Dialog.XtuplePurchaseOrderNew.show( {} , function(v) {
1433 Pman.Dialog.XtuplePurchaseOrder.show(v , function() {
1434 _this.grid.footer.onClick('first');
1439 cls : 'x-btn-text-icon',
1441 icon : Roo.rootURL + 'images/default/dd/drop-add.gif'
1451 click : function (_self, e)
1453 var c = _this.grid.selModel.getSelectedCell();
1455 Roo.MessageBox.alert("Error", "Select a row");
1459 var sel = _this.grid.ds.getAt(c[0]);
1461 var print = function(){
1463 template: 'Purchase-Order',
1464 filename : 'Purchase-Order-' + sel.data.pohead_number +
1465 '-' + (new Date()).format('Y-m-d'),
1466 'param[0]': "pohead_id:number=" + sel.data.pohead_id
1470 url : baseURL + '/Xtuple/Print',
1475 Roo.MessageBox.alert("Notice", "Report will download shortly");
1480 if(!sel.data.pohead_printed){
1482 url : baseURL + '/Roo/pohead',
1486 pohead_id : sel.data.pohead_id,
1489 success : function() {
1501 cls : 'x-btn-text-icon',
1503 icon : rootURL + '/Pman/templates/images/pdf.gif'
1512 cls : 'x-btn-text-icon',
1513 text : "Change Status",
1514 icon : Roo.rootURL + 'images/default/tree/leaf.gif',
1523 click : function (_self, e)
1525 var c = _this.grid.selModel.getSelectedCell();
1527 Roo.MessageBox.alert("Error", "Select a row");
1531 var sel = _this.grid.ds.getAt(c[0]);
1533 if (sel.data.pohead_status == 'C') {
1534 Roo.MessageBox.alert("Error", "Purchase order is already closed");
1539 url : baseURL + '/Roo/pohead',
1543 pohead_id : sel.data.pohead_id,
1546 success : function() {
1547 _this.grid.footer.onClick('refresh');
1554 text : "Close Selected",
1555 icon : Roo.rootURL + 'images/default/tree/leaf.gif'
1561 click : function (_self, e)
1563 var c = _this.grid.selModel.getSelectedCell();
1565 Roo.MessageBox.alert("Error", "Select a row");
1569 var sel = _this.grid.ds.getAt(c[0]);
1571 if (sel.data.pohead_status != 'O') {
1572 Roo.MessageBox.alert("Error", "Purchase order is not Open");
1577 url : baseURL + '/Roo/pohead',
1578 mask : 'Unreleasing',
1581 pohead_id : sel.data.pohead_id,
1584 success : function() {
1585 _this.grid.footer.onClick('refresh');
1592 text : "Unrelease Selected",
1593 icon : Roo.rootURL + 'images/default/tree/leaf.gif'
1599 click : function (_self, e)
1601 var c = _this.grid.selModel.getSelectedCell();
1603 Roo.MessageBox.alert("Error", "Select a row");
1607 var sel = _this.grid.ds.getAt(c[0]);
1609 if (sel.data.pohead_status == 'O') {
1610 Roo.MessageBox.alert("Error", "Purchase order is already Open");
1615 url : baseURL + '/Roo/pohead',
1619 pohead_id : sel.data.pohead_id,
1622 success : function() {
1623 _this.grid.footer.onClick('refresh');
1631 icon : Roo.rootURL + 'images/default/tree/leaf.gif'
1643 text : "Report Since"
1649 render : function (_self)
1651 _this.reportSince = _self;
1653 this.setValue((new Date()).add(Date.MONTH, -1)) ; //.format('Y-m-d');
1663 cls : 'x-btn-text-icon',
1665 icon : rootURL + '/Pman/templates/images/spreadsheet.gif',
1673 text : "AP Aging Report",
1682 click : function (_self, e)
1684 var dt = (new Date()).format('Y-m-d');
1687 '_group' : 'apAging',
1690 'relDate:text' : dt,
1691 'useDocDate:text' : 'TRUE',
1695 var c = _this.grid.getSelectionModel().getSelectedCell();
1698 var s = _this.grid.ds.getAt(c[0]);
1700 if(s.data.pohead_vend_id > 0){
1701 params['vend_id:number'] = s.data.pohead_vend_id;
1706 new Pman.Download({
\r
1707 url : baseURL + '/Roo/Metasql',
\r
1711 Roo.MessageBox.alert("Notice", "Report will download shortly");
\r
1721 click : function (_self, e)
1725 template: 'APAging',
1726 filename : 'ARAging-' + (new Date()).format('Y-m-d'),
1727 'param[0]': "relDate:string='" + (new Date()).format('Y-m-d') + "'",
1728 'param[1]': "useDocDate:number=1"
1731 var c = _this.grid.getSelectionModel().getSelectedCell();
1734 var s = _this.grid.ds.getAt(c[0]);
1736 if(s.data.pohead_vend_id > 0){
1737 params['param[2]'] = 'vend_id:number=' + s.data.pohead_vend_id;
1743 url : baseURL + '/Xtuple/Print',
1747 Roo.MessageBox.alert("Notice", "Report will download shortly");
1758 text : "Goods Reciept Report",
1767 click : function (_self, e)
1769 var dt = Date.parseDate( _this.reportSince.getValue(), 'Y-m-d');
1772 '_group' : 'recvgrp',
1773 '_name' : 'byorder',
1775 'startDate:text' : dt.format('Y-m-d'),
1776 'endDate:text' : dt.add(Date.MONTH,1).format('Y-m-d'),
1781 new Pman.Download({
\r
1782 url : baseURL + '/Roo/Metasql',
\r
1786 Roo.MessageBox.alert("Notice", "Report will download shortly");
\r
1790 text : "For 1 month"
1796 click : function (_self, e)
1798 var dt = Date.parseDate( _this.reportSince.getValue(), 'Y-m-d');
1801 '_group' : 'recvgrp',
1802 '_name' : 'byorder',
1804 'startDate:text' : dt.format('Y-m-d'),
1805 'endDate:text' : dt.add(Date.YEAR,1).format('Y-m-d'),
1810 new Pman.Download({
\r
1811 url : baseURL + '/Roo/Metasql',
\r
1815 Roo.MessageBox.alert("Notice", "Report will download shortly");
\r
1831 xtype: 'ColumnModel',
1833 dataIndex : 'pohead_number',
1837 renderer : function(v,x,r) {
1840 if (vv.indexOf(',') > -1) {
1841 vv = vv.split(',').shift();
1844 if (vv.match(/^NSPO-/)) {
1845 vv = vv.replace(/^NSPO-/, '');
1849 return String.format('<i>'+ nn +'</i><b qtip="{1}">{0}</b> {2}', vv,v, r.data.pohead_comments );
1855 xtype: 'ColumnModel',
1857 dataIndex : 'pohead_orderdate',
1861 renderer : function(v) { return String.format('{0}', v ? v.format('d/M/Y') : ''); }
1864 xtype: 'ColumnModel',
1866 dataIndex : 'pohead_vend_id_vend_name',
1870 renderer : function(v) { return String.format('{0}', v); }
1873 xtype: 'ColumnModel',
1875 dataIndex : 'pohead_curr_id_curr_abbr',
1876 header : 'Currency',
1878 renderer : function(v) { return String.format('{0}', v); }
1881 xtype: 'ColumnModel',
1884 dataIndex : 'pohead_val',
1885 header : 'PO value',
1887 renderer : function(v,x,r) {
1889 var f = (Math.round(v*100) != Math.round(r.data.pohead_vouchered*100)) ? '<span style="color:red;font-weight:bold">{0}</span>' : '{0}';
1890 return String.format(f, v ? Roo.util.Format.usMoney( v) : '' );
1895 xtype: 'ColumnModel',
1898 dataIndex : 'pohead_vouchered',
1899 header : 'Vouchered',
1901 renderer : function(v,x,r) {
1904 var f = '<span style="{0}">{1}</span>';
1908 if(Math.round(v*100) != Math.round(r.data.pohead_paid*100)){
1909 style = 'color:red;font-weight:bold';
1912 if(Math.round(v*100) != Math.round(r.data.pohead_val*100)){
1913 f = '<span style="{0}">{1}</span>' + '<img class="x-grid-check-icon" src="' + Roo.BLANK_IMAGE_URL + '"/>'
1916 return String.format(f, style, v * 1 ? Roo.util.Format.usMoney(v) : '' );
1920 xtype: 'ColumnModel',
1923 dataIndex : 'pohead_paid',
1926 renderer : function(v) { return v ? Roo.util.Format.usMoney( v) : ''; }
1929 xtype: 'ColumnModel',
1932 dataIndex : 'landed_cost',
1935 renderer : function(v,x,r) {
1936 if (r.data.landed_missing * 1) {
1937 return v ? ('<b style="color:red">' + Roo.util.Format.usMoney( v) + '</b>') : '';
1940 return v ? Roo.util.Format.usMoney( v) : '';
1944 xtype: 'ColumnModel',
1947 dataIndex : 'pohead_qty',
1948 header : 'Order Qty',
1950 renderer : function(v) { return String.format('{0}', v ? (1*v).toFixed(0) : ''); }
1953 xtype: 'ColumnModel',
1956 dataIndex : 'pohead_qty_in_transit',
1957 header : 'In Transit',
1959 renderer : function(v,x,r) {
1960 var vv = v - (1*r.data.pohead_qty_transfered_unposted) -
1961 (1*r.data.pohead_qty_transfered) ;
1962 return String.format('{0}',vv ? (1*vv).toFixed(0) : '');
1967 xtype: 'ColumnModel',
1970 dataIndex : 'pohead_qty_recv',
1971 header : 'Recieved',
1973 renderer : function(v,x,r) {
1975 // total recieved = recv + recv_transfered - intransit?
1977 // old style = 0 in transit
1978 // all delivered direct to warehouse
1981 // new style = 100 in transit
1982 // it will record 100 in transit, and 100 recieved
1985 // recv 610,unposted = 0 , transfer 610, in transit 610
1987 var recv = (1*r.data.pohead_qty_recv) +
1988 (1*r.data.pohead_qty_transfered_unposted) +
1989 (1*r.data.pohead_qty_transfered) -
1990 (1*r.data.pohead_qty_in_transit) ;
1993 if(r.data.pohead_qty_transfered_unposted * 1 > 0){
1994 return String.format('<b style="color:red" qtip="{1} are Unposted">{0}</b>', recv ? (1*recv).toFixed(0) : '',
1995 r.data.pohead_qty_transfered_unposted);
1999 if(recv != r.data.pohead_qty){
2000 format = '<span style="color:red">{0}</span>';
2003 return String.format(format, recv ? (1*recv).toFixed(0) : '');
2011 xtype: 'NestedLayoutPanel',
2014 fitContainer : true,
2018 xtype: 'BorderLayout',
2025 activate : function() {
2026 _this.rgpanel = this;
2028 //_this.rggrid.ds.load({});
2033 fitContainer : true,
2036 tableName : 'recvgrp',
2044 _this.rggrid = this;
2045 //_this.dialog = Pman.Dialog.FILL_IN
2046 if (_this.rgpanel.active) {
2050 rowdblclick : function (_self, rowIndex, e)
2052 var s = _this.rggrid.ds.getAt(rowIndex);
2054 Pman.Dialog.XtupleRecvGrp.show( {
2055 recvgrp_id : s.data.recvgrp_id
2058 _this.grid.footer.onClick('refresh');
2061 rowclick : function (_self, rowIndex, e)
2063 (function() { _this.rgrid.footer.onClick('first');}).defer(100);
2066 autoExpandColumn : 'recvgrp_number',
2072 beforeload : function (_self, options)
2074 if (!_this.grid || !_this.grid.selModel.getSelected()) {
2077 _this.rgrid.ds.removeAll();
2081 var r = _this.grid.selModel.getSelected();
2084 options.params = options.params || {};
2085 options.params.recvgrp_pohead_id = r.data.pohead_id;
2088 load : function (_self, records, options)
2090 _this.rgrid.footer.onClick('first');
2094 sortInfo : { field : 'recvgrp_id', direction: 'ASC' },
2099 url : baseURL + '/Roo/recvgrp.php'
2102 xtype: 'JsonReader',
2104 totalProperty : 'total',
2113 'name': 'recv_order_type',
2117 'name': 'recv_order_number',
2121 'name': 'recv_orderitem_id',
2125 'name': 'recv_agent_username',
2129 'name': 'recv_itemsite_id',
2133 'name': 'recv_vend_id',
2137 'name': 'recv_vend_item_number',
2141 'name': 'recv_vend_item_descrip',
2145 'name': 'recv_vend_uom',
2149 'name': 'recv_purchcost',
2153 'name': 'recv_purchcost_curr_id',
2157 'name': 'recv_duedate',
2159 'dateFormat': 'Y-m-d'
2166 'name': 'recv_recvcost',
2170 'name': 'recv_recvcost_curr_id',
2174 'name': 'recv_freight',
2178 'name': 'recv_freight_curr_id',
2182 'name': 'recv_date',
2184 'dateFormat': 'Y-m-d'
2187 'name': 'recv_value',
2191 'name': 'recv_posted',
2195 'name': 'recv_invoiced',
2199 'name': 'recv_vohead_id',
2203 'name': 'recv_voitem_id',
2207 'name': 'recv_trans_usr_name',
2211 'name': 'recv_notes',
2215 'name': 'recv_gldistdate',
2217 'dateFormat': 'Y-m-d'
2220 'name': 'recv_splitfrom_id',
2224 'name': 'recv_rlsd_duedate',
2226 'dateFormat': 'Y-m-d'
2229 'name': 'recv_voitem_id_voitem_id',
2233 'name': 'recv_voitem_id_voitem_vohead_id',
2237 'name': 'recv_voitem_id_voitem_poitem_id',
2241 'name': 'recv_voitem_id_voitem_close',
2245 'name': 'recv_voitem_id_voitem_qty',
2249 'name': 'recv_voitem_id_voitem_freight',
2253 'name': 'recv_voitem_id_voitem_taxtype_id',
2257 'name': 'recv_vohead_id_vohead_id',
2261 'name': 'recv_vohead_id_vohead_number',
2265 'name': 'recv_vohead_id_vohead_pohead_id',
2269 'name': 'recv_vohead_id_vohead_posted',
2273 'name': 'recv_vohead_id_vohead_duedate',
2277 'name': 'recv_vohead_id_vohead_invcnumber',
2281 'name': 'recv_vohead_id_vohead_amount',
2285 'name': 'recv_vohead_id_vohead_docdate',
2289 'name': 'recv_vohead_id_vohead_1099',
2293 'name': 'recv_vohead_id_vohead_distdate',
2297 'name': 'recv_vohead_id_vohead_reference',
2301 'name': 'recv_vohead_id_vohead_terms_id',
2305 'name': 'recv_vohead_id_vohead_vend_id',
2309 'name': 'recv_vohead_id_vohead_curr_id',
2313 'name': 'recv_vohead_id_vohead_adjtaxtype_id',
2317 'name': 'recv_vohead_id_vohead_freighttaxtype_id',
2321 'name': 'recv_vohead_id_vohead_gldistdate',
2325 'name': 'recv_vohead_id_vohead_misc',
2329 'name': 'recv_vohead_id_vohead_taxzone_id',
2333 'name': 'recv_vohead_id_vohead_taxtype_id',
2337 'name': 'recv_vohead_id_vohead_notes',
2341 'name': 'recv_vend_id_vend_id',
2345 'name': 'recv_vend_id_vend_name',
2349 'name': 'recv_vend_id_vend_lastpurchdate',
2353 'name': 'recv_vend_id_vend_active',
2357 'name': 'recv_vend_id_vend_po',
2361 'name': 'recv_vend_id_vend_comments',
2365 'name': 'recv_vend_id_vend_pocomments',
2369 'name': 'recv_vend_id_vend_number',
2373 'name': 'recv_vend_id_vend_1099',
2377 'name': 'recv_vend_id_vend_exported',
2381 'name': 'recv_vend_id_vend_fobsource',
2385 'name': 'recv_vend_id_vend_fob',
2389 'name': 'recv_vend_id_vend_terms_id',
2393 'name': 'recv_vend_id_vend_shipvia',
2397 'name': 'recv_vend_id_vend_vendtype_id',
2401 'name': 'recv_vend_id_vend_qualified',
2405 'name': 'recv_vend_id_vend_ediemail',
2409 'name': 'recv_vend_id_vend_ediemailbody',
2413 'name': 'recv_vend_id_vend_edisubject',
2417 'name': 'recv_vend_id_vend_edifilename',
2421 'name': 'recv_vend_id_vend_accntnum',
2425 'name': 'recv_vend_id_vend_emailpodelivery',
2429 'name': 'recv_vend_id_vend_restrictpurch',
2433 'name': 'recv_vend_id_vend_edicc',
2437 'name': 'recv_vend_id_vend_curr_id',
2441 'name': 'recv_vend_id_vend_cntct1_id',
2445 'name': 'recv_vend_id_vend_cntct2_id',
2449 'name': 'recv_vend_id_vend_addr_id',
2453 'name': 'recv_vend_id_vend_match',
2457 'name': 'recv_vend_id_vend_ach_enabled',
2461 'name': 'recv_vend_id_vend_ach_accnttype',
2465 'name': 'recv_vend_id_vend_ach_use_vendinfo',
2469 'name': 'recv_vend_id_vend_ach_indiv_number',
2473 'name': 'recv_vend_id_vend_ach_indiv_name',
2477 'name': 'recv_vend_id_vend_ediemailhtml',
2481 'name': 'recv_vend_id_vend_ach_routingnumber',
2485 'name': 'recv_vend_id_vend_ach_accntnumber',
2489 'name': 'recv_vend_id_vend_taxzone_id',
2493 'name': 'recv_splitfrom_id_recv_id',
2497 'name': 'recv_splitfrom_id_recv_order_type',
2501 'name': 'recv_splitfrom_id_recv_order_number',
2505 'name': 'recv_splitfrom_id_recv_orderitem_id',
2509 'name': 'recv_splitfrom_id_recv_agent_username',
2513 'name': 'recv_splitfrom_id_recv_itemsite_id',
2517 'name': 'recv_splitfrom_id_recv_vend_id',
2521 'name': 'recv_splitfrom_id_recv_vend_item_number',
2525 'name': 'recv_splitfrom_id_recv_vend_item_descrip',
2529 'name': 'recv_splitfrom_id_recv_vend_uom',
2533 'name': 'recv_splitfrom_id_recv_purchcost',
2537 'name': 'recv_splitfrom_id_recv_purchcost_curr_id',
2541 'name': 'recv_splitfrom_id_recv_duedate',
2545 'name': 'recv_splitfrom_id_recv_qty',
2549 'name': 'recv_splitfrom_id_recv_recvcost',
2553 'name': 'recv_splitfrom_id_recv_recvcost_curr_id',
2557 'name': 'recv_splitfrom_id_recv_freight',
2561 'name': 'recv_splitfrom_id_recv_freight_curr_id',
2565 'name': 'recv_splitfrom_id_recv_date',
2569 'name': 'recv_splitfrom_id_recv_value',
2573 'name': 'recv_splitfrom_id_recv_posted',
2577 'name': 'recv_splitfrom_id_recv_invoiced',
2581 'name': 'recv_splitfrom_id_recv_vohead_id',
2585 'name': 'recv_splitfrom_id_recv_voitem_id',
2589 'name': 'recv_splitfrom_id_recv_trans_usr_name',
2593 'name': 'recv_splitfrom_id_recv_notes',
2597 'name': 'recv_splitfrom_id_recv_gldistdate',
2601 'name': 'recv_splitfrom_id_recv_splitfrom_id',
2605 'name': 'recv_splitfrom_id_recv_rlsd_duedate',
2609 'name': 'recv_recvcost_curr_id_curr_id',
2613 'name': 'recv_recvcost_curr_id_curr_base',
2617 'name': 'recv_recvcost_curr_id_curr_name',
2621 'name': 'recv_recvcost_curr_id_curr_symbol',
2625 'name': 'recv_recvcost_curr_id_curr_abbr',
2629 'name': 'recv_purchcost_curr_id_curr_id',
2633 'name': 'recv_purchcost_curr_id_curr_base',
2637 'name': 'recv_purchcost_curr_id_curr_name',
2641 'name': 'recv_purchcost_curr_id_curr_symbol',
2645 'name': 'recv_purchcost_curr_id_curr_abbr',
2649 'name': 'recv_itemsite_id_itemsite_id',
2653 'name': 'recv_itemsite_id_itemsite_item_id',
2657 'name': 'recv_itemsite_id_itemsite_warehous_id',
2661 'name': 'recv_itemsite_id_itemsite_qtyonhand',
2665 'name': 'recv_itemsite_id_itemsite_reorderlevel',
2669 'name': 'recv_itemsite_id_itemsite_ordertoqty',
2673 'name': 'recv_itemsite_id_itemsite_cyclecountfreq',
2677 'name': 'recv_itemsite_id_itemsite_datelastcount',
2681 'name': 'recv_itemsite_id_itemsite_datelastused',
2685 'name': 'recv_itemsite_id_itemsite_loccntrl',
2689 'name': 'recv_itemsite_id_itemsite_safetystock',
2693 'name': 'recv_itemsite_id_itemsite_minordqty',
2697 'name': 'recv_itemsite_id_itemsite_multordqty',
2701 'name': 'recv_itemsite_id_itemsite_leadtime',
2705 'name': 'recv_itemsite_id_itemsite_abcclass',
2709 'name': 'recv_itemsite_id_itemsite_issuemethod',
2713 'name': 'recv_itemsite_id_itemsite_controlmethod',
2717 'name': 'recv_itemsite_id_itemsite_active',
2721 'name': 'recv_itemsite_id_itemsite_plancode_id',
2725 'name': 'recv_itemsite_id_itemsite_costcat_id',
2729 'name': 'recv_itemsite_id_itemsite_eventfence',
2733 'name': 'recv_itemsite_id_itemsite_sold',
2737 'name': 'recv_itemsite_id_itemsite_stocked',
2741 'name': 'recv_itemsite_id_itemsite_freeze',
2745 'name': 'recv_itemsite_id_itemsite_location_id',
2749 'name': 'recv_itemsite_id_itemsite_useparams',
2753 'name': 'recv_itemsite_id_itemsite_useparamsmanual',
2757 'name': 'recv_itemsite_id_itemsite_soldranking',
2761 'name': 'recv_itemsite_id_itemsite_createpr',
2765 'name': 'recv_itemsite_id_itemsite_location',
2769 'name': 'recv_itemsite_id_itemsite_location_comments',
2773 'name': 'recv_itemsite_id_itemsite_notes',
2777 'name': 'recv_itemsite_id_itemsite_perishable',
2781 'name': 'recv_itemsite_id_itemsite_nnqoh',
2785 'name': 'recv_itemsite_id_itemsite_autoabcclass',
2789 'name': 'recv_itemsite_id_itemsite_ordergroup',
2793 'name': 'recv_itemsite_id_itemsite_disallowblankwip',
2797 'name': 'recv_itemsite_id_itemsite_maxordqty',
2801 'name': 'recv_itemsite_id_itemsite_mps_timefence',
2805 'name': 'recv_itemsite_id_itemsite_createwo',
2809 'name': 'recv_itemsite_id_itemsite_warrpurc',
2813 'name': 'recv_itemsite_id_itemsite_autoreg',
2817 'name': 'recv_itemsite_id_itemsite_costmethod',
2821 'name': 'recv_itemsite_id_itemsite_value',
2825 'name': 'recv_itemsite_id_itemsite_ordergroup_first',
2829 'name': 'recv_itemsite_id_itemsite_supply_itemsite_id',
2833 'name': 'recv_itemsite_id_itemsite_planning_type',
2837 'name': 'recv_itemsite_id_itemsite_wosupply',
2841 'name': 'recv_itemsite_id_itemsite_posupply',
2845 'name': 'recv_itemsite_id_itemsite_lsseq_id',
2849 'name': 'recv_itemsite_id_itemsite_cosdefault',
2853 'name': 'recv_itemsite_id_itemsite_createsopr',
2857 'name': 'recv_itemsite_id_itemsite_createsopo',
2861 'name': 'recv_itemsite_id_itemsite_dropship',
2865 'name': 'recv_freight_curr_id_curr_id',
2869 'name': 'recv_freight_curr_id_curr_base',
2873 'name': 'recv_freight_curr_id_curr_name',
2877 'name': 'recv_freight_curr_id_curr_symbol',
2881 'name': 'recv_freight_curr_id_curr_abbr',
2895 click : function (_self, e)
2898 var sel = _this.rggrid.selModel.getSelected();
2900 Roo.MessageBox.alert("Error", "Select Item receipt");
2906 Pman.Dialog.XtupleTransfer.show({ createFromRev : sel.data.recvgrp_id },
2908 _this.grid.ds.load({});
2913 cls : 'x-btn-text-icon',
2915 text : "Create Transfer",
2916 icon : Roo.rootURL + 'images/default/dd/drop-add.gif'
2928 var c = _this.grid.selModel.getSelectedCell();
2930 Roo.MessageBox.alert("Error", "Select a purchase order");
2934 var s = _this.grid.ds.getAt(c[0]);
2936 Pman.Dialog.XtupleRecvGrp.show( {
2937 recvgrp_pohead_id : s.data.pohead_id ,
2938 recvgrp_pohead_id_pohead_number : s.data.pohead_number
2940 _this.grid.footer.onClick('refresh');
2944 cls : 'x-btn-text-icon',
2945 text : "Add Receipt",
2946 icon : Roo.rootURL + 'images/default/dd/drop-add.gif'
2952 xtype: 'ColumnModel',
2954 dataIndex : 'recvgrp_number',
2957 renderer : function(v,x,r) {
2960 if (vv.indexOf(',') > -1) {
2961 vv = vv.split(',').shift();
2964 if (vv.match(/^NSPO-/)) {
2965 vv = vv.replace(/^NSPO-/, '');
2969 var format = '<i>'+ nn +'</i><b qtip="{1}">{0}</b>';
2970 if (r.data.recvgrp_void *1) {
2971 format = '<s>' + format + '</s>';
2973 return String.format(format, vv,v);
2979 xtype: 'ColumnModel',
2981 dataIndex : 'recvgrp_location_id_location_name',
2984 renderer : function(v,x,r) {
2986 return String.format('{0}', v);
2992 xtype: 'ColumnModel',
2995 dataIndex : 'recvgrp_date',
2998 renderer : function(v) { return v ? v.format('d/M/Y') : ''; }
3001 xtype: 'ColumnModel',
3004 dataIndex : 'total_landed_cost',
3005 header : 'Landed Cost',
3007 renderer : function(v,x,r) {
3008 return String.format('{1}{0}', v, r.data.base_curr_symbol);
3018 activate : function() {
3019 _this.rpanel = this;
3021 _this.rgrid.footer.onClick('first');
3026 fitContainer : true,
3029 tableName : 'poitem',
3038 //_this.dialog = Pman.Dialog.FILL_IN
3039 if (_this.rpanel.active) {
3040 this.footer.onClick('first');
3044 autoExpandColumn : 'item_number',
3050 beforeload : function (_self, options)
3052 if (!_this.grid || !_this.grid.selModel.getSelected()) {
3056 var r = _this.grid.selModel.getSelected();
3060 options.params.poitem_pohead_id = r.data.pohead_id;
3062 var rr = _this.rggrid.selModel.getSelected();
3064 options.params.recvgrp_id = 0;
3066 options.params.recvgrp_id = rr.data.recvgrp_id;
3069 options.params._with_item = 1;
3070 options.params.item_type = 'P';
3074 sortInfo : { field : 'recv_order_type', direction: 'ASC' },
3079 url : baseURL + '/Roo/poitem.php'
3082 xtype: 'JsonReader',
3084 totalProperty : 'total',
3093 'name': 'recv_order_type',
3097 'name': 'recv_order_number',
3101 'name': 'recv_orderitem_id',
3105 'name': 'recv_agent_username',
3109 'name': 'recv_itemsite_id',
3113 'name': 'recv_vend_id',
3117 'name': 'recv_vend_item_number',
3121 'name': 'recv_vend_item_descrip',
3125 'name': 'recv_vend_uom',
3129 'name': 'recv_purchcost',
3133 'name': 'recv_purchcost_curr_id',
3137 'name': 'recv_duedate',
3139 'dateFormat': 'Y-m-d'
3146 'name': 'recv_recvcost',
3150 'name': 'recv_recvcost_curr_id',
3154 'name': 'recv_freight',
3158 'name': 'recv_freight_curr_id',
3162 'name': 'recv_date',
3164 'dateFormat': 'Y-m-d'
3167 'name': 'recv_value',
3171 'name': 'recv_posted',
3175 'name': 'recv_invoiced',
3179 'name': 'recv_vohead_id',
3183 'name': 'recv_voitem_id',
3187 'name': 'recv_trans_usr_name',
3191 'name': 'recv_notes',
3195 'name': 'recv_gldistdate',
3197 'dateFormat': 'Y-m-d'
3200 'name': 'recv_splitfrom_id',
3204 'name': 'recv_rlsd_duedate',
3206 'dateFormat': 'Y-m-d'
3209 'name': 'recv_voitem_id_voitem_id',
3213 'name': 'recv_voitem_id_voitem_vohead_id',
3217 'name': 'recv_voitem_id_voitem_poitem_id',
3221 'name': 'recv_voitem_id_voitem_close',
3225 'name': 'recv_voitem_id_voitem_qty',
3229 'name': 'recv_voitem_id_voitem_freight',
3233 'name': 'recv_voitem_id_voitem_taxtype_id',
3237 'name': 'recv_vohead_id_vohead_id',
3241 'name': 'recv_vohead_id_vohead_number',
3245 'name': 'recv_vohead_id_vohead_pohead_id',
3249 'name': 'recv_vohead_id_vohead_posted',
3253 'name': 'recv_vohead_id_vohead_duedate',
3257 'name': 'recv_vohead_id_vohead_invcnumber',
3261 'name': 'recv_vohead_id_vohead_amount',
3265 'name': 'recv_vohead_id_vohead_docdate',
3269 'name': 'recv_vohead_id_vohead_1099',
3273 'name': 'recv_vohead_id_vohead_distdate',
3277 'name': 'recv_vohead_id_vohead_reference',
3281 'name': 'recv_vohead_id_vohead_terms_id',
3285 'name': 'recv_vohead_id_vohead_vend_id',
3289 'name': 'recv_vohead_id_vohead_curr_id',
3293 'name': 'recv_vohead_id_vohead_adjtaxtype_id',
3297 'name': 'recv_vohead_id_vohead_freighttaxtype_id',
3301 'name': 'recv_vohead_id_vohead_gldistdate',
3305 'name': 'recv_vohead_id_vohead_misc',
3309 'name': 'recv_vohead_id_vohead_taxzone_id',
3313 'name': 'recv_vohead_id_vohead_taxtype_id',
3317 'name': 'recv_vohead_id_vohead_notes',
3321 'name': 'recv_vend_id_vend_id',
3325 'name': 'recv_vend_id_vend_name',
3329 'name': 'recv_vend_id_vend_lastpurchdate',
3333 'name': 'recv_vend_id_vend_active',
3337 'name': 'recv_vend_id_vend_po',
3341 'name': 'recv_vend_id_vend_comments',
3345 'name': 'recv_vend_id_vend_pocomments',
3349 'name': 'recv_vend_id_vend_number',
3353 'name': 'recv_vend_id_vend_1099',
3357 'name': 'recv_vend_id_vend_exported',
3361 'name': 'recv_vend_id_vend_fobsource',
3365 'name': 'recv_vend_id_vend_fob',
3369 'name': 'recv_vend_id_vend_terms_id',
3373 'name': 'recv_vend_id_vend_shipvia',
3377 'name': 'recv_vend_id_vend_vendtype_id',
3381 'name': 'recv_vend_id_vend_qualified',
3385 'name': 'recv_vend_id_vend_ediemail',
3389 'name': 'recv_vend_id_vend_ediemailbody',
3393 'name': 'recv_vend_id_vend_edisubject',
3397 'name': 'recv_vend_id_vend_edifilename',
3401 'name': 'recv_vend_id_vend_accntnum',
3405 'name': 'recv_vend_id_vend_emailpodelivery',
3409 'name': 'recv_vend_id_vend_restrictpurch',
3413 'name': 'recv_vend_id_vend_edicc',
3417 'name': 'recv_vend_id_vend_curr_id',
3421 'name': 'recv_vend_id_vend_cntct1_id',
3425 'name': 'recv_vend_id_vend_cntct2_id',
3429 'name': 'recv_vend_id_vend_addr_id',
3433 'name': 'recv_vend_id_vend_match',
3437 'name': 'recv_vend_id_vend_ach_enabled',
3441 'name': 'recv_vend_id_vend_ach_accnttype',
3445 'name': 'recv_vend_id_vend_ach_use_vendinfo',
3449 'name': 'recv_vend_id_vend_ach_indiv_number',
3453 'name': 'recv_vend_id_vend_ach_indiv_name',
3457 'name': 'recv_vend_id_vend_ediemailhtml',
3461 'name': 'recv_vend_id_vend_ach_routingnumber',
3465 'name': 'recv_vend_id_vend_ach_accntnumber',
3469 'name': 'recv_vend_id_vend_taxzone_id',
3473 'name': 'recv_splitfrom_id_recv_id',
3477 'name': 'recv_splitfrom_id_recv_order_type',
3481 'name': 'recv_splitfrom_id_recv_order_number',
3485 'name': 'recv_splitfrom_id_recv_orderitem_id',
3489 'name': 'recv_splitfrom_id_recv_agent_username',
3493 'name': 'recv_splitfrom_id_recv_itemsite_id',
3497 'name': 'recv_splitfrom_id_recv_vend_id',
3501 'name': 'recv_splitfrom_id_recv_vend_item_number',
3505 'name': 'recv_splitfrom_id_recv_vend_item_descrip',
3509 'name': 'recv_splitfrom_id_recv_vend_uom',
3513 'name': 'recv_splitfrom_id_recv_purchcost',
3517 'name': 'recv_splitfrom_id_recv_purchcost_curr_id',
3521 'name': 'recv_splitfrom_id_recv_duedate',
3525 'name': 'recv_splitfrom_id_recv_qty',
3529 'name': 'recv_splitfrom_id_recv_recvcost',
3533 'name': 'recv_splitfrom_id_recv_recvcost_curr_id',
3537 'name': 'recv_splitfrom_id_recv_freight',
3541 'name': 'recv_splitfrom_id_recv_freight_curr_id',
3545 'name': 'recv_splitfrom_id_recv_date',
3549 'name': 'recv_splitfrom_id_recv_value',
3553 'name': 'recv_splitfrom_id_recv_posted',
3557 'name': 'recv_splitfrom_id_recv_invoiced',
3561 'name': 'recv_splitfrom_id_recv_vohead_id',
3565 'name': 'recv_splitfrom_id_recv_voitem_id',
3569 'name': 'recv_splitfrom_id_recv_trans_usr_name',
3573 'name': 'recv_splitfrom_id_recv_notes',
3577 'name': 'recv_splitfrom_id_recv_gldistdate',
3581 'name': 'recv_splitfrom_id_recv_splitfrom_id',
3585 'name': 'recv_splitfrom_id_recv_rlsd_duedate',
3589 'name': 'recv_recvcost_curr_id_curr_id',
3593 'name': 'recv_recvcost_curr_id_curr_base',
3597 'name': 'recv_recvcost_curr_id_curr_name',
3601 'name': 'recv_recvcost_curr_id_curr_symbol',
3605 'name': 'recv_recvcost_curr_id_curr_abbr',
3609 'name': 'recv_purchcost_curr_id_curr_id',
3613 'name': 'recv_purchcost_curr_id_curr_base',
3617 'name': 'recv_purchcost_curr_id_curr_name',
3621 'name': 'recv_purchcost_curr_id_curr_symbol',
3625 'name': 'recv_purchcost_curr_id_curr_abbr',
3629 'name': 'recv_itemsite_id_itemsite_id',
3633 'name': 'recv_itemsite_id_itemsite_item_id',
3637 'name': 'recv_itemsite_id_itemsite_warehous_id',
3641 'name': 'recv_itemsite_id_itemsite_qtyonhand',
3645 'name': 'recv_itemsite_id_itemsite_reorderlevel',
3649 'name': 'recv_itemsite_id_itemsite_ordertoqty',
3653 'name': 'recv_itemsite_id_itemsite_cyclecountfreq',
3657 'name': 'recv_itemsite_id_itemsite_datelastcount',
3661 'name': 'recv_itemsite_id_itemsite_datelastused',
3665 'name': 'recv_itemsite_id_itemsite_loccntrl',
3669 'name': 'recv_itemsite_id_itemsite_safetystock',
3673 'name': 'recv_itemsite_id_itemsite_minordqty',
3677 'name': 'recv_itemsite_id_itemsite_multordqty',
3681 'name': 'recv_itemsite_id_itemsite_leadtime',
3685 'name': 'recv_itemsite_id_itemsite_abcclass',
3689 'name': 'recv_itemsite_id_itemsite_issuemethod',
3693 'name': 'recv_itemsite_id_itemsite_controlmethod',
3697 'name': 'recv_itemsite_id_itemsite_active',
3701 'name': 'recv_itemsite_id_itemsite_plancode_id',
3705 'name': 'recv_itemsite_id_itemsite_costcat_id',
3709 'name': 'recv_itemsite_id_itemsite_eventfence',
3713 'name': 'recv_itemsite_id_itemsite_sold',
3717 'name': 'recv_itemsite_id_itemsite_stocked',
3721 'name': 'recv_itemsite_id_itemsite_freeze',
3725 'name': 'recv_itemsite_id_itemsite_location_id',
3729 'name': 'recv_itemsite_id_itemsite_useparams',
3733 'name': 'recv_itemsite_id_itemsite_useparamsmanual',
3737 'name': 'recv_itemsite_id_itemsite_soldranking',
3741 'name': 'recv_itemsite_id_itemsite_createpr',
3745 'name': 'recv_itemsite_id_itemsite_location',
3749 'name': 'recv_itemsite_id_itemsite_location_comments',
3753 'name': 'recv_itemsite_id_itemsite_notes',
3757 'name': 'recv_itemsite_id_itemsite_perishable',
3761 'name': 'recv_itemsite_id_itemsite_nnqoh',
3765 'name': 'recv_itemsite_id_itemsite_autoabcclass',
3769 'name': 'recv_itemsite_id_itemsite_ordergroup',
3773 'name': 'recv_itemsite_id_itemsite_disallowblankwip',
3777 'name': 'recv_itemsite_id_itemsite_maxordqty',
3781 'name': 'recv_itemsite_id_itemsite_mps_timefence',
3785 'name': 'recv_itemsite_id_itemsite_createwo',
3789 'name': 'recv_itemsite_id_itemsite_warrpurc',
3793 'name': 'recv_itemsite_id_itemsite_autoreg',
3797 'name': 'recv_itemsite_id_itemsite_costmethod',
3801 'name': 'recv_itemsite_id_itemsite_value',
3805 'name': 'recv_itemsite_id_itemsite_ordergroup_first',
3809 'name': 'recv_itemsite_id_itemsite_supply_itemsite_id',
3813 'name': 'recv_itemsite_id_itemsite_planning_type',
3817 'name': 'recv_itemsite_id_itemsite_wosupply',
3821 'name': 'recv_itemsite_id_itemsite_posupply',
3825 'name': 'recv_itemsite_id_itemsite_lsseq_id',
3829 'name': 'recv_itemsite_id_itemsite_cosdefault',
3833 'name': 'recv_itemsite_id_itemsite_createsopr',
3837 'name': 'recv_itemsite_id_itemsite_createsopo',
3841 'name': 'recv_itemsite_id_itemsite_dropship',
3845 'name': 'recv_freight_curr_id_curr_id',
3849 'name': 'recv_freight_curr_id_curr_base',
3853 'name': 'recv_freight_curr_id_curr_name',
3857 'name': 'recv_freight_curr_id_curr_symbol',
3861 'name': 'recv_freight_curr_id_curr_abbr',
3868 xtype: 'PagingToolbar',
3872 emptyMsg : "No recv found",
3877 xtype: 'ColumnModel',
3880 dataIndex : 'item_number',
3883 renderer : function(v) { return String.format('{0}', v); }
3886 xtype: 'ColumnModel',
3889 dataIndex : 'poitem_qty_ordered',
3892 renderer : function(v) { return String.format('{0}', v); }
3895 xtype: 'ColumnModel',
3898 dataIndex : 'r.data.poitem_qty_received',
3899 header : 'Outstanding',
3901 renderer : function(v,x,r) {
3904 var d = r.data.poitem_qty_ordered - ( r.data.poitem_qty_received - r.data.poitem_qty_returned);
3909 return String.format('<b style="color:red">{0}</b>', d);
3913 xtype: 'ColumnModel',
3916 dataIndex : 'recv_qty_in_transit',
3917 header : 'In Transit',
3919 renderer : function(v,x,r) {
3921 // this should show in transit.. (only applicable to
3922 //var rr = _this.rggrid.selModel.getSelected();
3927 // in transit = recieved, but not transfered.
3931 return String.format('{0}', (v*1).toFixed(0));
3933 // no reciept selected..
3934 d = r.data.poitem_qty_received - r.data.poitem_qty_returned ;
3935 d -= (r.data.poitem_qty_transfered_unposted*1 + r.data.poitem_qty_transfered*1) ;
3940 return String.format('{0}', d);
3945 xtype: 'ColumnModel',
3948 dataIndex : 'recv_qty',
3949 header : 'Recieved',
3951 renderer : function(v,x,r) {
3953 var d = parseInt(v);;
3954 var rr = _this.rggrid.selModel.getSelected();
3957 //d = r.data.poitem_qty_received - r.data.poitem_qty_returned;
3958 // real recived amount = the total that has been transfered out
3962 //d = (r.data.poitem_qty_transfered_unposted*1 + r.data.poitem_qty_transfered*1) ;
3963 //var tot_rec = r.data.poitem_qty_received - r.data.poitem_qty_returned;
3964 //if (d < tot_rec) {
3965 // return String.format('<b style="color:red">{0}</b>', d);
3968 //return String.format('{0}', d);
3977 if (rr && rr.data.recvgrp_void *1 ) {
3978 return String.format('<s>{0}</s>', d);
3984 return String.format('{0}', d);
3992 xtype: 'LayoutRegion',
3994 title : "Item Receipts",
3998 xtype: 'LayoutRegion',
4008 xtype: 'LayoutRegion',
4012 xtype: 'LayoutRegion',