schema.graphql

scalar Otp
scalar Qrcode
scalar Datetime

input assets {
  item: String!
  net_worth: String!
}
input liabilities {
  item: String!
  net_worth: String!
}

input equity {
  item: String!
  net_worth: String!
}

type Activity {
  id: ID!
  name: String!
}

type Group {
  id: ID!
  activity: Activity!
  group_name: String!
}

type Type {
  id: ID!
  type_name: String!
  type_description: String!
}

type TransactionCategory {
  id: ID!
  parent: Group!
  category_name: String!
  category_description: String!
}

type TransactionSubCategory {
  id: ID!
  parent: TransactionCategory!
  category_name: String!
  category_description: String!
}

type ProductCategory {
  id: ID!
  category_name: String!
  category_description: String!
}

type ProductSubCategory {
  id: ID!
  parent: ProductCategory!
  category_name: String!
  category_description: String!
}

type Plan {
  id: ID!
  name: String!
  accounts: Boolean!
  no_of_accounts: Int!
  budgets: Boolean!
  no_of_budgets: Int!
  targets: Boolean!
  no_of_targets: Int!
  invoices: Boolean!
  no_of_invoices: Int!
  pdf_reports: Boolean!
  ai_assistant: Boolean!
  created_at: Datetime!
  updated_at: Datetime!
}

type User {
  id: ID!
  first_name: String!
  last_name: String!
  email: String!
  username: String!
  is_staff: Boolean!
  is_active: Boolean!
}

type Profile {
  id: ID!
  user: User!
  plan: Plan!
  payment_method: String!
  is_paid_user: Boolean!
  created_at: Datetime!
  updated_at: Datetime!
}

type Account {
  id: ID!
  account_name: String!
  account_type: String!
  owner: Profile!
  currency_code: String!
  account_balance: Float!
  created_at: Datetime!
  updated_at: Datetime!
}

type Budget {
  id: ID!
  budget_name: String!
  budget_description: String!
  budget_is_active: Boolean!
  budget_amount: Float!
  owner: Profile!
  account: Account!
  category: TransactionCategory!
  sub_category: TransactionSubCategory!
  created_at: Datetime!
  updated_at: Datetime!
}

type Target {
  id: ID!
  target_name: String!
  target_description: String!
  target_is_active: Boolean!
  target_amount: Float!
  owner: Profile!
  account: Account!
  category: TransactionCategory!
  sub_category: TransactionSubCategory!
  created_at: Datetime!
  updated_at: Datetime!
}

type Transaction {
  id: ID!
  transaction_type: Type!
  transaction_amount: Float!
  currency_code: String!
  description: String!
  transaction_date: Datetime!
  account: Account!
  category: TransactionCategory!
  sub_category: TransactionSubCategory!
  created_at: Datetime!
  updated_at: Datetime!
}

type Product {
  id: ID!
  account: Account!
  name: String!
  description: String!
  category: ProductCategory!
  sub_category: ProductSubCategory!
  buying_price: Float!
  selling_price: Float!
  current_stock_level: Int!
  units_sold: Int!
  reorder_level: Int
  reorder_quantity: Int
  supplier_name: String!
  profit_generated: Float
  created_at: Datetime!
  updated_at: Datetime!
}

type PaymentAccount {
  id: ID!
  owner: Profile!
  business_name: String!
  business_email: String!
  business_phone_number: String!
  bank_name: String!
  bank_account: String!
  mobile_payment_name: String!
  mobile_account: String!
  created_at: Datetime!
  updated_at: Datetime!
}

type ClientInformation {
  id: ID!
  owner: Profile!
  client_name: String!
  client_email: String!
  client_phone_number: String!
  client_address: String!
  created_at: Datetime!
  updated_at: Datetime!
}

type Invoice {
  id: ID!
  owner: Profile!
  business: PaymentAccount!
  client: ClientInformation!
  category: TransactionCategory!
  sub_category: TransactionSubCategory!
  item: String!
  quantity: Int!
  amount: Float!
  total: Float!
  additional_notes: String!
  due_date: Datetime!
  is_paid: Boolean!
  created_at: Datetime!
  updated_at: Datetime!
}

