From 67f3795ea8eff9856ed2d91b01a63adf05ab9dbc Mon Sep 17 00:00:00 2001
From: zhangqian <zhangqian@123.com>
Date: 星期一, 08 一月 2024 14:38:40 +0800
Subject: [PATCH] 省市初始化数据
---
model/city.go | 35 ++++++++++++++++++-----------------
model/index.go | 2 ++
model/province.go | 23 +++++++++++++++++++++++
3 files changed, 43 insertions(+), 17 deletions(-)
diff --git a/model/city.go b/model/city.go
index ade9ca7..26fdf5a 100644
--- a/model/city.go
+++ b/model/city.go
@@ -3,6 +3,7 @@
import (
"aps_crm/pkg/mysqlx"
"gorm.io/gorm"
+ "sync"
)
type (
@@ -109,23 +110,23 @@
return list, err
}
-// InitDefaultCity 鍒濆鍖栭粯璁ゅ煄甯�
-func InitDefaultCity() error {
- records := []*City{
- {
- Name: "鍖椾含甯�",
- },
+// InitDefaultData 鍒濆鍖栨暟鎹�
+func (slf *CitySearch) InitDefaultData(errCh chan<- error, wg *sync.WaitGroup) {
+ var (
+ db = slf.Orm.Table(slf.TableName())
+ total int64 = 0
+ )
+ if err := db.Count(&total).Error; err != nil {
+ errCh <- err
+ return
}
-
- var db = mysqlx.GetDB()
- for _, record := range records {
- var city City
- if err := db.Where("name = ?", record.Name).First(&city).Error; err != nil {
- if err := db.Create(record).Error; err != nil {
- return err
- }
- }
+ if total != 0 {
+ return
}
-
- return nil
+ sql := "INSERT INTO `city` VALUES (73,'鍖椾含甯�',29,NULL,NULL),(74,'澶╂触甯�',30,NULL,NULL),(75,'鐧介摱甯�',56,NULL,NULL),(76,'澶╂按甯�',56,NULL,NULL),(77,'姝﹀▉甯�',56,NULL,NULL),(78,'寮犳帠甯�',56,NULL,NULL),(79,'骞冲噳甯�',56,NULL,NULL),(80,'閰掓硥甯�',56,NULL,NULL),(81,'搴嗛槼甯�',56,NULL,NULL),(82,'瀹氳タ甯�',56,NULL,NULL),(83,'闄囧崡甯�',56,NULL,NULL),(84,'涓村鍥炴棌鑷不宸�',56,NULL,NULL),(85,'鐢樺崡钘忔棌鑷不宸�',56,NULL,NULL),(86,'瑗垮畞甯�',57,NULL,NULL),(87,'娴蜂笢甯�',57,NULL,NULL),(88,'娴峰寳钘忔棌鑷不宸�',57,NULL,NULL),(89,'榛勫崡钘忔棌鑷不宸�',57,NULL,NULL),(90,'娴峰崡钘忔棌鑷不宸�',57,NULL,NULL),(91,'鏋滄礇钘忔棌鑷不宸�',57,NULL,NULL),(92,'鐜夋爲钘忔棌鑷不宸�',57,NULL,NULL),(93,'娴疯タ钂欏彜鏃忚棌鏃忚嚜娌诲窞',57,NULL,NULL),(94,'閾跺窛甯�',58,NULL,NULL),(95,'鐭冲槾灞卞競',58,NULL,NULL),(96,'鍚村繝甯�',58,NULL,NULL),(97,'鍥哄師甯�',58,NULL,NULL),(98,'涓崼甯�',58,NULL,NULL),(99,'涔岄瞾鏈ㄩ綈甯�',59,NULL,NULL),(100,'鍏嬫媺鐜涗緷甯�',59,NULL,NULL),(101,'鍚愰瞾鐣競',59,NULL,NULL),(102,'鍝堝瘑甯�',59,NULL,NULL),(103,'鏄屽悏鍥炴棌鑷不宸�',59,NULL,NULL),(104,'鍗氬皵濉旀媺钂欏彜鑷不宸�',59,NULL,NULL),(105,'宸撮煶閮钂欏彜鑷不宸�',59,NULL,NULL),(106,'闃垮厠鑻忓湴鍖�',59,NULL,NULL),(107,'鍏嬪瓬鍕掕嫃鏌皵鍏嬪瓬鑷不宸�',59,NULL,NULL),(108,'鍠�浠�鍦板尯',59,NULL,NULL),(109,'鍜岀敯鍦板尯',59,NULL,NULL),(110,'浼婄妬鍝堣惃鍏嬭嚜娌诲窞',59,NULL,NULL),(111,'濉斿煄鍦板尯',59,NULL,NULL),(112,'闃垮嫆娉板湴鍖�',59,NULL,NULL),(113,'鐭虫渤瀛愬競',59,NULL,NULL),(114,'闃挎媺灏斿競',59,NULL,NULL),(115,'鍥炬湪鑸掑厠甯�',59,NULL,NULL),(116,'浜斿娓犲競',59,NULL,NULL),(117,'鍖楀悲甯�',59,NULL,NULL),(118,'閾侀棬鍏冲競',59,NULL,NULL),(119,'鍙屾渤甯�',59,NULL,NULL),(120,'鍙厠杈炬媺甯�',59,NULL,NULL),(121,'鏄嗙帀甯�',59,NULL,NULL),(122,'鍙板寳甯�',60,NULL,NULL),(123,'楂橀泟甯�',60,NULL,NULL),(124,'鏂板寳甯�',60,NULL,NULL),(125,'鍙颁腑甯�',60,NULL,NULL),(126,'鍙板崡甯�',60,NULL,NULL),(127,'妗冨洯甯�',60,NULL,NULL),(128,'鍩洪殕甯�',60,NULL,NULL),(129,'鏂扮甯�',60,NULL,NULL),(130,'鍢変箟甯�',60,NULL,NULL),(131,'鏂扮鍘�',60,NULL,NULL),(132,'瀹滃叞鍘�',60,NULL,NULL),(133,'鑻楁牀鍘�',60,NULL,NULL),(134,'褰板寲鍘�',60,NULL,NULL),(135,'浜戞灄鍘�',60,NULL,NULL),(136,'鍗楁姇鍘�',60,NULL,NULL),(137,'鍢変箟鍘�',60,NULL,NULL),(138,'灞忎笢鍘�',60,NULL,NULL),(139,'鍙颁笢鍘�',60,NULL,NULL),(140,'鑺辫幉鍘�',60,NULL,NULL),(141,'婢庢箹鍘�',60,NULL,NULL),(142,'棣欐腐',61,NULL,NULL),(143,'婢抽棬',62,NULL,NULL),(144,'鍏板窞甯�',56,NULL,NULL),(145,'鍢夊唱鍏冲競',56,NULL,NULL),(146,'閲戞槍甯�',56,NULL,NULL),(147,'骞垮厓甯�',51,NULL,NULL),(148,'閬傚畞甯�',51,NULL,NULL),(149,'鍐呮睙甯�',51,NULL,NULL),(150,'涔愬北甯�',51,NULL,NULL),(151,'鍗楀厖甯�',51,NULL,NULL),(152,'鐪夊北甯�',51,NULL,NULL),(153,'瀹滃甯�',51,NULL,NULL),(154,'骞垮畨甯�',51,NULL,NULL),(155,'杈惧窞甯�',51,NULL,NULL),(156,'闆呭畨甯�',51,NULL,NULL),(157,'宸翠腑甯�',51,NULL,NULL),(158,'璧勯槼甯�',51,NULL,NULL),(159,'闃垮潩钘忔棌缇屾棌鑷不宸�',51,NULL,NULL),(160,'鐢樺瓬钘忔棌鑷不宸�',51,NULL,NULL),(161,'鍑夊北褰濇棌鑷不宸�',51,NULL,NULL),(162,'璐甸槼甯�',52,NULL,NULL),(163,'鍏洏姘村競',52,NULL,NULL),(164,'閬典箟甯�',52,NULL,NULL),(165,'瀹夐『甯�',52,NULL,NULL),(166,'姣曡妭甯�',52,NULL,NULL),(167,'閾滀粊甯�',52,NULL,NULL),(168,'榛旇タ鍗楀竷渚濇棌鑻楁棌鑷不宸�',52,NULL,NULL),(169,'榛斾笢鍗楄嫍鏃忎緱鏃忚嚜娌诲窞',52,NULL,NULL),(170,'榛斿崡甯冧緷鏃忚嫍鏃忚嚜娌诲窞',52,NULL,NULL),(171,'鏄嗘槑甯�',53,NULL,NULL),(172,'鏇查潠甯�',53,NULL,NULL),(173,'鐜夋邯甯�',53,NULL,NULL),(174,'淇濆北甯�',53,NULL,NULL),(175,'鏄�氬競',53,NULL,NULL),(176,'涓芥睙甯�',53,NULL,NULL),(177,'鏅幢甯�',53,NULL,NULL),(178,'涓存钵甯�',53,NULL,NULL),(179,'妤氶泟褰濇棌鑷不宸�',53,NULL,NULL),(180,'绾㈡渤鍝堝凹鏃忓綕鏃忚嚜娌诲窞',53,NULL,NULL),(181,'鏂囧北澹棌鑻楁棌鑷不宸�',53,NULL,NULL),(182,'瑗垮弻鐗堢撼鍌ｆ棌鑷不宸�',53,NULL,NULL),(183,'澶х悊鐧芥棌鑷不宸�',53,NULL,NULL),(184,'寰峰畯鍌ｆ棌鏅鏃忚嚜娌诲窞',53,NULL,NULL),(185,'鎬掓睙鍌堝兂鏃忚嚜娌诲窞',53,NULL,NULL),(186,'杩簡钘忔棌鑷不宸�',53,NULL,NULL),(187,'鎷夎惃甯�',54,NULL,NULL),(188,'鏃ュ杸鍒欏競',54,NULL,NULL),(189,'鏄岄兘甯�',54,NULL,NULL),(190,'鏋楄姖甯�',54,NULL,NULL),(191,'灞卞崡甯�',54,NULL,NULL),(192,'閭ｆ洸甯�',54,NULL,NULL),(193,'闃块噷鍦板尯',54,NULL,NULL),(194,'瑗垮畨甯�',55,NULL,NULL),(195,'閾滃窛甯�',55,NULL,NULL),(196,'瀹濋浮甯�',55,NULL,NULL),(197,'鍜搁槼甯�',55,NULL,NULL),(198,'娓崡甯�',55,NULL,NULL),(199,'寤跺畨甯�',55,NULL,NULL),(200,'姹変腑甯�',55,NULL,NULL),(201,'姒嗘灄甯�',55,NULL,NULL),(202,'瀹夊悍甯�',55,NULL,NULL),(203,'鍟嗘礇甯�',55,NULL,NULL),(204,'鍗楀畞甯�',48,NULL,NULL),(205,'鏌冲窞甯�',48,NULL,NULL),(206,'妗傛灄甯�',48,NULL,NULL),(207,'姊у窞甯�',48,NULL,NULL),(208,'鍖楁捣甯�',48,NULL,NULL),(209,'闃插煄娓競',48,NULL,NULL),(210,'閽﹀窞甯�',48,NULL,NULL),(211,'璐垫腐甯�',48,NULL,NULL),(212,'鐜夋灄甯�',48,NULL,NULL),(213,'鐧捐壊甯�',48,NULL,NULL),(214,'璐哄窞甯�',48,NULL,NULL),(215,'娌虫睜甯�',48,NULL,NULL),(216,'鏉ュ甯�',48,NULL,NULL),(217,'宕囧乏甯�',48,NULL,NULL),(218,'娴峰彛甯�',49,NULL,NULL),(219,'涓変簹甯�',49,NULL,NULL),(220,'涓夋矙甯�',49,NULL,NULL),(221,'鍎嬪窞甯�',49,NULL,NULL),(222,'浜旀寚灞卞競',49,NULL,NULL),(223,'鐞兼捣甯�',49,NULL,NULL),(224,'鏂囨槍甯�',49,NULL,NULL),(225,'涓囧畞甯�',49,NULL,NULL),(226,'涓滄柟甯�',49,NULL,NULL),(227,'瀹氬畨鍘�',49,NULL,NULL),(228,'灞槍鍘�',49,NULL,NULL),(229,'婢勮繄鍘�',49,NULL,NULL),(230,'涓撮珮鍘�',49,NULL,NULL),(231,'鐧芥矙榛庢棌鑷不鍘�',49,NULL,NULL),(232,'鏄屾睙榛庢棌鑷不鍘�',49,NULL,NULL),(233,'涔愪笢榛庢棌鑷不鍘�',49,NULL,NULL),(234,'闄垫按榛庢棌鑷不鍘�',49,NULL,NULL),(235,'淇濅涵榛庢棌鑻楁棌鑷不鍘�',49,NULL,NULL),(236,'鐞间腑榛庢棌鑻楁棌鑷不鍘�',49,NULL,NULL),(237,'閲嶅簡甯�',50,NULL,NULL),(238,'閲嶅簡甯�',50,NULL,NULL),(239,'鎴愰兘甯�',51,NULL,NULL),(240,'鑷础甯�',51,NULL,NULL),(241,'鏀�鏋濊姳甯�',51,NULL,NULL),(242,'娉稿窞甯�',51,NULL,NULL),(243,'寰烽槼甯�',51,NULL,NULL),(244,'缁甸槼甯�',51,NULL,NULL),(245,'涓婃捣甯�',37,NULL,NULL),(246,'鍗椾含甯�',38,NULL,NULL),(247,'鏃犻敗甯�',38,NULL,NULL),(248,'寰愬窞甯�',38,NULL,NULL),(249,'甯稿窞甯�',38,NULL,NULL),(250,'鑻忓窞甯�',38,NULL,NULL),(251,'鍗楅�氬競',38,NULL,NULL),(252,'杩炰簯娓競',38,NULL,NULL),(253,'娣畨甯�',38,NULL,NULL),(254,'鐩愬煄甯�',38,NULL,NULL),(255,'鎵窞甯�',38,NULL,NULL),(256,'闀囨睙甯�',38,NULL,NULL),(257,'娉板窞甯�',38,NULL,NULL),(258,'瀹胯縼甯�',38,NULL,NULL),(259,'鏉窞甯�',39,NULL,NULL),(260,'瀹佹尝甯�',39,NULL,NULL),(261,'娓╁窞甯�',39,NULL,NULL),(262,'鍢夊叴甯�',39,NULL,NULL),(263,'婀栧窞甯�',39,NULL,NULL),(264,'缁嶅叴甯�',39,NULL,NULL),(265,'閲戝崕甯�',39,NULL,NULL),(266,'琛㈠窞甯�',39,NULL,NULL),(267,'鑸熷北甯�',39,NULL,NULL),(268,'鍙板窞甯�',39,NULL,NULL),(269,'涓芥按甯�',39,NULL,NULL),(270,'鍚堣偉甯�',40,NULL,NULL),(271,'鑺滄箹甯�',40,NULL,NULL),(272,'铓屽煚甯�',40,NULL,NULL),(273,'娣崡甯�',40,NULL,NULL),(274,'椹瀺灞卞競',40,NULL,NULL),(275,'娣寳甯�',40,NULL,NULL),(276,'閾滈櫟甯�',40,NULL,NULL),(277,'瀹夊簡甯�',40,NULL,NULL),(278,'榛勫北甯�',40,NULL,NULL),(279,'婊佸窞甯�',40,NULL,NULL),(280,'闃滈槼甯�',40,NULL,NULL),(281,'瀹垮窞甯�',40,NULL,NULL),(282,'鍏畨甯�',40,NULL,NULL),(283,'浜冲窞甯�',40,NULL,NULL),(284,'姹犲窞甯�',40,NULL,NULL),(285,'瀹ｅ煄甯�',40,NULL,NULL),(286,'绂忓窞甯�',41,NULL,NULL),(287,'鍘﹂棬甯�',41,NULL,NULL),(288,'鑾嗙敯甯�',41,NULL,NULL),(289,'涓夋槑甯�',41,NULL,NULL),(290,'娉夊窞甯�',41,NULL,NULL),(291,'婕冲窞甯�',41,NULL,NULL),(292,'鍗楀钩甯�',41,NULL,NULL),(293,'榫欏博甯�',41,NULL,NULL),(294,'瀹佸痉甯�',41,NULL,NULL),(295,'鍗楁槍甯�',42,NULL,NULL),(296,'鏅痉闀囧競',42,NULL,NULL),(297,'钀嶄埂甯�',42,NULL,NULL),(298,'涔濇睙甯�',42,NULL,NULL),(299,'鏂颁綑甯�',42,NULL,NULL),(300,'楣版江甯�',42,NULL,NULL),(301,'璧ｅ窞甯�',42,NULL,NULL),(302,'鍚夊畨甯�',42,NULL,NULL),(303,'瀹滄槬甯�',42,NULL,NULL),(304,'鎶氬窞甯�',42,NULL,NULL),(305,'涓婇ザ甯�',42,NULL,NULL),(306,'娴庡崡甯�',43,NULL,NULL),(307,'闈掑矝甯�',43,NULL,NULL),(308,'娣勫崥甯�',43,NULL,NULL),(309,'鏋ｅ簞甯�',43,NULL,NULL),(310,'涓滆惀甯�',43,NULL,NULL),(311,'鐑熷彴甯�',43,NULL,NULL),(312,'娼嶅潑甯�',43,NULL,NULL),(313,'娴庡畞甯�',43,NULL,NULL),(314,'娉板畨甯�',43,NULL,NULL),(315,'濞佹捣甯�',43,NULL,NULL),(316,'鏃ョ収甯�',43,NULL,NULL),(317,'涓存矀甯�',43,NULL,NULL),(318,'寰峰窞甯�',43,NULL,NULL),(319,'鑱婂煄甯�',43,NULL,NULL),(320,'婊ㄥ窞甯�',43,NULL,NULL),(321,'鑿忔辰甯�',43,NULL,NULL),(322,'閮戝窞甯�',44,NULL,NULL),(323,'寮�灏佸競',44,NULL,NULL),(324,'娲涢槼甯�',44,NULL,NULL),(325,'骞抽《灞卞競',44,NULL,NULL),(326,'瀹夐槼甯�',44,NULL,NULL),(327,'楣ゅ甯�',44,NULL,NULL),(328,'鏂颁埂甯�',44,NULL,NULL),(329,'鐒︿綔甯�',44,NULL,NULL),(330,'婵槼甯�',44,NULL,NULL),(331,'璁告槍甯�',44,NULL,NULL),(332,'婕渤甯�',44,NULL,NULL),(333,'涓夐棬宄″競',44,NULL,NULL),(334,'鍗楅槼甯�',44,NULL,NULL),(335,'鍟嗕笜甯�',44,NULL,NULL),(336,'淇￠槼甯�',44,NULL,NULL),(337,'鍛ㄥ彛甯�',44,NULL,NULL),(338,'椹婚┈搴楀競',44,NULL,NULL),(339,'娴庢簮甯�',44,NULL,NULL),(340,'姝︽眽甯�',45,NULL,NULL),(341,'榛勭煶甯�',45,NULL,NULL),(342,'鍗佸牥甯�',45,NULL,NULL),(343,'瀹滄槍甯�',45,NULL,NULL),(344,'瑗勯槼甯�',45,NULL,NULL),(345,'閯傚窞甯�',45,NULL,NULL),(346,'鑽嗛棬甯�',45,NULL,NULL),(347,'瀛濇劅甯�',45,NULL,NULL),(348,'鑽嗗窞甯�',45,NULL,NULL),(349,'榛勫唸甯�',45,NULL,NULL),(350,'鍜稿畞甯�',45,NULL,NULL),(351,'闅忓窞甯�',45,NULL,NULL),(352,'鎭╂柦鍦熷鏃忚嫍鏃忚嚜娌诲窞',45,NULL,NULL),(353,'浠欐甯�',45,NULL,NULL),(354,'娼滄睙甯�',45,NULL,NULL),(355,'澶╅棬甯�',45,NULL,NULL),(356,'绁炲啘鏋舵灄鍖�',45,NULL,NULL),(357,'闀挎矙甯�',46,NULL,NULL),(358,'鏍床甯�',46,NULL,NULL),(359,'婀樻江甯�',46,NULL,NULL),(360,'琛￠槼甯�',46,NULL,NULL),(361,'閭甸槼甯�',46,NULL,NULL),(362,'宀抽槼甯�',46,NULL,NULL),(363,'甯稿痉甯�',46,NULL,NULL),(364,'寮犲鐣屽競',46,NULL,NULL),(365,'鐩婇槼甯�',46,NULL,NULL),(366,'閮村窞甯�',46,NULL,NULL),(367,'姘稿窞甯�',46,NULL,NULL),(368,'鎬�鍖栧競',46,NULL,NULL),(369,'濞勫簳甯�',46,NULL,NULL),(370,'婀樿タ鍦熷鏃忚嫍鏃忚嚜娌诲窞',46,NULL,NULL),(371,'骞垮窞甯�',47,NULL,NULL),(372,'闊跺叧甯�',47,NULL,NULL),(373,'娣卞湷甯�',47,NULL,NULL),(374,'鐝犳捣甯�',47,NULL,NULL),(375,'姹曞ご甯�',47,NULL,NULL),(376,'浣涘北甯�',47,NULL,NULL),(377,'姹熼棬甯�',47,NULL,NULL),(378,'婀涙睙甯�',47,NULL,NULL),(379,'鑼傚悕甯�',47,NULL,NULL),(380,'鑲囧簡甯�',47,NULL,NULL),(381,'鎯犲窞甯�',47,NULL,NULL),(382,'姊呭窞甯�',47,NULL,NULL),(383,'姹曞熬甯�',47,NULL,NULL),(384,'娌虫簮甯�',47,NULL,NULL),(385,'闃虫睙甯�',47,NULL,NULL),(386,'娓呰繙甯�',47,NULL,NULL),(387,'涓滆帪甯�',47,NULL,NULL),(388,'涓北甯�',47,NULL,NULL),(389,'娼窞甯�',47,NULL,NULL),(390,'鎻槼甯�',47,NULL,NULL),(391,'浜戞诞甯�',47,NULL,NULL),(392,'闀挎槬甯�',35,NULL,NULL),(393,'鍚夋灄甯�',35,NULL,NULL),(394,'鍥涘钩甯�',35,NULL,NULL),(395,'杈芥簮甯�',35,NULL,NULL),(396,'閫氬寲甯�',35,NULL,NULL),(397,'鐧藉北甯�',35,NULL,NULL),(398,'鏉惧師甯�',35,NULL,NULL),(399,'鐧藉煄甯�',35,NULL,NULL),(400,'寤惰竟鏈濋矞鏃忚嚜娌诲窞',35,NULL,NULL),(401,'鍝堝皵婊ㄥ競',36,NULL,NULL),(402,'榻愰綈鍝堝皵甯�',36,NULL,NULL),(403,'楦¤タ甯�',36,NULL,NULL),(404,'楣ゅ矖甯�',36,NULL,NULL),(405,'鍙岄腑灞卞競',36,NULL,NULL),(406,'澶у簡甯�',36,NULL,NULL),(407,'浼婃槬甯�',36,NULL,NULL),(408,'浣虫湪鏂競',36,NULL,NULL),(409,'涓冨彴娌冲競',36,NULL,NULL),(410,'鐗′腹姹熷競',36,NULL,NULL),(411,'榛戞渤甯�',36,NULL,NULL),(412,'缁ュ寲甯�',36,NULL,NULL),(413,'澶у叴瀹夊箔鍦板尯',36,NULL,NULL),(414,'鍛煎拰娴╃壒甯�',33,NULL,NULL),(415,'鍖呭ご甯�',33,NULL,NULL),(416,'涔屾捣甯�',33,NULL,NULL),(417,'璧ゅ嘲甯�',33,NULL,NULL),(418,'閫氳窘甯�',33,NULL,NULL),(419,'閯傚皵澶氭柉甯�',33,NULL,NULL),(420,'鍛间鸡璐濆皵甯�',33,NULL,NULL),(421,'宸村溅娣栧皵甯�',33,NULL,NULL),(422,'涔屽叞瀵熷竷甯�',33,NULL,NULL),(423,'鍏村畨鐩�',33,NULL,NULL),(424,'閿℃灄閮嫆鐩�',33,NULL,NULL),(425,'闃挎媺鍠勭洘',33,NULL,NULL),(426,'娌堥槼甯�',34,NULL,NULL),(427,'澶ц繛甯�',34,NULL,NULL),(428,'闉嶅北甯�',34,NULL,NULL),(429,'鎶氶『甯�',34,NULL,NULL),(430,'鏈邯甯�',34,NULL,NULL),(431,'涓逛笢甯�',34,NULL,NULL),(432,'閿﹀窞甯�',34,NULL,NULL),(433,'钀ュ彛甯�',34,NULL,NULL),(434,'闃滄柊甯�',34,NULL,NULL),(435,'杈介槼甯�',34,NULL,NULL),(436,'鐩橀敠甯�',34,NULL,NULL),(437,'閾佸箔甯�',34,NULL,NULL),(438,'鏈濋槼甯�',34,NULL,NULL),(439,'钁姦宀涘競',34,NULL,NULL),(440,'鐭冲搴勫競',31,NULL,NULL),(441,'鍞愬北甯�',31,NULL,NULL),(442,'绉︾殗宀涘競',31,NULL,NULL),(443,'閭兏甯�',31,NULL,NULL),(444,'閭㈠彴甯�',31,NULL,NULL),(445,'淇濆畾甯�',31,NULL,NULL),(446,'寮犲鍙ｅ競',31,NULL,NULL),(447,'鎵垮痉甯�',31,NULL,NULL),(448,'娌у窞甯�',31,NULL,NULL),(449,'寤婂潑甯�',31,NULL,NULL),(450,'琛℃按甯�',31,NULL,NULL),(451,'澶師甯�',32,NULL,NULL),(452,'澶у悓甯�',32,NULL,NULL),(453,'闃虫硥甯�',32,NULL,NULL),(454,'闀挎不甯�',32,NULL,NULL),(455,'鏅嬪煄甯�',32,NULL,NULL),(456,'鏈斿窞甯�',32,NULL,NULL),(457,'鏅嬩腑甯�',32,NULL,NULL),(458,'杩愬煄甯�',32,NULL,NULL),(459,'蹇诲窞甯�',32,NULL,NULL),(460,'涓存本甯�',32,NULL,NULL),(461,'鍚曟甯�',32,NULL,NULL);"
+ err := slf.Orm.Exec(sql).Error
+ if err != nil {
+ errCh <- err
+ return
+ }
}
diff --git a/model/index.go b/model/index.go
index d62248f..2258728 100644
--- a/model/index.go
+++ b/model/index.go
@@ -142,6 +142,8 @@
NewPaymentTypeSearch(),
NewBankAccountSearch(),
NewRefundTypeSearch(),
+ NewProvinceSearch(nil),
+ NewCitySearch(),
}
for _, model := range models {
diff --git a/model/province.go b/model/province.go
index 6e9e908..186a902 100644
--- a/model/province.go
+++ b/model/province.go
@@ -3,6 +3,7 @@
import (
"aps_crm/pkg/mysqlx"
"gorm.io/gorm"
+ "sync"
)
type (
@@ -115,3 +116,25 @@
var db = slf.build()
return db.Updates(m).Error
}
+
+// InitDefaultData 鍒濆鍖栨暟鎹�
+func (slf *ProvinceSearch) InitDefaultData(errCh chan<- error, wg *sync.WaitGroup) {
+ var (
+ db = slf.Orm.Table(slf.TableName())
+ total int64 = 0
+ )
+ if err := db.Count(&total).Error; err != nil {
+ errCh <- err
+ return
+ }
+ if total != 0 {
+ return
+ }
+ sql := "INSERT INTO `province` VALUES (29,'鍖椾含甯�',3),(30,'澶╂触甯�',3),(31,'娌冲寳鐪�',3),(32,'灞辫タ鐪�',3),(33,'鍐呰挋鍙よ嚜娌诲尯',3),(34,'杈藉畞鐪�',3),(35,'鍚夋灄鐪�',3),(36,'榛戦緳姹熺渷',3),(37,'涓婃捣甯�',3),(38,'姹熻嫃鐪�',3),(39,'娴欐睙鐪�',3),(40,'瀹夊窘鐪�',3),(41,'绂忓缓鐪�',3),(42,'姹熻タ鐪�',3),(43,'灞变笢鐪�',3),(44,'娌冲崡鐪�',3),(45,'婀栧寳鐪�',3),(46,'婀栧崡鐪�',3),(47,'骞夸笢鐪�',3),(48,'骞胯タ澹棌鑷不鍖�',3),(49,'娴峰崡鐪�',3),(50,'閲嶅簡甯�',3),(51,'鍥涘窛鐪�',3),(52,'璐靛窞鐪�',3),(53,'浜戝崡鐪�',3),(54,'瑗胯棌鑷不鍖�',3),(55,'闄曡タ鐪�',3),(56,'鐢樿們鐪�',3),(57,'闈掓捣鐪�',3),(58,'瀹佸鍥炴棌鑷不鍖�',3),(59,'鏂扮枂缁村惥灏旇嚜娌诲尯',3),(60,'鍙版咕鐪�',3),(61,'棣欐腐',3),(62,'婢抽棬',3)"
+
+ err := slf.Orm.Exec(sql).Error
+ if err != nil {
+ errCh <- err
+ return
+ }
+}
--
Gitblit v1.8.0