33 lines
925 B
SQL
33 lines
925 B
SQL
 
|
ALTER TABLE "Lead" ADD COLUMN "gender" TEXT NOT NULL DEFAULT 'none';
|
||
|
|
ALTER TABLE "Lead" ADD COLUMN "showGenderInName" BOOLEAN NOT NULL DEFAULT false;
|
||
|
|
|
||
|
|
-- عنوان داخل نام مخاطب، و اگر مخاطب خالی است داخل عنوان لید
|
||
|
|
UPDATE "Lead"
|
||
|
|
SET "gender" = 'male', "showGenderInName" = true
|
||
|
|
WHERE regexp_replace(
|
||
|
|
regexp_replace(
|
||
|
|
btrim(CASE WHEN btrim(coalesce("contactName", '')) <> '' THEN "contactName" ELSE "title" END),
|
||
|
|
'ي',
|
||
|
|
'ی',
|
||
|
|
'g'
|
||
|
|
),
|
||
|
|
'ك',
|
||
|
|
'ک',
|
||
|
|
'g'
|
||
|
|
) ~ '^جناب[[:space:]]*آقای([[:space:]]|$)';
|
||
|
|
|
||
|
|
UPDATE "Lead"
|
||
|
|
SET "gender" = 'female', "showGenderInName" = true
|
||
|
|
WHERE "gender" = 'none'
|
||
|
|
AND regexp_replace(
|
||
|
|
regexp_replace(
|
||
|
|
btrim(CASE WHEN btrim(coalesce("contactName", '')) <> '' THEN "contactName" ELSE "title" END),
|
||
|
|
'ي',
|
||
|
|
'ی',
|
||
|
|
'g'
|
||
|
|
),
|
||
|
|
'ك',
|
||
|
|
'ک',
|
||
|
|
'g'
|
||
|
|
) ~ '^سرکار[[:space:]]*خانم([[:space:]]|$)';
|