def PopulateQuery(self,columnKey,ValueKey,criteria=CriteriaSearch.Like,typeofData=DataType.VarChar): suplierData = None filterfield = columnKey if criteria==CriteriaSearch.NotEqual or criteria==CriteriaSearch.NotIn: if criteria==CriteriaSearch.NotIn: filterfield = columnKey + '__in' else: filterfield = columnKey + '__iexact' suplierData = super(NA_BR_Suplier,self).get_queryset().exclude(**{filterfield:[ValueKey]}) if criteria==CriteriaSearch.Equal: return super(NA_BR_Suplier,self).get_queryset().filter(**{filterfield: ValueKey}) elif criteria==CriteriaSearch.Greater: filterfield = columnKey + '__gt' elif criteria==CriteriaSearch.GreaterOrEqual: filterfield = columnKey + '__gte' elif criteria==CriteriaSearch.In: filterfield = columnKey + '__in' elif criteria==CriteriaSearch.Less: filterfield = columnKey + '__lt' elif criteria==CriteriaSearch.LessOrEqual: filterfield = columnKey + '__lte' elif criteria==CriteriaSearch.Like: filterfield = columnKey + '__contains' suplierData = super(NA_BR_Suplier,self).get_queryset().filter(**{filterfield: [ValueKey] if filterfield == (columnKey + '__in') else ValueKey}) if criteria==CriteriaSearch.Beetween or criteria==CriteriaSearch.BeginWith or criteria==CriteriaSearch.EndWith: rs = ResolveCriteria(criteria,typeofData,columnKey,ValueKey) suplierData = super(NA_BR_Suplier,self).get_queryset().filter(**rs.DefaultModel()) suplierData = suplierData.values('supliercode','supliername','address','telp','hp','contactperson','inactive','createddate','createdby') return suplierData
def PopulateQuery(self, columnKey, ValueKey, criteria=CriteriaSearch.Like, typeofData=DataType.VarChar): gaData = super(NA_BR_Goods_Receive_GA, self).get_queryset()\ .annotate( goodsname=F('fk_goods__goodsname'), suppliername=F('fk_supplier__suppliername'), received_by=F('fk_receivedby__employee_name'), pr_by=F('fk_p_r_by__employee_name') )\ .values('idapp', 'goodsname', 'typeapp', 'price', 'received_by', 'pr_by', 'suppliername', 'datereceived', 'brand', 'invoice_no', 'machine_no', 'chassis_no', 'year_made', 'colour', 'model', 'kind', 'cylinder', 'fuel', 'descriptions', 'createddate', 'createdby') filterfield = columnKey if criteria == CriteriaSearch.NotEqual or criteria == CriteriaSearch.NotIn: if criteria == CriteriaSearch.NotIn: filterfield = columnKey + '__in' else: filterfield = columnKey + '__iexact' gaData = gaData.exclude(**{filterfield: [ValueKey]}) if criteria == CriteriaSearch.Equal: gaData = gaData.filter(**{filterfield: ValueKey}) elif criteria == CriteriaSearch.Greater: filterfield = columnKey + '__gt' elif criteria == CriteriaSearch.GreaterOrEqual: filterfield = columnKey + '__gte' elif criteria == CriteriaSearch.In: filterfield = columnKey + '__in' elif criteria == CriteriaSearch.Less: filterfield = columnKey + '__lt' elif criteria == CriteriaSearch.LessOrEqual: filterfield = columnKey + '__lte' elif criteria == CriteriaSearch.Like: filterfield = columnKey + '__icontains' gaData = gaData.filter( **{ filterfield: [ValueKey] if filterfield == ( columnKey + '__in') else ValueKey }) if (criteria == CriteriaSearch.Beetween or criteria == CriteriaSearch.BeginWith or criteria == CriteriaSearch.EndWith): rs = ResolveCriteria(criteria, typeofData, columnKey, ValueKey) gaData = gaData.filter(**rs.DefaultModel()) return gaData.order_by('idapp')
def PopulateQuery(self, columnKey, ValueKey, criteria=CriteriaSearch.Like, typeofData=DataType.VarChar): priviledgeData = super(NA_BR_Priviledge, self).get_queryset()\ .values('idapp', 'first_name', 'last_name', 'username', 'divisi', 'role', 'email', 'password', 'last_login', 'last_form', 'is_active', 'date_joined', 'createdby') filterfield = columnKey if criteria == CriteriaSearch.NotEqual or criteria == CriteriaSearch.NotIn: if criteria == CriteriaSearch.NotIn: filterfield = columnKey + '__in' else: filterfield = columnKey + '__iexact' priviledgeData = priviledgeData.exclude( **{filterfield: [ValueKey]}) if criteria == CriteriaSearch.Equal: priviledgeData = priviledgeData.filter(**{filterfield: ValueKey}) elif criteria == CriteriaSearch.Greater: filterfield = columnKey + '__gt' elif criteria == CriteriaSearch.GreaterOrEqual: filterfield = columnKey + '__gte' elif criteria == CriteriaSearch.In: filterfield = columnKey + '__in' elif criteria == CriteriaSearch.Less: filterfield = columnKey + '__lt' elif criteria == CriteriaSearch.LessOrEqual: filterfield = columnKey + '__lte' elif criteria == CriteriaSearch.Like: filterfield = columnKey + '__contains' priviledgeData = priviledgeData.filter( **{ filterfield: [ValueKey] if filterfield == ( columnKey + '__in') else ValueKey }) if criteria == CriteriaSearch.Beetween or criteria == CriteriaSearch.BeginWith or criteria == CriteriaSearch.EndWith: rs = ResolveCriteria(criteria, typeofData, columnKey, ValueKey) priviledgeData = priviledgeData.filter(**rs.DefaultModel()) return priviledgeData
def PopulateQuery(self, columnKey, ValueKey, criteria=CriteriaSearch.Like, typeofData=DataType.VarChar): employeeData = super(NA_BR_Employee, self).get_queryset()\ .values('idapp', 'nik', 'employee_name', 'typeapp', 'jobtype', 'gender', 'status', 'telphp', 'territory', 'descriptions', 'inactive', 'createddate', 'createdby') filterfield = columnKey if criteria == CriteriaSearch.NotEqual or criteria == CriteriaSearch.NotIn: if criteria == CriteriaSearch.NotIn: filterfield = columnKey + '__in' else: filterfield = columnKey + '__iexact' employeeData = employeeData.exclude(**{filterfield: [ValueKey]}) if criteria == CriteriaSearch.Equal: employeeData = employeeData.filter(**{filterfield: ValueKey}) elif criteria == CriteriaSearch.Greater: filterfield = columnKey + '__gt' elif criteria == CriteriaSearch.GreaterOrEqual: filterfield = columnKey + '__gte' elif criteria == CriteriaSearch.In: filterfield = columnKey + '__in' elif criteria == CriteriaSearch.Less: filterfield = columnKey + '__lt' elif criteria == CriteriaSearch.LessOrEqual: filterfield = columnKey + '__lte' elif criteria == CriteriaSearch.Like: filterfield = columnKey + '__icontains' employeeData = employeeData.filter( **{ filterfield: [ValueKey] if filterfield == ( columnKey + '__in') else ValueKey }) if criteria == CriteriaSearch.Beetween or criteria == CriteriaSearch.BeginWith or \ criteria == CriteriaSearch.EndWith: rs = ResolveCriteria(criteria, typeofData, columnKey, ValueKey) employeeData = employeeData.filter(**rs.DefaultModel()) return employeeData