20241203lh.sql 60.5 KB
Newer Older
wux's avatar
wux committed
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
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 '法文备注';
wux's avatar
wux committed
26
alter table ecw_country  add COLUMN  `name_fr` varchar(50) DEFAULT NULL COMMENT '法文名称';
27 28
ALTER table ecw_banner  ADD COLUMN `title_fr` varchar(255)  COMMENT '法文标题';
ALTER table ecw_banner  ADD column `content_fr` text  COMMENT '法文内容';
wux's avatar
wux committed
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

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 ='海空联运';

wux's avatar
wux committed
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
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= '康思登';

wux's avatar
wux committed
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
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;