def _build_query(self, cp): query = DdrLister() query.file = '459.01' query.iens = ',%s,' % (self.ien,) query.fields = self._get_vista_field_str() query.index = 'B' query.screen = 'I $P(^(0),U,10)="%s"' % (cp,) query.fieldnames = self._get_fieldnames() return query
def get_by_cost_center(cxn, cost_center): query = DdrLister() query.file = '450' query.fields = ';'.join(fields) query.index = 'ACC' query.frum = cost_center query.part = cost_center query.fieldnames = fieldnames return query.find(cxn)
def __get_vista_data(cxn, cp_nbr, fy, qtr): query = DdrLister() query.file = '410' query.fields = '.01;1;3;22;23;24;25;25.5;27;451' query.index = 'RB' query.frum = '{}-{}-{}-'.format(get_fiscal_start_date(fy, qtr), primary_source_id(cxn.source_id), cp_nbr) query.part = query.frum query.identifier = ''.join( [ 'S X=$S($P(^(4),U,10)]"":"Y",1:"N") ', 'S Y=$S($P(^(7),U,6)]"":"Y",1:"N") ', 'S Z=$P(^(0),"-")_"-"_$P(^(4),U,5) ', 'S Z=$O(^PRC(442,"B",Z,0)) ', 'S Z1=$S(+Z=0:"X",$P($G(^PRC(442,Z,0)),U,2)=25:$P(^(7),U,2),1:"N") ', 'S Z2=$S(+Z\'=0:$P($$FP^PRCH0A(Z),U,2),1:"X")', 'D EN^DDIOL(X_U_Y_U_Z1_U_Z2)' ] ) return query.find(cxn)