type CashFlowRecord {
  id: ID!
  uid: String!
  category: String!
  item: String!
  activity: String!
  amount: Float!
  is_income: Boolean!
  created_at: Datetime!
  updated_at: Datetime!
}

type CashFlowStatement {
  id: ID!
  uid: String!
  account: Account!
  record: CashFlowRecord!
  created_at: Datetime!
  updated_at: Datetime!
}

type CashFlowStatementIdentifier {
  id: ID!
  uid: String!
  account: Account!
  period_start_date: Datetime!
  period_end_date: Datetime!
  created_at: Datetime!
  updated_at: Datetime!
}

type IncomeStatement {
  id: ID!
  uid: String!
  account: Account!
  period_start_date: Datetime!
  period_end_date: Datetime!
  revenue: Float!
  gross_profit: Float!
  operating_expenses: Float!
  net_income: Float!
  created_at: Datetime!
  updated_at: Datetime!
}

type BalanceSheetStatement {
  id: ID!
  uid: String!
  account: Account!
  assets: Float!
  liabilities: Float!
  equity: Float!
  created_at: Datetime!
  updated_at: Datetime!
}

type Query {
  generateOTP(environment: String): Otp!
  generateQRCode: Qrcode!

  tokenAuth(username: String!, password: String!): TokenAuth!

  getTransactionType: [Type!]!
  getTransactionCategory: [TransactionCategory!]!
  getTransactionSubCategory(parent: String!): [TransactionSubCategory!]!

  getProductCategory: [ProductCategory!]!
  getProductSubCategory(parent: String!): [ProductSubCategory!]!

  testStandardDecorator: Plan!
  testProDecorator: Plan!

  getUser: User!
  getProfile: Profile!
  validateOrCreateUser(
    email: String!
    first_name: String!
    last_name: String
    password: String!
    password2: String!
  ): User!

  getAllAccounts: [Account!]!
  getAccount(id: ID!): Account!

  getAllBudgets: [Budget!]!
  getBudget(id: ID!): Budget!

  getAllTargets: [Target!]!
  getTarget(id: ID!): Target!

  getAllTransactions(account_id: ID!): [Transaction!]!
  getTransaction(id: ID!): Transaction!

  getAllProducts(account_id: ID!): [Product!]!
  getProduct(id: ID!): Product!

  getAllPaymentAccounts: [PaymentAccount!]!
  getPaymentAccount(id: ID!): PaymentAccount!

  getAllClientInformation: [ClientInformation!]!
  getClientInformation(id: ID!): ClientInformation!

  getAllInvoices: [Invoice!]!
  getInvoice(id: ID!): Invoice!

  getAllCashFlowStatements(account_id: ID!): [CashFlowStatementIdentifier!]!
  getCashFlowStatement(uid: String!): [CashFlowStatement!]!

  getAllIncomeStatements(account_id: ID!): [IncomeStatement!]!
  getIncomeStatement(uid: String!): IncomeStatement!

  getAllBalanceSheetStatements(account_id: ID!): [BalanceSheetStatement!]!
  getBalanceSheetStatement(uid: String!): BalanceSheetStatement!
}

