1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
-- 数据库字段添加
ALTER TABLE ecw_region ADD COLUMN title_fr VARCHAR(255) COMMENT '地区法文';
ALTER TABLE ecw_warehouse ADD COLUMN title_fr VARCHAR(500) COMMENT '法文名称';
ALTER TABLE ecw_warehouse ADD COLUMN address_fr VARCHAR(500) COMMENT '法文地址';
ALTER TABLE ecw_product ADD COLUMN title_fr VARCHAR(255) COMMENT '法文标题';
ALTER TABLE ecw_product_attr ADD COLUMN attr_name_fr VARCHAR(255) COMMENT '属性法文';
ALTER TABLE system_help_doc ADD COLUMN title_fr VARCHAR(500) COMMENT '标题法文';
ALTER TABLE system_help_doc ADD COLUMN content_fr longtext COMMENT '内容法文';
ALTER TABLE system_need_know ADD COLUMN title_fr VARCHAR(500) COMMENT '标题法文';
ALTER TABLE system_need_know ADD COLUMN content_fr longtext COMMENT '内容法文';
ALTER TABLE ecw_unit ADD COLUMN title_fr VARCHAR(100) COMMENT '法文名称';
alter table ecw_currency add column title_fr VARCHAR(100) COMMENT '法文名称';
ALTER TABLE score_rule ADD COLUMN title_fr VARCHAR(255) COMMENT '规则标题法文';
ALTER TABLE score_rule ADD COLUMN desc_fr VARCHAR(255) COMMENT '规则说明法文';
alter table score_rule add COLUMN `cover_image_fr` varchar(255) DEFAULT NULL COMMENT '封面图法文';
ALTER TABLE system_notice ADD COLUMN title_fr VARCHAR(255) COMMENT '公告标题法文';
ALTER TABLE system_notice ADD COLUMN content_fr text COMMENT '公告内容法文';
alter table ecw_order_item add COLUMN `prod_title_fr` varchar(255) DEFAULT NULL COMMENT '产品法文标题';
alter table ecw_order_item add COLUMN `check_prod_title_fr` varchar(255) DEFAULT NULL COMMENT '到仓产品法文英文标题';
alter table ecw_product_brank add COLUMN `title_fr` varchar(255) DEFAULT NULL COMMENT '品牌法文标题';
alter table ecw_channel add COLUMN `name_fr` varchar(64) DEFAULT NULL COMMENT '名称-法文';
alter table ecw_channel add COLUMN `internal_name_fr` varchar(64) DEFAULT NULL COMMENT '内部名称-法文';
alter table ecw_channel add COLUMN `remarks_fr` varchar(255) DEFAULT NULL COMMENT '备注-法文';
alter table ecw_order_time add COLUMN `title_fr` varchar(255) DEFAULT NULL COMMENT '名称-法文';
alter table ecw_order_time add COLUMN `remarks_fr` varchar(255) DEFAULT NULL COMMENT '法文备注';
alter table ecw_country add COLUMN `name_fr` varchar(50) DEFAULT NULL COMMENT '法文名称';
ALTER table ecw_banner ADD COLUMN `title_fr` varchar(255) COMMENT '法文标题';
ALTER table ecw_banner ADD column `content_fr` text COMMENT '法文内容';
-- 渠道表法语内容添加
UPDATE ecw_channel SET name_fr ='Vols préférentiels' WHERE name_zh ='尼特惠';
UPDATE ecw_channel SET name_fr ='Marchandises spéciales (Hong Kong)' WHERE name_zh ='尼特货';
UPDATE ecw_channel SET name_fr ='Vols préférentiels' WHERE name_zh ='尼特惠航班';
UPDATE ecw_channel SET name_fr ='Marchandises normales du Ghana' WHERE name_zh ='加纳特惠';
UPDATE ecw_channel SET name_fr ='Marchandises spéciales du Ghana' WHERE name_zh ='加纳特货';
UPDATE ecw_channel SET name_fr ='vol express-NIG' WHERE name_zh ='尼特快';
UPDATE ecw_channel SET name_fr ='Offre préférentiels-Onitsha' WHERE name_zh ='尼特惠-Onitsha';
UPDATE ecw_channel SET name_fr ='Marchandises spéciales-Kano' WHERE name_zh ='尼特货-kano';
UPDATE ecw_channel SET name_fr ='Marchandises spéciales-Onitsha' WHERE name_zh ='尼特货-Onitsha';
UPDATE ecw_channel SET name_fr ='Offre préférentiels-Kano' WHERE name_zh ='尼特惠-kano';
UPDATE ecw_channel SET name_fr ='transport aérien Tanzanie' WHERE name_zh ='坦桑尼亚空运';
UPDATE ecw_channel SET name_fr ='transport aérien marchandises spéciales Tanzanie' WHERE name_zh ='坦桑特货';
UPDATE ecw_channel SET name_fr ='transport aérien Kenya' WHERE name_zh ='肯尼亚空运';
UPDATE ecw_channel SET name_fr ='transport aérien Kenya' WHERE name_zh ='肯尼亚特货';
UPDATE ecw_channel SET name_fr ='transport maritime & aérien' WHERE name_zh ='海空联运';
UPDATE ecw_channel SET internal_name_fr ='Vols préférentiels' WHERE name_zh ='尼特惠';
UPDATE ecw_channel SET internal_name_fr ='Marchandises spéciales (Hong Kong)' WHERE name_zh ='尼特货';
UPDATE ecw_channel SET internal_name_fr ='Vols préférentiels' WHERE name_zh ='尼特惠航班';
UPDATE ecw_channel SET internal_name_fr ='Marchandises normales du Ghana' WHERE name_zh ='加纳特惠';
UPDATE ecw_channel SET internal_name_fr ='Marchandises spéciales du Ghana' WHERE name_zh ='加纳特货';
UPDATE ecw_channel SET internal_name_fr ='vol express-NIG' WHERE name_zh ='尼特快';
UPDATE ecw_channel SET internal_name_fr ='Offre préférentiels-Onitsha' WHERE name_zh ='尼特惠-Onitsha';
UPDATE ecw_channel SET internal_name_fr ='Marchandises spéciales-Kano' WHERE name_zh ='尼特货-kano';
UPDATE ecw_channel SET internal_name_fr ='Marchandises spéciales-Onitsha' WHERE name_zh ='尼特货-Onitsha';
UPDATE ecw_channel SET internal_name_fr ='Offre préférentiels-Kano' WHERE name_zh ='尼特惠-kano';
UPDATE ecw_channel SET internal_name_fr ='transport aérien Tanzanie' WHERE name_zh ='坦桑尼亚空运';
UPDATE ecw_channel SET internal_name_fr ='transport aérien marchandises spéciales Tanzanie' WHERE name_zh ='坦桑特货';
UPDATE ecw_channel SET internal_name_fr ='transport aérien Kenya' WHERE name_zh ='肯尼亚空运';
UPDATE ecw_channel SET internal_name_fr ='transport aérien Kenya' WHERE name_zh ='肯尼亚特货';
UPDATE ecw_channel SET internal_name_fr ='transport maritime & aérien' WHERE name_zh ='海空联运';
-- 品牌表法语内容添加
update ecw_product_brank set title_en ='Nokia',title_fr ='Nokia' where title_zh= '诺基亚';
update ecw_product_brank set title_en ='samsung',title_fr ='samsung' where title_zh= '三星';
update ecw_product_brank set title_en ='apple',title_fr ='apple' where title_zh= '苹果';
update ecw_product_brank set title_en ='blackeberry',title_fr ='blackeberry' where title_zh= '黑莓';
update ecw_product_brank set title_en ='TECNO',title_fr ='TECNO' where title_zh= 'TECNO';
update ecw_product_brank set title_en ='lenovo',title_fr ='lenovo' where title_zh= '联想';
update ecw_product_brank set title_en ='VIVO',title_fr ='VIVO' where title_zh= 'VIVO';
update ecw_product_brank set title_en ='ZTE',title_fr ='ZTE' where title_zh= '中兴';
update ecw_product_brank set title_en ='huawei',title_fr ='huawei' where title_zh= '华为';
update ecw_product_brank set title_en ='xiaomi',title_fr ='xiaomi' where title_zh= '小米';
update ecw_product_brank set title_en ='OPPO',title_fr ='OPPO' where title_zh= 'OPPO';
update ecw_product_brank set title_en ='sony',title_fr ='sony' where title_zh= '索尼';
update ecw_product_brank set title_en ='motorola',title_fr ='motorola' where title_zh= '摩托罗拉';
update ecw_product_brank set title_en ='sharp',title_fr ='sharp' where title_zh= '夏普';
update ecw_product_brank set title_en ='philips（PHG）',title_fr ='philips（PHG）' where title_zh= '飞利浦';
update ecw_product_brank set title_en ='Fujitsu',title_fr ='Fujitsu' where title_zh= '富士通';
update ecw_product_brank set title_en ='HP（hewlett-packard）',title_fr ='HP（hewlett-packard）' where title_zh= '惠普';
update ecw_product_brank set title_en ='siemens',title_fr ='siemens' where title_zh= '西门子';
update ecw_product_brank set title_en ='dell',title_fr ='dell' where title_zh= '戴尔';
update ecw_product_brank set title_en ='toshiba',title_fr ='toshiba' where title_zh= '东芝';
update ecw_product_brank set title_en ='Mitsubishi ',title_fr ='Mitsubishi ' where title_zh= '三菱';
update ecw_product_brank set title_en ='Panasonic',title_fr ='Panasonic' where title_zh= '松下';
update ecw_product_brank set title_en ='MIRROSOFT',title_fr ='MIRROSOFT' where title_zh= '微软';
update ecw_product_brank set title_en ='Hermes',title_fr ='Hermes' where title_zh= '爱马仕';
update ecw_product_brank set title_en ='LV',title_fr ='LV' where title_zh= 'LV路易威登';
update ecw_product_brank set title_en ='chanel',title_fr ='chanel' where title_zh= '香奈儿';
update ecw_product_brank set title_en ='Prada',title_fr ='Prada' where title_zh= '普拉达';
update ecw_product_brank set title_en =' Bottega Veneta',title_fr =' Bottega Veneta' where title_zh= '葆蝶家';
update ecw_product_brank set title_en ='FENDI',title_fr ='FENDI' where title_zh= '芬迪';
update ecw_product_brank set title_en ='GUCCI',title_fr ='GUCCI' where title_zh= '古驰';
update ecw_product_brank set title_en ='dior',title_fr ='dior' where title_zh= '迪奥';
update ecw_product_brank set title_en ='BALENCIAGA',title_fr ='BALENCIAGA' where title_zh= '巴黎世家';
update ecw_product_brank set title_en ='COACH',title_fr ='COACH' where title_zh= '蔻驰';
update ecw_product_brank set title_en ='ARMANI',title_fr ='ARMANI' where title_zh= '阿玛尼';
update ecw_product_brank set title_en ='MICHAEL KORS',title_fr ='MICHAEL KORS' where title_zh= 'MICHAEL KORS';
update ecw_product_brank set title_en ='MCM',title_fr ='MCM' where title_zh= 'MCM';
update ecw_product_brank set title_en ='Rebecca',title_fr ='Rebecca' where title_zh= '瑞贝卡';
update ecw_product_brank set title_en ='Phillip Lim',title_fr ='Phillip Lim' where title_zh= '菲利林';
update ecw_product_brank set title_en ='KATE SPADE NEWYORK ',title_fr ='KATE SPADE NEWYORK ' where title_zh= 'KATE SPADE NEWYORK ';
update ecw_product_brank set title_en ='Marc by Marc Jacobs',title_fr ='Marc by Marc Jacobs' where title_zh= 'Marc by Marc Jacobs';
update ecw_product_brank set title_en ='Tory Burch',title_fr ='Tory Burch' where title_zh= 'Tory Burch';
update ecw_product_brank set title_en ='FURLA',title_fr ='FURLA' where title_zh= '芙拉';
update ecw_product_brank set title_en ='Diane von Furstenberg',title_fr ='Diane von Furstenberg' where title_zh= 'DVF';
update ecw_product_brank set title_en ='SAINT LAURENT',title_fr ='SAINT LAURENT' where title_zh= '圣罗兰';
update ecw_product_brank set title_en ='GIVENCHY',title_fr ='GIVENCHY' where title_zh= '纪梵希';
update ecw_product_brank set title_en ='CELINE',title_fr ='CELINE' where title_zh= '赛琳';
update ecw_product_brank set title_en ='LONGCHAMP',title_fr ='LONGCHAMP' where title_zh= '珑骧';
update ecw_product_brank set title_en ='MONTAGUT',title_fr ='MONTAGUT' where title_zh= '梦特娇';
update ecw_product_brank set title_en ='GUTTICASA',title_fr ='GUTTICASA' where title_zh= '古缇';
update ecw_product_brank set title_en ='valentino',title_fr ='valentino' where title_zh= '华伦天奴';
update ecw_product_brank set title_en ='DAMBOLO',title_fr ='DAMBOLO' where title_zh= '丹比奴';
update ecw_product_brank set title_en ='MEXICAN',title_fr ='MEXICAN' where title_zh= '稻草人';
update ecw_product_brank set title_en ='NUCELLE',title_fr ='NUCELLE' where title_zh= '纽芝兰';
update ecw_product_brank set title_en ='PIERRERkangaroo',title_fr ='PIERRERkangaroo' where title_zh= '皮尔袋鼠';
update ecw_product_brank set title_en ='FOXER',title_fr ='FOXER' where title_zh= '金狐狸';
update ecw_product_brank set title_en ='LACOSTE',title_fr ='LACOSTE' where title_zh= 'LACOSTE';
update ecw_product_brank set title_en ='LTWFRANE',title_fr ='LTWFRANE' where title_zh= '老人头';
update ecw_product_brank set title_en ='DUNHILL',title_fr ='DUNHILL' where title_zh= '登喜路';
update ecw_product_brank set title_en ='HUGOBOSS',title_fr ='HUGOBOSS' where title_zh= '波士';
update ecw_product_brank set title_en ='POWERLAND',title_fr ='POWERLAND' where title_zh= '保兰德';
update ecw_product_brank set title_en ='camel',title_fr ='camel' where title_zh= '骆驼';
update ecw_product_brank set title_en ='BALENO',title_fr ='BALENO' where title_zh= '班尼路';
update ecw_product_brank set title_en ='OCHIRILY',title_fr ='OCHIRILY' where title_zh= '欧时力';
update ecw_product_brank set title_en ='JEANSWEST',title_fr ='JEANSWEST' where title_zh= '真维斯';
update ecw_product_brank set title_en ='JACK&JONES',title_fr ='JACK&JONES' where title_zh= '杰克琼斯';
update ecw_product_brank set title_en ='Nike',title_fr ='Nike' where title_zh= '耐克';
update ecw_product_brank set title_en ='SUPREME',title_fr ='SUPREME' where title_zh= 'SUPREME';
update ecw_product_brank set title_en ='AIR JORDAN',title_fr ='AIR JORDAN' where title_zh= 'AIR JORDAN';
update ecw_product_brank set title_en ='Puma',title_fr ='Puma' where title_zh= '彪马';
update ecw_product_brank set title_en ='adidas',title_fr ='adidas' where title_zh= '阿迪达斯';
update ecw_product_brank set title_en ='UNDER ARMOUNR',title_fr ='UNDER ARMOUNR' where title_zh= '安德玛';
update ecw_product_brank set title_en ='FILA',title_fr ='FILA' where title_zh= '斐乐';
update ecw_product_brank set title_en ='REEBOK',title_fr ='REEBOK' where title_zh= '锐步';
update ecw_product_brank set title_en ='VANS',title_fr ='VANS' where title_zh= '范思';
update ecw_product_brank set title_en ='BAPE',title_fr ='BAPE' where title_zh= '猿人头';
update ecw_product_brank set title_en ='BOY LONDON',title_fr ='BOY LONDON' where title_zh= '伦敦男孩';
update ecw_product_brank set title_en ='STUSSY',title_fr ='STUSSY' where title_zh= '斯图西';
update ecw_product_brank set title_en ='CHOPARD',title_fr ='CHOPARD' where title_zh= '肖邦';
update ecw_product_brank set title_en ='Rolex',title_fr ='Rolex' where title_zh= '劳力士';
update ecw_product_brank set title_en ='IWC',title_fr ='IWC' where title_zh= '万国';
update ecw_product_brank set title_en ='CARTIER',title_fr ='CARTIER' where title_zh= '卡地亚';
update ecw_product_brank set title_en ='BVLGARI',title_fr ='BVLGARI' where title_zh= '宝格丽';
update ecw_product_brank set title_en ='PANERAI',title_fr ='PANERAI' where title_zh= '沛纳海';
update ecw_product_brank set title_en ='OMEGA',title_fr ='OMEGA' where title_zh= '欧米伽';
update ecw_product_brank set title_en ='CORUM',title_fr ='CORUM' where title_zh= '昆仑';
update ecw_product_brank set title_en ='BREITLING',title_fr ='BREITLING' where title_zh= '百年灵';
update ecw_product_brank set title_en ='HUBLOT',title_fr ='HUBLOT' where title_zh= 'HUBLOT';
update ecw_product_brank set title_en ='BELL&ROSS',title_fr ='BELL&ROSS' where title_zh= '柏莱士';
update ecw_product_brank set title_en ='ZENITH',title_fr ='ZENITH' where title_zh= '真力时';
update ecw_product_brank set title_en ='MONBTLANC',title_fr ='MONBTLANC' where title_zh= '万宝龙';
update ecw_product_brank set title_en ='LONGINES',title_fr ='LONGINES' where title_zh= '浪琴';
update ecw_product_brank set title_en ='TAGHEUER',title_fr ='TAGHEUER' where title_zh= '泰格豪雅';
update ecw_product_brank set title_en ='TUDOR',title_fr ='TUDOR' where title_zh= '帝驼';
update ecw_product_brank set title_en ='MAURICE LACROIX',title_fr ='MAURICE LACROIX' where title_zh= '艾美';
update ecw_product_brank set title_en ='雷达',title_fr ='雷达' where title_zh= '雷达';
update ecw_product_brank set title_en ='NOMOS',title_fr ='NOMOS' where title_zh= '诺莫斯';
update ecw_product_brank set title_en ='BAUME&MERCIER',title_fr ='BAUME&MERCIER' where title_zh= '名士';
update ecw_product_brank set title_en ='MOVADO',title_fr ='MOVADO' where title_zh= '摩凡陀';
update ecw_product_brank set title_en ='BALL',title_fr ='BALL' where title_zh= '波尔';
update ecw_product_brank set title_en ='CONSTANT',title_fr ='CONSTANT' where title_zh= '康思登';
-- 字典表法语添加
UPDATE jiedao.system_dict_data SET label_en='Groupage(LCL)', label_fr='Groupage (LCL)' WHERE label='海运拼柜' and dict_type='transport_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='FCL', label_fr='Conteneur complet (FCL)' WHERE label='海运整柜' and dict_type='transport_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Air freight', label_fr='Fret aérien' WHERE label='专线空运' and dict_type='transport_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Special line', label_fr='Ligne spéciale' WHERE label='专线双清' and dict_type='transport_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Local transportation', label_fr='Transport local' WHERE label='全境派送' and dict_type='transport_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='warehousing', label_fr='Entreposage' WHERE label='仓储服务' and dict_type='transport_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Sea-Air Cargo', label_fr='Cargaison mer-air' WHERE label='海空联运' and dict_type='transport_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Approved', label_fr='Approuvé' WHERE label='审核通过' and dict_type='audit_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Rejected', label_fr='Rejeté' WHERE label='审核不通过' and dict_type='audit_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Pending', label_fr='En attente' WHERE label='审核中' and dict_type='audit_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Unsubmitted', label_fr='Non soumis' WHERE label='未提交审核' and dict_type='audit_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Delayed Release', label_fr='Délai de libération' WHERE label='未及时放货' and dict_type='customer_complaint_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Abnormal Pickup', label_fr='branche anormal' WHERE label='提货点异常' and dict_type='customer_complaint_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Failure to on hold', label_fr='échec du contrôle' WHERE label='控货失败' and dict_type='customer_complaint_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Misloading/omission in warehouse', label_fr='Mauvais chargement/omission en entrepôt' WHERE label='仓库误装/漏装' and dict_type='customer_complaint_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Not Receiving packing list', label_fr='packing list non reçue' WHERE label='收不到提货单' and dict_type='customer_complaint_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Customer Service', label_fr='Service client' WHERE label='客服服务' and dict_type='customer_complaint_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Goods Soaked', label_fr='Marchandises trempées' WHERE label='货物浸水' and dict_type='customer_complaint_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='shipping time', label_fr='Temps d''expédition' WHERE label='空运时效' and dict_type='customer_complaint_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='sea - shipping delayed', label_fr='Mer - retard d''expédition' WHERE label='海运时效-到港慢' and dict_type='customer_complaint_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='sea - clearing delayed', label_fr='Mer - retard de dédouanement' WHERE label='海运时效-清关慢' and dict_type='customer_complaint_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Damaged', label_fr='Endommagé' WHERE label='货物破损' and dict_type='customer_complaint_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Lost', label_fr='Perdu' WHERE label='货物丢失' and dict_type='customer_complaint_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Air Freight Price', label_fr='Prix du fret aérien' WHERE label='空运价格' and dict_type='customer_complaint_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Sea Freight Price', label_fr='Prix du fret maritime' WHERE label='海运价格' and dict_type='customer_complaint_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Mistaken transportation mode', label_fr='Mode de transport anormal' WHERE label='货运方式异常' and dict_type='customer_complaint_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Size(CBM)', label_fr='Taille (CBM)' WHERE label='方数异常' and dict_type='customer_complaint_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Heavy goods', label_fr='Marchandises lourdes' WHERE label='重量异常' and dict_type='customer_complaint_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Pending', label_fr='En attente' WHERE label='待处理' and dict_type='customer_complaint_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Processing', label_fr='En cours de traitement' WHERE label='处理中' and dict_type='customer_complaint_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Processed', label_fr='Traité' WHERE label='已处理' and dict_type='customer_complaint_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Cancelled', label_fr='Annulé' WHERE label='已取消' and dict_type='customer_complaint_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Plastic', label_fr='Plastique' WHERE label='塑料' and dict_type='product_material' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Iron', label_fr='Fer' WHERE label='铁' and dict_type='product_material' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Plastic/Iron', label_fr='Plastique/Fer' WHERE label='塑料/铁' and dict_type='product_material' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Rubber', label_fr='Caoutchouc' WHERE label='橡胶' and dict_type='product_material' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Leather', label_fr='Cuir' WHERE label='皮革' and dict_type='product_material' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Fabric', label_fr='Tissu' WHERE label='布' and dict_type='product_material' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Glass', label_fr='Verre' WHERE label='玻璃' and dict_type='product_material' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Wood', label_fr='Bois' WHERE label='实木/木头' and dict_type='product_material' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Ceramics', label_fr='Céramique' WHERE label='陶瓷' and dict_type='product_material' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Sponge', label_fr='Éponge' WHERE label='海绵' and dict_type='product_material' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Paper', label_fr='Papier' WHERE label='纸' and dict_type='product_material' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Resin', label_fr='Résine' WHERE label='树脂' and dict_type='product_material' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Dacron', label_fr='Dacron' WHERE label='涤纶' and dict_type='product_material' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Alloy', label_fr='Alliage' WHERE label='合金' and dict_type='product_material' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Box', label_fr='Boîte' WHERE label='箱' and dict_type='packaging_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Woven Bag', label_fr='Sac tissé' WHERE label='编织袋' and dict_type='packaging_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Wooden Frame', label_fr='supporte en bois' WHERE label='木架' and dict_type='packaging_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Wooden Box', label_fr='Caisse en bois' WHERE label='木箱' and dict_type='packaging_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Pallet', label_fr='Palette' WHERE label='托' and dict_type='packaging_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='flight case', label_fr='Valise de transport' WHERE label='航空箱' and dict_type='packaging_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Drum', label_fr='Tonneau' WHERE label='桶' and dict_type='packaging_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Compressed', label_fr='Comprimé' WHERE label='压缩包' and dict_type='packaging_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Iron frame', label_fr='Cadre en fer' WHERE label='铁架' and dict_type='packaging_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Overage', label_fr='dépasse' WHERE label='多箱异常' and dict_type='order_error_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Shortage', label_fr='Manque' WHERE label='少箱异常' and dict_type='order_error_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Prepaid', label_fr='Prépayé' WHERE label='产品需要预付异常' and dict_type='order_error_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Lost', label_fr='Perdu' WHERE label='货物丢失异常' and dict_type='order_error_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Overage in destination', label_fr='dépasse à destination' WHERE label='货物增多异常' and dict_type='order_error_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Soaked', label_fr='Trempé' WHERE label='货物浸水异常' and dict_type='order_error_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Damaged', label_fr='Endommagé' WHERE label='货物破损异常' and dict_type='order_error_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Heavy Goods', label_fr='Marchandises lourdes' WHERE label='重货异常' and dict_type='order_error_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Clarance Documents', label_fr='Documents de dédouanement' WHERE label='单证异常' and dict_type='order_error_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Shipper', label_fr='Expéditeur' WHERE label='发货人异常' and dict_type='order_error_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Others', label_fr='Autres' WHERE label='其他异常' and dict_type='order_error_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Collect-on-Delivery', label_fr='Paiement à la livraison' WHERE label='代收货款异常' and dict_type='order_error_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Not Quoted(CN)', label_fr='Non offre' WHERE label='未报价' and dict_type='order_error_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='volume weight', label_fr='Le poids volumique' WHERE label='泡货异常' and dict_type='order_error_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Abnormal Pickup', label_fr='retire anormal' WHERE label='提货异常' and dict_type='order_error_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='No personnel follow-up', label_fr='Pas de suivi du personnel' WHERE label='未分配客户经理异常' and dict_type='order_error_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='new product', label_fr='Nouveau produit' WHERE label='新增商品异常' and dict_type='order_error_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='route inquiry', label_fr='Demande de ligne' WHERE label='线路单询异常' and dict_type='order_error_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Not Quoted', label_fr='Non prix de dedouaner' WHERE label='清关费未报价异常' and dict_type='order_error_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='overweight', label_fr='Surcharge de poids' WHERE label='重量超限异常' and dict_type='order_error_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Shipping method mismatch', label_fr='Inadéquation du mode de transport' WHERE label='不可出渠道异常' and dict_type='order_error_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Weight Difference', label_fr='Différence de poids' WHERE label='货物重量异常' and dict_type='order_error_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Attributes', label_fr='Attributs' WHERE label='入仓特性不符异常' and dict_type='order_error_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='verification', label_fr='Vérification' WHERE label='备货异常' and dict_type='order_error_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='channel exception', label_fr='Exception de canal' WHERE label='渠道异常' and dict_type='order_error_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='charges', label_fr='Frais' WHERE label='费用异常' and dict_type='order_error_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='package', label_fr='Colis' WHERE label='渠道包装重量超限异常' and dict_type='order_error_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Overweight in Route', label_fr='Surcharge sur la route' WHERE label='路线重量超限异常' and dict_type='order_error_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='declaration by EC', label_fr='Déclaration par EC' WHERE label='我司全代' and dict_type='customs_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='declaration by sender', label_fr='Déclaration par l''expéditeur' WHERE label='自单代报' and dict_type='customs_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en=' by sender+EC', label_fr='Par l''expéditeur + EC' WHERE label='混合报关' and dict_type='customs_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='ID Card', label_fr='Carte d''identité' WHERE label='身份证' and dict_type='certificate_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Passport', label_fr='Passeport' WHERE label='护照' and dict_type='certificate_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='clearing By receiver', label_fr='Dédouanement par le destinataire' WHERE label='客户自清' and dict_type='double_clear' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Clearing by EC', label_fr='Dédouanement par EC' WHERE label='我司双清' and dict_type='double_clear' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Pending', label_fr='En attente' WHERE label='待处理' and dict_type='order_exception_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Processing', label_fr='En traitement' WHERE label='处理中' and dict_type='order_exception_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Processed', label_fr='Traité' WHERE label='已处理' and dict_type='order_exception_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Wooden Crate', label_fr='Caisse en bois' WHERE label='打木架' and dict_type='order_special_needs' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en=' Transportation Fee(China)', label_fr='Frais de transport (Chine)' WHERE label='内陆运输费垫付' and dict_type='order_special_needs' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Carton Packaging', label_fr='Emballage en carton' WHERE label='纸箱打包' and dict_type='order_special_needs' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Bagged', label_fr='Emballé dans un sac' WHERE label='袋装' and dict_type='order_special_needs' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en=' Pallet', label_fr='Palette' WHERE label='打木托' and dict_type='order_special_needs' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Wooden Box', label_fr='Caisse en bois' WHERE label='木箱' and dict_type='order_special_needs' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Flight case', label_fr='Valise de transport' WHERE label='航空箱' and dict_type='order_special_needs' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='One-Time', label_fr='Une fois' WHERE label='一次入仓' and dict_type='warehousing_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Warehouse in batches', label_fr='Entrepôt par lots' WHERE label='分批入仓' and dict_type='warehousing_type' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='N', label_fr='N' WHERE label='无品牌' and dict_type='is_brand' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Y', label_fr='Y' WHERE label='有品牌' and dict_type='is_brand' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Draft', label_fr='Brouillon' WHERE label='草稿' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Unquoted', label_fr='Non prix' WHERE label='未设置产品价格' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Pending delivery', label_fr='Livraison en attente' WHERE label='待入仓' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Unquoted', label_fr='Non offre' WHERE label='未报价' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Warehousing in Progress', label_fr='Stockage en cours' WHERE label='入仓中' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Expense application', label_fr='Demande de frais' WHERE label='费用申请' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Received', label_fr='Reçu' WHERE label='已入仓' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='sent out', label_fr='Envoyé' WHERE label='已出货' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='needs to reconfirm', label_fr='Nécessite une reconfirmation' WHERE label='订单异常' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Warehouse Returned', label_fr='Retour à l''entrepôt' WHERE label='已退仓' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Cancel Order', label_fr='Annuler la commande' WHERE label='取消订单' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='departed in transit station', label_fr='Départ de la station de transit' WHERE label='二程起飞' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='paid', label_fr='Payé' WHERE label='已付款' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Collected', label_fr='Collecté' WHERE label='已提货' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Warehouse Transfer', label_fr='Transfert d''entrepôt' WHERE label='调仓中' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='canceled', label_fr='Annulé' WHERE label='已取消' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='application', label_fr='Demande' WHERE label='调仓申请中' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Arrived at Destination', label_fr='Arrivé à destination' WHERE label='二程到目的港' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Verified', label_fr='Vérifié' WHERE label='已核销' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Partial delivery', label_fr='Livraison partielle' WHERE label='部分提货' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='application', label_fr='Demande' WHERE label='调仓申请中' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Consolidated', label_fr='Consolidé' WHERE label='已合单' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='order mergering', label_fr='Fusion de commandes' WHERE label='合单申请中' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='not approved', label_fr='Non approuvé' WHERE label='合单申请未通过' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Split Completed', label_fr='La commande a été divisée' WHERE label='已拆单' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='splitting', label_fr='divisé de commande est en cours' WHERE label='拆单申请中' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='not approved', label_fr='Non approuvé' WHERE label='拆单申请未通过' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='cancelled', label_fr='Annulé' WHERE label='拆单申请已取消' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Preloaded', label_fr='Préchargé' WHERE label='已预装' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Customs declaration', label_fr='Déclaration en douane' WHERE label='已装柜/报关' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='departed', label_fr='Départ' WHERE label='航运中/已起飞' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Arrived at Port', label_fr='Arrivé au port' WHERE label='已到港' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Cleared out', label_fr='Dédouané' WHERE label='已清关' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Arrived warehouse', label_fr='Arrivé à l''entrepôt' WHERE label='已卸柜/已到仓' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Unloaded', label_fr='Déchargé' WHERE label='已卸柜' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Cleared out', label_fr='Dédouané' WHERE label='已清关' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Warehouse Return -unpaid', label_fr='Retour à l''entrepôt - non payé' WHERE label='已退仓-费用未清' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Partial collectted', label_fr='Collecté partiellement' WHERE label='部分提货' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Special offer application', label_fr='Demande d''offre spéciale' WHERE label='特价申请中' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='stocking', label_fr='Mise en stock' WHERE label='理货' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='shipment', label_fr='Expédition' WHERE label='出货' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='stocking', label_fr='Mise en stock' WHERE label='理货' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='shipment', label_fr='Expédition' WHERE label='已出货' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='declared', label_fr='Déclaré' WHERE label='已报关' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Pending preload', label_fr='Préchargement en attente' WHERE label='待排单' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='pending confirmation', label_fr='Confirmation en attente' WHERE label='空运待出' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='confirmed', label_fr='Confirmé' WHERE label='空运可出' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Checked', label_fr='Vérifié' WHERE label='已理货' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='sent out', label_fr='Envoyé' WHERE label='已出仓' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Dispatched', label_fr='Expédié' WHERE label='空运已到港' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='ready', label_fr='Prêt' WHERE label='已备货' and dict_type='order_status' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Freight', label_fr='Fret' WHERE label='运费' and dict_type='custom_drawee' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='clearing fee', label_fr='Frais de dédouanement' WHERE label='清关费' and dict_type='custom_drawee' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Other Charges', label_fr='Autres frais' WHERE label='其他费用' and dict_type='custom_drawee' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Declaration Fee', label_fr='Frais de déclaration' WHERE label='报关费' and dict_type='custom_drawee' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='valuation premium', label_fr='frais d''insurrance' WHERE label='保价费' and dict_type='custom_drawee' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en=' Declaration Fee', label_fr='Frais de déclaration' WHERE label='单证报关费' and dict_type='custom_drawee' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='storage fee', label_fr='Frais de stockage' WHERE label='仓租费' and dict_type='custom_drawee' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en=' Packaging Fee', label_fr='Frais d''emballage' WHERE label='纸箱打包费' and dict_type='custom_drawee' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en=' Transportation Fee(China)', label_fr='Frais de transport (Chine)' WHERE label='内陆运输费' and dict_type='custom_drawee' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Unloading Fee', label_fr='Frais de déchargement' WHERE label='卸货费' and dict_type='custom_drawee' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Forklift Fee', label_fr='Frais de chariot fourche' WHERE label='叉车费' and dict_type='custom_drawee' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Telex release BL', label_fr='BL libéré par télex' WHERE label='电放' and dict_type='suing_method' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Original BL', label_fr='BL original' WHERE label='正本' and dict_type='suing_method' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='self-collection', label_fr='Collecte à stock' WHERE label='自提' and dict_type='harvest_method' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Door to Door', label_fr='Porte à porte' WHERE label='送货上门' and dict_type='harvest_method' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='unresolved', label_fr='Non résolu' WHERE label='待处理' and dict_type='order_no_quote_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='unresolved', label_fr='Non résolu' WHERE label='待处理' and dict_type='order_superfluous_box_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='misdelivery', label_fr='Mauvaise livraison' WHERE label='确认送错' and dict_type='order_superfluous_box_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='customer approved to ship', label_fr='Client approuvé pour l''expédition' WHERE label='已通过客户来/去电确认' and dict_type='order_superfluous_box_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Correct', label_fr='Correct' WHERE label='送货数量准确' and dict_type='order_superfluous_box_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='unresolved', label_fr='Non résolu' WHERE label='待处理' and dict_type='order_lack_box_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Completed', label_fr='Terminé' WHERE label='确认为已齐' and dict_type='order_lack_box_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Incomplete', label_fr='Incomplet' WHERE label='确认为未齐' and dict_type='order_lack_box_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='confirm correct', label_fr='Confirmer correcte' WHERE label='送货数量准确' and dict_type='order_lack_box_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='unresolved', label_fr='Non résolu' WHERE label='待处理' and dict_type='order_pay_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='no prepayment', label_fr='Pas de prépaiement' WHERE label='不需要预付' and dict_type='order_pay_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='The prepaid amount exceeds 80% of sea freight', label_fr='Le montant prépayé dépasse 80 % du fret maritime' WHERE label='已核销预付商品应收明细，超过订单总运费的80%' and dict_type='order_pay_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='The value of the goods exceeds 33% of the total freight and clearing fees', label_fr='La valeur des marchandises dépasse 33 % du fret total et des frais de dédouanement' WHERE label='货值三分之一大于运费和清关费总和' and dict_type='order_pay_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='The value of goods accounts for less than 33% of the total freight and clearing fees', label_fr='La valeur des marchandises représente moins de 33 % du fret total et des frais de dédouanement' WHERE label='预付商品总入仓方数小于订单所有商品总方数33%' and dict_type='order_pay_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='The total cbm of prepaid goods is less than 0.5cbm', label_fr='Le volume total des marchandises prépayées est inférieur à 0,5 m³' WHERE label='订单下预付商品总方数小于0.5cbm' and dict_type='order_pay_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='normal volume', label_fr='Volume normal' WHERE label='设为普货' and dict_type='order_heavy_cargo_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Weight CBM', label_fr='Poids / Volume (m³)' WHERE label='设为已处理' and dict_type='order_heavy_cargo_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Approved', label_fr='Approuvé' WHERE label='已通过' and dict_type='order_doc_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Not Eligible, Please Re-upload', label_fr='Non éligible, veuillez re-télécharger' WHERE label='不符合重新上传' and dict_type='order_doc_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Confirmed with Shipper', label_fr='Confirmé avec l''expéditeur' WHERE label='已和发货人核对' and dict_type='order_consignor_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Collection on Delivery', label_fr='Collecte à la livraison' WHERE label='代收货款' and dict_type='order_cod_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='No Collection on Delivery Required', label_fr='Pas de collecte à la livraison nécessaire' WHERE label='不需要代收货款' and dict_type='order_cod_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='customer approved to ship', label_fr='Client approuvé pour l''expédition' WHERE label='已跟客户确认可发' and dict_type='order_other_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='can not be shipped(Return to sender)', label_fr='Ne peut pas être expédié (Retour à l''expéditeur)' WHERE label='已跟客户确认该货品不可发(退仓)' and dict_type='order_other_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Gross weight', label_fr='Poids brut' WHERE label='设为普货' and dict_type='order_bulky_cargo_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='100% Volume weight', label_fr='Poids volume 100 %' WHERE label='设为已处理' and dict_type='order_bulky_cargo_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='50% volume weight', label_fr='Poids volume 50 %' WHERE label='设为半抛' and dict_type='order_bulky_cargo_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Free Door-to-door', label_fr='Livraison porte-à-porte gratuite' WHERE label='免费送货上门' and dict_type='order_pick_up_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Chargeable', label_fr='Facturable' WHERE label='需要收费' and dict_type='order_pick_up_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Customs inspection and seizure of goods', label_fr='Inspection douanière et saisie des marchandises' WHERE label='海关查验扣货' and dict_type='order_miss_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Warehouse Counting Error', label_fr='Erreur de comptage en entrepôt' WHERE label='仓库清点失误' and dict_type='order_miss_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Chinese warehouse missed loading', label_fr='Manque de chargement en entrepôt chinois' WHERE label='中国仓库漏装' and dict_type='order_miss_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Manifest Discrepancy', label_fr='Discrépance dans le manifeste' WHERE label='manifest核对错误' and dict_type='order_miss_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='diagrams are inconsistent', label_fr='Incohérence des diagrammes' WHERE label='封柜图与卸柜图不一致' and dict_type='order_miss_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Customs inspection and seizure of goods', label_fr='Inspection douanière et saisie des marchandises' WHERE label='海关查验扣货' and dict_type='order_superfluous_goods_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Warehouse Counting Error', label_fr='Erreur de comptage en entrepôt' WHERE label='仓库清点失误' and dict_type='order_superfluous_goods_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Chinese warehouse missed loading', label_fr='Oubli de chargement dans l''entrepôt chinois' WHERE label='中国仓库漏装' and dict_type='order_superfluous_goods_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Manifest Discrepancy', label_fr='Discrépance dans le manifeste' WHERE label='manifest核对错误' and dict_type='order_superfluous_goods_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='diagrams are inconsistent', label_fr='Les diagrammes sont incohérents' WHERE label='封柜图与卸柜图不一致' and dict_type='order_superfluous_goods_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Customs inspection and seizure of goods', label_fr='Inspection douanière et saisie des marchandises' WHERE label='海关查验扣货' and dict_type='order_damage_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Warehouse Counting Error', label_fr='Erreur de comptage en entrepôt' WHERE label='仓库清点失误' and dict_type='order_damage_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Chinese warehouse missed loading', label_fr='Oubli de chargement dans l''entrepôt chinois' WHERE label='中国仓库漏装' and dict_type='order_damage_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Manifest Discrepancy', label_fr='Discrépance dans le manifeste' WHERE label='manifest核对错误' and dict_type='order_damage_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='diagrams are inconsistent', label_fr='Les diagrammes sont incohérents' WHERE label='封柜图与卸柜图不一致' and dict_type='order_damage_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Customs inspection and seizure of goods', label_fr='Inspection douanière et saisie des marchandises' WHERE label='海关查验扣货' and dict_type='order_in_water_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Warehouse Counting Error', label_fr='Erreur de comptage en entrepôt' WHERE label='仓库清点失误' and dict_type='order_in_water_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Chinese warehouse missed loading', label_fr='Oubli de chargement dans l''entrepôt chinois' WHERE label='中国仓库漏装' and dict_type='order_in_water_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Manifest Discrepancy', label_fr='Discrépance dans le manifeste' WHERE label='manifest核对错误' and dict_type='order_in_water_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='The images of the loaded and unloaded sea containers do not match', label_fr='Les images des conteneurs maritimes chargés et déchargés ne correspondent pas.' WHERE label='封柜图与卸柜图不一致' and dict_type='order_in_water_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='unresolved', label_fr='Non résolu' WHERE label='待处理' and dict_type='not_customer_service_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='Assign', label_fr='Attribuer' WHERE label='分配客户经理' and dict_type='not_customer_service_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='No need', label_fr='Pas nécessaire' WHERE label='无需客户经理' and dict_type='not_customer_service_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='unresolved', label_fr='Non résolu' WHERE label='待处理' and dict_type='goods_add_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='The product name already exists in the system, please modify', label_fr='Le nom du produit existe dans le système, veuillez le modifier' WHERE label='系统已有商品,修改入仓信息' and dict_type='goods_add_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='The product name does not exist in the system, please add.', label_fr='Le nom du produit n''existe pas dans le système, veuillez l''ajouter' WHERE label='系统没有此商品,去新增' and dict_type='goods_add_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='unresolved', label_fr='Non résolu' WHERE label='待处理' and dict_type='fee_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='confirmed and ship', label_fr='Confirmé et expédié' WHERE label='已跟客户确认可出' and dict_type='fee_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='don''t be shipped', label_fr='Ne pas expédier' WHERE label='客户不同意发出' and dict_type='fee_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='unresolved', label_fr='Non résolu' WHERE label='待处理' and dict_type='fee_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='confirmed and ship', label_fr='Confirmé et expédié' WHERE label='已跟客户确认可出' and dict_type='fee_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='don''t be shipped', label_fr='Ne pas expédier' WHERE label='客户不同意发出' and dict_type='fee_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='confirmed and ship', label_fr='Confirmé et expédié' WHERE label='已跟客户确认可发' and dict_type='line_loop_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='confirmed return', label_fr='Retour confirmé' WHERE label='已跟客户确认不可发(退货)' and dict_type='line_loop_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='confirmed and ship', label_fr='Confirmé et expédié' WHERE label='已跟客户确认可发' and dict_type='customs_fee_not_quote_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='confirmed return', label_fr='Retour confirmé' WHERE label='已跟客户确认不可发(退货)' and dict_type='customs_fee_not_quote_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='confirmed and ship', label_fr='Confirmé et expédié' WHERE label='已跟客户确认可发' and dict_type='overweight_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='confirmed return', label_fr='Retour confirmé' WHERE label='已跟客户确认不可发(退货)' and dict_type='overweight_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='accept', label_fr='Accepter' WHERE label='允许超出上限' and dict_type='overweight_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='update weight limit', label_fr='Mettre à jour la limite de poids' WHERE label='修改商品重量上限' and dict_type='overweight_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='reject', label_fr='Rejeter' WHERE label='不允许超出上限' and dict_type='overweight_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='unresolved', label_fr='Non résolu' WHERE label='待处理' and dict_type='not_shipping_channel_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='continue', label_fr='Continuer' WHERE label='继续不可出渠道' and dict_type='not_shipping_channel_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='change channel', label_fr='Changer de canal' WHERE label='变更出货渠道' and dict_type='not_shipping_channel_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='weight reason', label_fr='Raison de poids' WHERE label='重量原因' and dict_type='goods_weight_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='other reason', label_fr='Autre raison' WHERE label='其它原因' and dict_type='goods_weight_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='processing', label_fr='En traitement' WHERE label='处理中' and dict_type='in_warehousing_diff_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='processed', label_fr='Traité' WHERE label='已处理' and dict_type='in_warehousing_diff_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='confirmed send', label_fr='Envoi confirmé' WHERE label='已跟客户确认可发' and dict_type='stock_up_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='confirmed return', label_fr='Retour confirmé' WHERE label='已跟客户确认不可发(退货)' and dict_type='stock_up_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='unresolved', label_fr='Non résolu' WHERE label='待处理' and dict_type='channel_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='set shipment channel', label_fr='Définir le canal d''expédition' WHERE label='设置出货渠道' and dict_type='channel_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='confirmed send', label_fr='Envoi confirmé' WHERE label='已跟客户确认可发' and dict_type='channel_packaging_overweight_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='confirmed return', label_fr='Retour confirmé' WHERE label='已跟客户确认不可发(退货)' and dict_type='channel_packaging_overweight_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='accept', label_fr='Accepter' WHERE label='允许超出上限' and dict_type='channel_packaging_overweight_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='update weight limit', label_fr='Mettre à jour la limite de poids' WHERE label='修改渠道重量上限' and dict_type='channel_packaging_overweight_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='reject', label_fr='Rejeter' WHERE label='不允许超出上限' and dict_type='channel_packaging_overweight_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='accept', label_fr='Accepter' WHERE label='允许超出上限' and dict_type='line_weight_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='change limit of route', label_fr='Modifier la limite de la route' WHERE label='修改路线重量' and dict_type='line_weight_exception_result' and deleted !=1;
UPDATE jiedao.system_dict_data SET label_en='reject', label_fr='Rejeter' WHERE label='不许超出' and dict_type='line_weight_exception_result' and deleted !=1;