Report validation on backend

[PaoGon]

How to replicate

• when you create an report with same reportType and description but different place it will throw an error that report is already existing

expected behavior:

• the report should be created because they are on different location

suggestion:

• validate also the location if possible? I hope it is :) if not will need to depricate that validation

[jlozion026]

Sige sige paps, tinry ko last time ivalidate din kasama location, may nakukuha akong error nun last time, pero need ko lang imbestigahan mabuti

[PaoGon]

patingin ako ng error na nakukuha mo, ss mo dito

[PaoGon]

eto pala

      const isReport = await ctx.prisma.report.findFirst({
        where : {
          AND: [
            {description: args.data.description},
            {report_type: args.data.report_type},
          ]
        }
      })
      if (isReport) {
        throw new ApolloError("Report Already Exist")
      }

Originally posted by @jlozion026 in https://github.com/PaoGon/thesis/issues/63#issuecomment-1384757096

[PaoGon]

eto pala

      const isReport = await ctx.prisma.report.findFirst({
        where : {
          AND: [
            {description: args.data.description},
            {report_type: args.data.report_type},
          ]
        }
      })
      if (isReport) {
        throw new ApolloError("Report Already Exist")
      }

Originally posted by @jlozion026 in #63 (comment)

di ba na gana dito yung

        where : {
          AND: [
            {description: args.data.description},
            {report_type: args.data.report_type},
            {report_type: args.data.location},
          ]
        }

@jlozion026

[jlozion026]

Ayan, ganyan yung ginawa ko nooon HAHAHAH

[PaoGon]

Ayan, ganyan yung ginawa ko nooon HAHAHAH

hmmm, possible kasi na di nya ala myung type ng location since json yung type nyan kaya nag error pero patingin narin ng error message