Untitled-1 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376
  1. ##燃气灶维修
  2. INSERT INTO `la_fault_type` (`id`, `category_type`, `goods_category_id`, `name`, `pid`) VALUES (1, 1, 38, '集成灶维修', 0);
  3. INSERT INTO `la_fault_type` (`id`, `category_type`, `goods_category_id`, `name`, `pid`) VALUES (2, 1, 38, '普通燃气灶维修(单灶)', 0);
  4. INSERT INTO `la_fault_type` (`id`, `category_type`, `goods_category_id`, `name`, `pid`) VALUES (3, 1, 38, '燃气灶无名', 0);
  5. INSERT INTO `la_fault_type` (`id`, `category_type`, `goods_category_id`, `name`, `pid`) VALUES (4, 1, 38, '普通燃气灶维修(双灶)', 0);
  6. INSERT INTO `la_fault_type` (`id`, `category_type`, `goods_category_id`, `name`, `pid`) VALUES
  7. (5, 1, 38, '按键灯不亮', 1),
  8. (6, 1, 38, '不抽油烟', 1),
  9. (7, 1, 38, '不通电', 1),
  10. (8, 1, 38, '抽屉滑轨抽拉不畅', 1),
  11. (9, 1, 38, '串味', 1),
  12. (10, 1, 38, '打不着火', 1),
  13. (11, 1, 38, '火苗不正常', 1),
  14. (12, 1, 38, '开关扭不动', 1),
  15. (13, 1, 38, '漏气', 1),
  16. (14, 1, 38, '炉头组件故障', 1),
  17. (15, 1, 38, '无臭氧', 1),
  18. (16, 1, 38, '哚音大', 1),
  19. (17, 1, 38, '自动熄火', 1);
  20. INSERT INTO `la_fault_type` (`id`, `category_type`, `goods_category_id`, `name`, `pid`) VALUES
  21. (18, 1, 38, '打不着火', 2),
  22. (19, 1, 38, '火苗不正常', 2),
  23. (20, 1, 38, '开关扭不动', 2),
  24. (21, 1, 38, '漏气', 2);
  25. INSERT INTO `la_fault_type` (`id`, `category_type`, `goods_category_id`, `name`, `pid`) VALUES
  26. (22, 1, 38, '炉头组件故障', 3),
  27. (23, 1, 38, '自动熄火', 3);
  28. INSERT INTO `la_fault_type` (`id`, `category_type`, `goods_category_id`, `name`, `pid`) VALUES
  29. (24, 1, 38, '打不着火', 4),
  30. (25, 1, 38, '火苗不正常', 4),
  31. (26, 1, 38, '开关扭不动', 4),
  32. (27, 1, 38, '漏气', 4),
  33. (28, 1, 38, '炉头组件故障', 4),
  34. (29, 1, 38, '自动熄火', 4);
  35. ##油烟机维修
  36. INSERT INTO `la_fault_type` (`id`, `category_type`, `goods_category_id`, `name`, `pid`) VALUES
  37. (30, 1, 43, '集成灶油烟', 0),
  38. (31, 1, 43, '欧式油烟机维修(排风量14(m3/min)及以下)', 0),
  39. (32, 1, 43, '普通油烟机维修', 0),
  40. (33, 1, 43, '升降式油烟机维修(功率200W及以下 )', 0),
  41. (34, 1, 43, '升降式油烟机维修(功率200W以上 )', 0),
  42. (35, 1, 43, '中式油烟机维修(功率200W及以下 )', 0),
  43. (36, 1, 43, '中式油烟机维修(功率200W以上)', 0);
  44. INSERT INTO `la_fault_type` (`id`, `category_type`, `goods_category_id`, `name`, `pid`) VALUES
  45. (37, 1, 43, '不抽油烟', 30),
  46. (38, 1, 43, '不通电', 30),
  47. (39, 1, 43, '不消毒', 30),
  48. (40, 1, 43, '抽屉滑轨抽拉不畅', 30),
  49. (41, 1, 43, '串味', 30),
  50. (42, 1, 43, '抖动大', 30),
  51. (43, 1, 43, '开关扭不动', 30),
  52. (44, 1, 43, '开机后熄火', 30),
  53. (45, 1, 43, '漏气', 30),
  54. (46, 1, 43, '漏水', 30),
  55. (47, 1, 43, '漏油', 30),
  56. (48, 1, 43, '炉头组件故障', 30),
  57. (49, 1, 43, '门打不开', 30),
  58. (50, 1, 43, '清洗检测', 30),
  59. (51, 1, 43, '闪灯/显示字母报警', 30),
  60. (52, 1, 43, '通电灯不亮', 30),
  61. (53, 1, 43, '无臭氧', 30),
  62. (54, 1, 43, '噪音大', 30);
  63. INSERT INTO `la_fault_type` (`id`, `category_type`, `goods_category_id`, `name`, `pid`) VALUES
  64. (55, 1, 43, '自动熄火', 31),
  65. (56, 1, 43, '不抽油烟', 31),
  66. (57, 1, 43, '不通电', 31),
  67. (58, 1, 43, '串味', 31),
  68. (59, 1, 43, '抖动大', 31),
  69. (60, 1, 43, '开关扭不动', 31),
  70. (61, 1, 43, '漏水', 31),
  71. (62, 1, 43, '漏油', 31),
  72. (63, 1, 43, '门打不开', 31),
  73. (64, 1, 43, '清洗检测', 31),
  74. (65, 1, 43, '闪灯/显示字母报警', 31),
  75. (66, 1, 43, '通电灯不亮', 31),
  76. (67, 1, 43, '噪音大', 31);
  77. INSERT INTO `la_fault_type` (`id`, `category_type`, `goods_category_id`, `name`, `pid`) VALUES
  78. (68, 1, 43, '不抽油烟', 32),
  79. (69, 1, 43, '不通电', 32),
  80. (70, 1, 43, '串味', 32),
  81. (71, 1, 43, '抖动大', 32),
  82. (72, 1, 43, '开关扭不动', 32),
  83. (73, 1, 43, '漏水', 32),
  84. (74, 1, 43, '漏油', 32),
  85. (75, 1, 43, '门打不开', 32),
  86. (76, 1, 43, '清洗检测', 32),
  87. (77, 1, 43, '闪灯/显示字母报警', 32),
  88. (78, 1, 43, '通电灯不亮', 32),
  89. (79, 1, 43, '噪音大', 32);
  90. INSERT INTO `la_fault_type` (`id`, `category_type`, `goods_category_id`, `name`, `pid`) VALUES
  91. (80, 1, 43, '不抽油烟', 33),
  92. (81, 1, 43, '不通电', 33),
  93. (82, 1, 43, '不抽油烟', 33),
  94. (83, 1, 43, '不通电', 33),
  95. (84, 1, 43, '串味', 33),
  96. (85, 1, 43, '抖动大', 33),
  97. (86, 1, 43, '开关扭不动', 33),
  98. (87, 1, 43, '漏水', 33),
  99. (88, 1, 43, '门打不开', 33),
  100. (89, 1, 43, '清洗检测', 33),
  101. (90, 1, 43, '闪灯/显示字母报警', 33),
  102. (91, 1, 43, '通电灯不亮', 33),
  103. (92, 1, 43, '噪音大', 33);
  104. INSERT INTO `la_fault_type` (`id`, `category_type`, `goods_category_id`, `name`, `pid`) VALUES
  105. (93, 1, 43, '不抽油烟', 34),
  106. (94, 1, 43, '不通电', 34),
  107. (95, 1, 43, '串味', 34),
  108. (96, 1, 43, '抖动大', 34),
  109. (97, 1, 43, '开关扭不动', 34),
  110. (98, 1, 43, '漏水', 34),
  111. (99, 1, 43, '漏油', 34),
  112. (100, 1, 43, '门打不开', 34),
  113. (101, 1, 43, '清洗检测', 34),
  114. (102, 1, 43, '闪灯/显示字母报警', 34),
  115. (103, 1, 43, '通电灯不亮', 34),
  116. (104, 1, 43, '噪音大', 34);
  117. INSERT INTO `la_fault_type` (`id`, `category_type`, `goods_category_id`, `name`, `pid`) VALUES
  118. (105, 1, 43, '不抽油烟', 35),
  119. (106, 1, 43, '不通电', 35),
  120. (107, 1, 43, '串味', 35),
  121. (108, 1, 43, '抖动大', 35),
  122. (109, 1, 43, '开关扭不动', 35),
  123. (110, 1, 43, '漏水', 35),
  124. (111, 1, 43, '漏油', 35),
  125. (112, 1, 43, '门打不开', 35),
  126. (113, 1, 43, '清洗检测', 35),
  127. (114, 1, 43, '闪灯/显示字母报警', 35),
  128. (115, 1, 43, '通电灯不亮', 35),
  129. (116, 1, 43, '噪音大', 35);
  130. INSERT INTO `la_fault_type` (`id`, `category_type`, `goods_category_id`, `name`, `pid`) VALUES
  131. (117, 1, 43, '不抽油烟', 36),
  132. (118, 1, 43, '不通电', 36),
  133. (119, 1, 43, '串味', 36),
  134. (120, 1, 43, '抖动大', 36),
  135. (121, 1, 43, '开关扭不动', 36),
  136. (122, 1, 43, '漏水', 36),
  137. (123, 1, 43, '漏油', 36),
  138. (124, 1, 43, '门打不开', 36),
  139. (125, 1, 43, '清洗检测', 36),
  140. (126, 1, 43, '闪灯/显示字母报警', 36),
  141. (127, 1, 43, '通电灯不亮', 36),
  142. (128, 1, 43, '噪音大', 36);
  143. ##燃气热水器
  144. INSERT INTO `la_fault_type` (`id`, `category_type`, `goods_category_id`, `name`, `pid`) VALUES
  145. (129, 1, 40, '壁挂炉维修', 0),
  146. (130, 1, 40, '燃气热水器无名', 0),
  147. (131, 1, 40, '壁挂炉维修(20L)', 0),
  148. (132, 1, 40, '燃气热水器无名', 0),
  149. (133, 1, 40, '壁挂炉维修(25L)', 0),
  150. (134, 1, 40, '燃气热水器无名', 0),
  151. (135, 1, 40, '壁挂炉维修(30L)', 0),
  152. (136, 1, 40, '燃气热水器无名', 0),
  153. (137, 1, 40, '电热水器维修(>500L)', 0),
  154. (138, 1, 40, '电热水器维修(100L)', 0),
  155. (139, 1, 40, '电热水器维修(101-200L)', 0),
  156. (140, 1, 40, '电热水器维修(201-300L)', 0),
  157. (141, 1, 40, '电热水器维修(301-500L)', 0),
  158. (142, 1, 40, '电热水器维修(40-50L)', 0),
  159. (143, 1, 40, '电热水器维修(60-80L)', 0),
  160. (144, 1, 40, '即热式热水器维修(≤4000瓦 )', 0),
  161. (145, 1, 40, '即热式热水器维修(4001-6000瓦 )', 0),
  162. (146, 1, 40, '即热式热水器维修(6001-8000瓦 )', 0),
  163. (147, 1, 40, '空气能热水器维修(1-1.5P)', 0);
  164. INSERT INTO `la_fault_type` (`id`, `category_type`, `goods_category_id`, `name`, `pid`) VALUES
  165. (148, 1, 40, '不出热水/不够热', 129),
  166. (149, 1, 40, '不上水', 129),
  167. (150, 1, 40, '不通电', 129),
  168. (151, 1, 40, '出水小', 129),
  169. (152, 1, 40, '点不着火', 129),
  170. (153, 1, 40, '开机后熄火', 129),
  171. (154, 1, 40, '开机跳闸', 129),
  172. (155, 1, 40, '漏气', 129),
  173. (156, 1, 40, '漏水', 129),
  174. (157, 1, 40, '燃气热水器无名', 129),
  175. (158, 1, 40, '有异响', 129);
  176. INSERT INTO `la_fault_type` (`id`, `category_type`, `goods_category_id`, `name`, `pid`) VALUES
  177. (159, 1, 40, '不出热水/不够热', 130),
  178. (160, 1, 40, '不上水', 130),
  179. (161, 1, 40, '不通电', 130);
  180. INSERT INTO `la_fault_type` (`id`, `category_type`, `goods_category_id`, `name`, `pid`) VALUES
  181. (162, 1, 40, '出水小', 131),
  182. (163, 1, 40, '点不着火', 131),
  183. (164, 1, 40, '开机后熄火', 131),
  184. (165, 1, 40, '开机跳闸', 131),
  185. (166, 1, 40, '漏气', 131),
  186. (167, 1, 40, '燃气热水器无名', 131),
  187. (168, 1, 40, '漏水', 131),
  188. (169, 1, 40, '有异响', 131);
  189. INSERT INTO `la_fault_type` (`id`, `category_type`, `goods_category_id`, `name`, `pid`) VALUES
  190. (170, 1, 40, '不出热水/不够热', 132),
  191. (171, 1, 40, '不上水', 132);
  192. INSERT INTO `la_fault_type` (`id`, `category_type`, `goods_category_id`, `name`, `pid`) VALUES
  193. (172, 1, 40, '不通电', 133),
  194. (173, 1, 40, '出水小', 133),
  195. (174, 1, 40, '点不着火', 133),
  196. (175, 1, 40, '开机后熄火', 133),
  197. (176, 1, 40, '开机跳闸', 133),
  198. (177, 1, 40, '漏气', 133),
  199. (178, 1, 40, '漏水', 133),
  200. (179, 1, 40, '有异响', 133);
  201. INSERT INTO `la_fault_type` (`id`, `category_type`, `goods_category_id`, `name`, `pid`) VALUES
  202. (180, 1, 40, '不出热水/不够热', 134);
  203. INSERT INTO `la_fault_type` (`id`, `category_type`, `goods_category_id`, `name`, `pid`) VALUES
  204. (181, 1, 40, '不上水', 135),
  205. (182, 1, 40, '不通电', 135),
  206. (183, 1, 40, '出水小', 135),
  207. (184, 1, 40, '点不着火', 135),
  208. (185, 1, 40, '开机后熄火', 135),
  209. (186, 1, 40, '开机跳闸', 135),
  210. (187, 1, 40, '漏气', 135),
  211. (188, 1, 40, '漏水', 135),
  212. (189, 1, 40, '有异响', 135);
  213. INSERT INTO `la_fault_type` (`id`, `category_type`, `goods_category_id`, `name`, `pid`) VALUES
  214. (190, 1, 40, '不出热水/不够热', 136),
  215. (191, 1, 40, '不上水', 136),
  216. (192, 1, 40, '不通电', 136);
  217. INSERT INTO `la_fault_type` (`id`, `category_type`, `goods_category_id`, `name`, `pid`) VALUES
  218. (193, 1, 40, '燃气热水器无名', 137),
  219. (194, 1, 40, '出水小', 137),
  220. (195, 1, 40, '点不着火', 137),
  221. (196, 1, 40, '开关扭不动', 137),
  222. (197, 1, 40, '开机后熄火', 137),
  223. (198, 1, 40, '开机跳闸', 137),
  224. (199, 1, 40, '漏气', 137),
  225. (200, 1, 40, '漏水', 137),
  226. (201, 1, 40, '有异响', 137);
  227. INSERT INTO `la_fault_type` (`id`, `category_type`, `goods_category_id`, `name`, `pid`) VALUES
  228. (202, 1, 40, '不出热水/不够热', 138),
  229. (203, 1, 40, '不上水', 138),
  230. (204, 1, 40, '不通电', 138),
  231. (205, 1, 40, '出水小', 138),
  232. (206, 1, 40, '点不着火', 138),
  233. (207, 1, 40, '开关扭不动', 138),
  234. (208, 1, 40, '开机后熄火', 138),
  235. (209, 1, 40, '开机跳闸', 138),
  236. (210, 1, 40, '漏气', 138),
  237. (211, 1, 40, '漏水', 138),
  238. (212, 1, 40, '有异响', 138),
  239. INSERT INTO `la_fault_type` (`id`, `category_type`, `goods_category_id`, `name`, `pid`) VALUES
  240. (213, 1, 40, '不出热水/不够热', 139),
  241. (214, 1, 40, '不上水', 139),
  242. (215, 1, 40, '不通电', 139),
  243. (216, 1, 40, '出水小', 139),
  244. (217, 1, 40, '点不着火', 139),
  245. (218, 1, 40, '开关扭不动', 139),
  246. (219, 1, 40, '开机后熄火', 139),
  247. (220, 1, 40, '开机跳闸', 139),
  248. (221, 1, 40, '漏气', 139),
  249. (222, 1, 40, '漏水', 139),
  250. (223, 1, 40, '有异响', 139);
  251. INSERT INTO `la_fault_type` (`id`, `category_type`, `goods_category_id`, `name`, `pid`) VALUES
  252. (224, 1, 40, '不出热水/不够热', 140),
  253. (225, 1, 40, '不上水', 140),
  254. (226, 1, 40, '不通电', 140),
  255. (227, 1, 40, '出水小', 140),
  256. (228, 1, 40, '点不着火', 140),
  257. (229, 1, 40, '开关扭不动', 140),
  258. (230, 1, 40, '开机后熄火', 140),
  259. (231, 1, 40, '开机跳闸', 140),
  260. (232, 1, 40, '漏气', 140),
  261. (233, 1, 40, '漏水', 140),
  262. (234, 1, 40, '有异响', 140);
  263. INSERT INTO `la_fault_type` (`id`, `category_type`, `goods_category_id`, `name`, `pid`) VALUES
  264. (235, 1, 40, '不出热水/不够热', 141),
  265. (236, 1, 40, '不上水', 141),
  266. (237, 1, 40, '不通电', 141),
  267. (238, 1, 40, '出水小', 141),
  268. (239, 1, 40, '点不着火', 141),
  269. (240, 1, 40, '开关扭不动', 141),
  270. (241, 1, 40, '开机后熄火', 141),
  271. (242, 1, 40, '开机跳闸', 141),
  272. (243, 1, 40, '漏气', 141),
  273. (244, 1, 40, '漏水', 141),
  274. (245, 1, 40, '有异响', 141);
  275. INSERT INTO `la_fault_type` (`id`, `category_type`, `goods_category_id`, `name`, `pid`) VALUES
  276. (246, 1, 40, '不出热水/不够热', 142),
  277. (247, 1, 40, '不上水', 142),
  278. (248, 1, 40, '不通电', 142),
  279. (249, 1, 40, '出水小', 142),
  280. (250, 1, 40, '点不着火', 142),
  281. (251, 1, 40, '开关扭不动', 142),
  282. (252, 1, 40, '开机后熄火', 142),
  283. (253, 1, 40, '开机跳闸', 142),
  284. (254, 1, 40, '漏气', 142),
  285. (255, 1, 40, '漏水', 142),
  286. (256, 1, 40, '有异响', 142);
  287. INSERT INTO `la_fault_type` (`id`, `category_type`, `goods_category_id`, `name`, `pid`) VALUES
  288. (257, 1, 40, '不出热水/不够热', 143),
  289. (258, 1, 40, '不上水', 143),
  290. (259, 1, 40, '不通电', 143),
  291. (260, 1, 40, '出水小', 143),
  292. (261, 1, 40, '点不着火', 143),
  293. (262, 1, 40, '开关扭不动', 143),
  294. (263, 1, 40, '开机后熄火', 143),
  295. (264, 1, 40, '开机跳闸', 143),
  296. (265, 1, 40, '漏气', 143),
  297. (266, 1, 40, '漏水', 143),
  298. (267, 1, 40, '有异响', 143);
  299. INSERT INTO `la_fault_type` (`id`, `category_type`, `goods_category_id`, `name`, `pid`) VALUES
  300. (268, 1, 40, '不出热水/不够热', 144),
  301. (269, 1, 40, '不上水', 144),
  302. (270, 1, 40, '不通电', 144),
  303. (271, 1, 40, '出水小', 144),
  304. (272, 1, 40, '点不着火', 144),
  305. (273, 1, 40, '开机后熄火', 144),
  306. (274, 1, 40, '开机跳闸', 144),
  307. (275, 1, 40, '漏气', 144),
  308. (276, 1, 40, '漏水', 144);
  309. INSERT INTO `la_fault_type` (`id`, `category_type`, `goods_category_id`, `name`, `pid`) VALUES
  310. (277, 1, 40, '不出热水/不够热', 145),
  311. (278, 1, 40, '不上水', 145),
  312. (279, 1, 40, '不通电', 145),
  313. (280, 1, 40, '出水小', 145),
  314. (281, 1, 40, '点不着火', 145),
  315. (282, 1, 40, '开机后熄火', 145),
  316. (283, 1, 40, '开机跳闸', 145),
  317. (284, 1, 40, '漏气', 145),
  318. (285, 1, 40, '漏水', 145);
  319. INSERT INTO `la_fault_type` (`id`, `category_type`, `goods_category_id`, `name`, `pid`) VALUES
  320. (286, 1, 40, '不出热水/不够热', 146),
  321. (287, 1, 40, '不上水', 146),
  322. (288, 1, 40, '不通电', 146),
  323. (289, 1, 40, '出水小', 146),
  324. (390, 1, 40, '点不着火', 146),
  325. (291, 1, 40, '开机后熄火', 146),
  326. (292, 1, 40, '开机跳闸', 146),
  327. (293, 1, 40, '漏气', 146),
  328. (294, 1, 40, '漏水', 146);
  329. INSERT INTO `la_fault_type` (`id`, `category_type`, `goods_category_id`, `name`, `pid`) VALUES
  330. (295, 1, 40, '不出热水/不够热', 147),
  331. (296, 1, 40, '不上水', 147),
  332. (297, 1, 40, '不通电', 147),
  333. (298, 1, 40, '出水小', 147),
  334. (299, 1, 40, '点不着火', 147),
  335. (300, 1, 40, '开机后熄火', 147),
  336. (301, 1, 40, '开机跳闸', 147),
  337. (302, 1, 40, '漏气', 147),
  338. (303, 1, 40, '漏水', 147),
  339. (304, 1, 40, '不启动', 147),
  340. (305, 1, 40, '闪灯/显示字母报警', 147),
  341. (306, 1, 40, '有异响', 147);