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