Sanjeet Kedia Comments - Convex Community

import { defineSchema, defineTable } from 'convex/server';
import { v } from 'convex/values';

export default defineSchema({
  invoiceList: defineTable({
    invoiceNo: v.number(),
    invoiceDate: v.string(),
    customerName: v.string(),
    customerAddress: v.string(),
    customerEmail: v.string(),
    customerPhone: v.string(),
    total: v.number(),
    discount: v.number(),
    advance: v.number(),
    balance: v.number(),
  }),
  salesSpecification: defineTable({
    rowNo: v.number(),
    invoiceId: v.optional(v.id('invoiceList')),
    itemName: v.string(),
    unitPrice: v.number(),
    qty: v.number(),
    subTotal: v.number(),
  }),
  itemList: defineTable({
    itemName: v.string(),
    itemCode: v.string(),
    dollarPrice: v.number(),
  }),
  customerList: defineTable({
    customerName: v.string(),
    customerAddress: v.string(),
    customerEmail: v.string(),
    customerPhone: v.string(),
  }),
  appState: defineTable({
    dollarRate: v.number(),
  }),
});

20 replies

CCConvex Community

•Created by Sanjeet Kedia on 10/4/2023 in #support-community

Having to put v.optional in the schema file

Is this an example of the circular error, i only need the salesSpecification to hold the invoiceNo i don't need to store the sales spec Id in Invoice List Table

20 replies

CCConvex Community

•Created by Sanjeet Kedia on 10/4/2023 in #support-community

Having to put v.optional in the schema file

This is my code, there was error i was getting null until i changed the schma of my salesspecification table to v.optional(v.id())

20 replies

CCConvex Community

•Created by Sanjeet Kedia on 10/4/2023 in #support-community

Having to put v.optional in the schema file

import { mutation } from './_generated/server';
import { v } from 'convex/values';

export const addNewInvoice = mutation({
  args: {
    advance: v.number(),
    balance: v.number(),
    customerAddress: v.string(),
    customerEmail: v.string(),
    customerName: v.string(),
    customerPhone: v.string(),
    discount: v.number(),
    invoiceDate: v.string(),
    total: v.number(),
    invoiceNo: v.number(),
    itemRows: v.array(
      v.object({
        invoiceItemRow: v.number(),
        itemName: v.string(),
        itemPrice: v.number(),
        itemQty: v.number(),
        subTotal: v.number(),
      }),
    ),
  },
  handler: async (ctx, args) => {
    const newInvoiceId = await ctx.db.insert('invoiceList', {
      advance: args.advance,
      balance: args.balance,
      customerAddress: args.customerAddress,
      customerEmail: args.customerEmail,
      customerName: args.customerName,
      customerPhone: args.customerPhone,
      discount: args.discount,
      invoiceDate: args.invoiceDate,
      total: args.total,
      invoiceNo: args.invoiceNo,
    });

    for (let i = 0; i < args.itemRows.length; i++) {
      const row = args.itemRows[i];
      const SalesSpecId = await ctx.db.insert('salesSpecification', {
        itemName: row.itemName,
        qty: row.itemQty,
        rowNo: row.invoiceItemRow,
        subTotal: row.subTotal,
        unitPrice: row.itemPrice,
        invoiceId: newInvoiceId,
      });
    }

    return typeof newInvoiceId;
  },
});

20 replies

CCConvex Community

•Created by Sanjeet Kedia on 9/24/2023 in #support-community

development with electron js

Is there any way to use the react way because i am using react in electron? The documentation on http client is not very clear

4 replies