1 files changed, 105 insertions, 0 deletions
diff --git a/db/seeds_2/vendorSeed.ts b/db/seeds_2/vendorSeed.ts
new file mode 100644
index 00000000..98e0a98b
--- /dev/null
+++ b/db/seeds_2/vendorSeed.ts
@@ -0,0 +1,105 @@
+// db/seed/vendorSeed.ts
+import { faker } from "@faker-js/faker";
+import db from "@/db/db";
+import { vendors } from "../schema/vendors";
+import { desc } from "drizzle-orm";
+
+export async function generateVendor(index: number) {
+  const vendorTypes = ["MANUFACTURER", "DISTRIBUTOR", "SERVICE_PROVIDER"];
+  const countries = ["KR", "US", "CN", "JP", "DE", "FR", "GB", "SG", "VN", "TH"];
+  const businessTypes = ["Corporation", "LLC", "Partnership", "Sole Proprietorship"];
+  
+  const country = faker.helpers.arrayElement(countries);
+  const businessType = faker.helpers.arrayElement(businessTypes);
+  const vendorType = faker.helpers.arrayElement(vendorTypes);
+  
+  // 회사 이름 생성 패턴 다양화
+  let vendorName;
+  const namePattern = Math.random();
+  if (namePattern < 0.3) {
+    // 일반적인 회사명
+    vendorName = faker.company.name();
+  } else if (namePattern < 0.6) {
+    // 산업 특화된 이름
+    const industry = faker.helpers.arrayElement([
+      "Tech", "Manufacturing", "Electronics", "Chemical", 
+      "Automotive", "Energy", "Construction"
+    ]);
+    vendorName = `${faker.company.name()} ${industry}`;
+  } else {
+    // 지역성이 있는 이름
+    const region = faker.location.state();
+    vendorName = `${region} ${faker.company.name()}`;
+  }
+
+  return {
+    vendorCode: `VEN${String(index + 1).padStart(5, "0")}`,
+    vendorName,
+    businessNumber: faker.helpers.replaceSymbols("##-###-#####"),
+    representativeName: faker.person.fullName(),
+    businessType,
+    vendorType,
+    status: faker.helpers.arrayElement(["ACTIVE", "INACTIVE", "BLACKLISTED"]),
+    country,
+    address: faker.location.streetAddress(),
+    city: faker.location.city(),
+    state: faker.location.state(),
+    zipCode: faker.location.zipCode(),
+    contact1Name: faker.person.fullName(),
+    contact1Email: faker.internet.email(),
+    contact1Phone: faker.phone.number(),
+    contact2Name: Math.random() > 0.5 ? faker.person.fullName() : null,
+    contact2Email: Math.random() > 0.5 ? faker.internet.email() : null,
+    contact2Phone: Math.random() > 0.5 ? faker.phone.number() : null,
+    description: faker.company.catchPhrase(),
+    website: Math.random() > 0.3 ? faker.internet.url() : null,
+    foundedYear: faker.number.int({ min: 1950, max: 2023 }),
+    employeeCount: faker.number.int({ min: 10, max: 10000 }),
+    annualRevenue: faker.number.float({ 
+      min: 1000000, 
+      max: 1000000000, 
+      fractionDigits: 2 
+    }),
+    certifications: Math.random() > 0.5 ? 
+      faker.helpers.arrayElements(
+        ["ISO 9001", "ISO 14001", "OHSAS 18001", "ISO/TS 16949", "AS9100"], 
+        faker.number.int({ min: 1, max: 3 })
+      ) : 
+      null,
+  };
+}
+
+export async function seedVendors(input: { count: number }) {
+  try {
+    const allVendors = [];
+    
+    // 현재 가장 큰 vendorCode 찾기
+    const [lastVendor] = await db.select()
+      .from(vendors)
+      .orderBy(desc(vendors.vendorCode))
+      .limit(1);
+    
+    const startIndex = lastVendor?.vendorCode
+      ? parseInt(lastVendor.vendorCode.replace('VEN', '')) 
+      : 0;
+
+    console.log("📝 Inserting vendors", { lastVendorCode: lastVendor?.vendorCode, startIndex });
+
+    for (let i = 0; i < input.count; i++) {
+      allVendors.push(await generateVendor(startIndex + i));
+    }
+
+    console.log("📝 Inserting vendors", allVendors.length);
+
+    const result = await db.insert(vendors)
+      .values(allVendors)
+      .onConflictDoNothing()
+      .returning();
+
+    console.log(`✅ Successfully added ${result.length} new vendors`);
+    return result;
+  } catch (err) {
+    console.error("Failed to seed vendors:", err);
+    throw err;
+  }
+}
+\ No newline at end of file