type Mutation {
  verifyOTP(otp: String!): String!

  verifyToken(token: String!): VerifyToken!
  refreshToken(token: String!): RefreshToken!
  tokenAuth(username: String!, password: String!): TokenAuth!

  createUser(
    email: String!
    first_name: String!
    last_name: String
    password: String!
    password2: String!
  ): User!
  updateUser(email: String!, first_name: String!, last_name: String!): User!

  createAccount(
    account_name: String!
    account_type: String!
    account_balance: String!
    currency_code: String!
  ): Account!
  updateAccount(
    id: ID!
    account_name: String!
    account_type: String!
    account_balance: String!
    currency_code: String!
  ): Account!
  deleteAccount(id: ID!): Boolean!

  createBudget(
    account_id: ID!
    budget_name: String!
    budget_description: String!
    budget_amount: String!
    category: String!
    sub_category: String!
  ): Budget!
  updateBudget(
    id: ID!
    budget_name: String!
    budget_description: String!
    budget_amount: String!
    category: String!
    sub_category: String!
  ): Budget!
  budgetStatus(id: ID!, status: Boolean!): Boolean!
  deleteBudget(id: ID!): Boolean!

  createTarget(
    account_id: ID!
    target_name: String!
    target_description: String!
    target_amount: String!
    category: String!
    sub_category: String!
  ): Target!
  updateTarget(
    id: ID!
    target_name: String!
    target_description: String!
    target_amount: String!
    category: String!
    sub_category: String!
  ): Target!
  targetStatus(id: ID!, status: Boolean!): Boolean!
  deleteTarget(id: ID!): Boolean!

  createTransaction(
    account_id: ID!
    transaction_type: String!
    transaction_amount: String!
    transaction_date: String!
    description: String!
    category: String!
    sub_category: String!
  ): Transaction!
  updateTransaction(
    id: ID!
    account_id: ID!
    transaction_type: String!
    transaction_amount: String!
    transaction_date: String!
    description: String!
    category: String!
    sub_category: String!
  ): Transaction!
  deleteTransaction(id: ID!, account_id: ID!): Boolean!

  createProduct(
    account_id: ID!
    name: String!
    description: String!
    category: String!
    sub_category: String!
    buying_price: String!
    selling_price: String!
    current_stock_level: String!
    units_sold: String!
    supplier_name: String!
  ): Product!
  updateProduct(
    id: ID!
    name: String!
    description: String!
    category: String!
    sub_category: String!
    buying_price: String!
    selling_price: String!
    current_stock_level: String!
    units_sold: String!
    supplier_name: String!
  ): Product!
  deleteProduct(id: ID!): Boolean!

  createPaymentAccount(
    business_name: String!
    business_email: String!
    business_phone_number: String!
    bank_name: String!
    bank_account: String!
    mobile_payment_name: String!
    mobile_account: String!
  ): PaymentAccount!
  updatePaymentAccount(
    id: ID!
    business_name: String!
    business_email: String!
    business_phone_number: String!
    bank_name: String!
    bank_account: String!
    mobile_payment_name: String!
    mobile_account: String!
  ): PaymentAccount!
  deletePaymentAccount(id: ID!): Boolean!

  createClientInformation(
    client_name: String!
    client_email: String!
    client_phone_number: String!
    client_address: String!
  ): ClientInformation!
  updateClientInformation(
    id: ID!
    client_name: String!
    client_email: String!
    client_phone_number: String!
    client_address: String!
  ): ClientInformation!
  deleteClientInformation(id: ID!): Boolean!

  createInvoice(
    business: String!
    client: String!
    category: String!
    sub_category: String!
    item: String!
    quantity: String!
    amount: String!
    additional_notes: String!
    due_date: String!
  ): Invoice!
  updateInvoice(
    id: ID!
    business: String!
    client: String!
    category: String!
    sub_category: String!
    item: String!
    quantity: String!
    amount: String!
    additional_notes: String!
    due_date: String!
  ): Invoice!
  deleteInvoice(id: ID!): Boolean!

  generateCashFlowReport(
    account_id: ID!
    begin_date: String!
    end_date: String!
  ): CashFlowStatementIdentifier!
  deleteCashFlowReport(uid: String!): Boolean!

  generateIncomeReport(
    account_id: ID!
    begin_date: String!
    end_date: String!
  ): IncomeStatement!
  deleteIncomeReport(uid: String!): Boolean!

  generateBalanceSheetReport(
    account_id: ID!
    assets: [assets!]!
    liabilities: [liabilities!]!
    equity: [equity!]!
  ): BalanceSheetStatement!
  deleteBalanceSheetReport(uid: String!): Boolean!
}