ä¸ã项ç®èæ¯
ä¼ä¸æ¥å¸¸å·¥ä½ä¸éè¦å¶ä½å¤§éçæ¥è¡¨ï¼æ¯å¦ååçééãéå®é¢ãåºå详æ ãåå·¥æå¡ä¿¡æ¯ãä¿é©æ¥éãåå ¬ç¨åéè´ãå·®æ æ¥éã项ç®è¿åº¦ççï¼é½éè¦å¶ä½ç»è®¡å¾è¡¨ä»¥æ´ç´è§å°æ¥é ãä½æ¯æ¥è¡¨çå¶ä½å¾å¾éè¦è费大éçæ¶é´ï¼å³ä½¿å¤ç¨å¶ä½å¥½çæ¥è¡¨æ¨¡çï¼ä¸æ¬¡æ¬¡å¨ææ§å¯¹æ°æ®çå¤å¶ç²è´´æä½ä¹å¾è人ï¼åæ¶æ¨¡çå¨æ¤è¿ç¨ä¸ä¹ä¼éæ¸åå¾é¢ç®å ¨éã
åºäºæ¤ï¼æ们éè¦æææ°æ®èåéèçå ³èä¿¡æ¯ï¼å°äººå·¥ç常è§æ§æä½æ½ç¦»åºæ¥ï¼ä½¿ç¨å·¥å ·å代ç å»å®ç°ï¼è¿ä¸ªè¿ç¨å°±ç§°ä¹ä¸ºæ¥è¡¨èªå¨åãæå éåå端demo项ç®æºç ï¼å®¶äººä»¬èªè¡ä¸è½½å³å¯ã
äºãæ¥è¡¨èªå¨åçä¼å¿
æ¥è¡¨èªå¨å带æ¥çä»·å¼æåªäºå¢ï¼
1ãèçæ¶é´ï¼æé«æç
身å¤ä¿¡æ¯çç¸çæ¶ä»£ï¼ä»»ä½ä¸å®¶ä¼ä¸é½æä½éåºå¤§ãç»æå¤æãåç§åæ ·çæ°æ®ï¼å¤ç±»æ°æ®äº¤äºèåï¼å¯¹å ¶è¿è¡åæç»å¸¸ä¼´éç大é人åèµæºçæ¶èãèªå¨åæ¥è¡¨éè¿åçç设计ï¼ç¬ç«åºå个ä¸å¡åè½æ¨¡åï¼åç»éå¤å¼ç¨è¯¥æ¨¡åï¼å®ç°éå¤æä½ç代ç å¤ç¨ã
对äºåºå®æµç¨æé»è¾çä¸äºæä½ï¼è®¡ç®æºçæ§è¡é度æ¯äººåä¸å¯åçï¼ä¸ºæ们èçäºæ¶é´ï¼å¯ä»¥æå ¥æ´ææä¹çå·¥ä½ã
2ãéä½åºéç
人工æä½æ»æ¯å太å¤ä¸å¯æ§å ç´ å½±åï¼åå¨åç§åºéçæ½å¨å¯è½ãä¸ä¹ç¸æ¯ï¼èªå¨åæå³çéè¿ç¼ç æ段å®ç°äºæä¹ åçé»è¾ãæµç¨ï¼ç»è¿éå¤çæµè¯éªè¯ä¹åï¼ä¾¿å¯å®å ¨ä¿¡ä»»è¯¥ç¨åºãå¨éå¤æ§çå·¥ä½åºæ¯ä¸æºå¨äº§åºç稳å®æ§è¿é«äºäººå·¥æä½ã
3ãæ¶ææ§é«
æ¥æ¥ãå¨æ¥ãææ¥è¿ç§å¨ææ§çæ¥è¡¨ï¼äººä¸ºæä½å¾é¾æ§å¶æ¶é´çåç¡®æ§ï¼ä½æ¯éè¿ä»£ç æ§å¶å¯ä»¥æ大ç¨åº¦çä¿è¯å ¶å®ç¹è§¦åæä½ã
ä¸ãç³»ç»åè½ç¹
- ä»»å¡é ç½®çµæ´»ï¼æ¯ææ ¹æ®ä¸å¡éæ±ï¼éè¿çé¢æä½æ§å¶ä»»å¡çå¯åç¶æï¼ä»»å¡å¯¹åºçæçæ件类åçã
- æ¥è¡¨æ¨¡ç设计èªç±ï¼ä¸å¡äººåå¯æ ¹æ®å¯¹åºä»»å¡é ç½®çé¢è§æ°æ®èªå®ä¹æ¥è¡¨æ¨¡çï¼ç¶åå°å ¶ä¿åçæã
- å端é¢è§ï¼æ¯æä»å端é¢è§æ¥è¡¨è¯¦æ ã
- å®æ¶åéï¼å®æ¶çææ¥è¡¨æ件并å°å ¶åæ¥å°å¾®ä¿¡ç¾¤ã
- æ¯æå¤ç§ç±»åï¼æ¯æExcelãPDFãå¾è¡¨çæ件类åçæ¥è¡¨æ ¼å¼ã
- æ°æ®èªå¨æ½åï¼å¨æ读åæ°æ®åºä¸çæ°æ®çææ¥è¡¨ã
- 模çåæ°æ®ç¬ç«åå¨ï¼ä½¿ç¨å¨çº¿è¡¨æ ¼è®¾è®¡å¨ç¼è¾æ¨¡çï¼åå¨æ¶åªä¿å模çï¼æ°æ®ä»æ°æ®åºå è½½ã
åãæ¹æ¡è®¾è®¡
1ãæ´ä½æµç¨
æ¥è¡¨èªå¨åçèµ·ç¹æ¯è½å¯¹æ¥æ°æ®æºï¼æé´è½èªå¨åççæäºå è®¾è®¡å¥½æ ¼å¼çæ¥è¡¨ï¼æç»éè¿ä¼ä¸å¾®ä¿¡èªå¨æ¨éæ¶æ¯ãå ·ä½æµç¨å¯ä»¥å为3个æ¥éª¤ï¼
1.æ¥è¡¨æ¨¡ç设计
2.对æ¥æ°æ®æºï¼ä»æ°æ®åºä¸è¯»åæ°æ®ï¼å¨æéé æ°æ®æ¨¡çã
3.èªå¨åè¿ç¨å®ç°ï¼å©ç¨å®æ¶ä»»å¡ï¼å®æ¶æåæ°æ®ï¼åå©GcExcelçæ对åºç±»åçæ件ï¼éè¿å¯¹æ¥ä¼ä¸å¾®ä¿¡çAPIï¼å°æ件åæ¥å°å¾®ä¿¡ç¾¤ã
2ãææ¯æ
å端ï¼react+spreadJs
Demoå°åï¼https://gcdn.grapecity.com.cn/forum.php?mod=attachment&aid=MjM4NzkxfDFhNjNlYjc2fDE2NjYyNDUxMjZ8NjI2NzZ8OTk3MTg%3D
å端ï¼Java+GcExcel+mysql+Quartz
Demoå°åï¼
https://gcdn.grapecity.com.cn/forum.php?mod=attachment&aid=MjM4NzkyfGExOWYxNmQzfDE2NjYyNDUxMjZ8NjI2NzZ8OTk3MTg%3D
3ãå ·ä½å®ç°
3.1 æ°æ®åºè¡¨è®¾è®¡
noteï¼æ¤ä¸ºæµè¯demoï¼æ 没æå建主é®ç´¢å¼ä¹å¤çç´¢å¼ã
3.1.1 ä»»å¡é ç½®å表 task_config
ä¾èµQuartzç»ä»¶å®ç°å®æ¶ä»»å¡ã读åä»»å¡é 置表ä¸å¯å¨ç¶æçä»»å¡é ç½®ï¼æç §ä»»å¡ç±»å读å对åºæ°æ®æºçå¢éæ´æ°æ°æ®ã
å段å称 | å段类å | å段å«ä¹ | å¤æ³¨ |
---|---|---|---|
id | long | ID | èªå¢ä¸»é® |
task_id | varchar | ä»»å¡ID | |
task_type | varchar | ä»»å¡ç±»å | åä»»å¡å 容对åºï¼æ¯å¦è®¢å/ç©æµåä¿¡æ¯ |
task_name | varchar | ä»»å¡å称 | |
task_status | int | ä»»å¡ç¶æ | 1:å¯å¨ 0:ç»æ¢ åªæå¯å¨ç¶æçé ç½®æè½çæä»»å¡ä¿¡æ¯ |
task_context | text | ä»»å¡å 容 | 模çä¿¡æ¯ï¼æç §æ¨¡çç»å®æ°æ®æº |
save_type | char | ä¿åç±»å | ä¿åæ件çç±»å excel/PDF |
time_span | int | æ§è¡ä»»å¡çæ¶é´é´é | åä½sã |
operator | char | æä½è | 便äºè¿½æº¯ |
create_time | dateTime | å建æ¶é´ | |
update_time | dateTime | æ´æ°æ¶é´ |
SQL
CREATE TABLE `task_config` (
`id` INT(11) NOT NULL AUTO_INCREMENT COMMENT 'èªå¢ä¸»é®',
`task_id` VARCHAR(64) NOT NULL DEFAULT '' COMMENT 'ä»»å¡ID',
`task_type` VARCHAR(64) DEFAULT NULL DEFAULT '' COMMENT 'ä»»å¡ç±»å',
`task_name` VARCHAR(128) NOT NULL DEFAULT '' COMMENT 'ä»»å¡å称',
`task_status` TINYINT(4) NOT NULL DEFAULT 0 COMMENT 'ä»»å¡ç¶æï¼1:å¯å¨ 0:ç»æ¢',
`task_context` text COMMENT 'ä»»å¡æ¨¡çä¿¡æ¯',
`time_span` TINYINT(4) NOT NULL DEFAULT 0 COMMENT 'æ¶é´é´éï¼åä½s',
`operator` VARCHAR(64) NOT NULL DEFAULT '' COMMENT 'æä½äºº',
`create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT 'å建æ¶é´',
`update_time` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'æ´æ°æ¶é´',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=INNODB DEFAULT CHARSET=UTF8MB4 COMMENT='ä»»å¡é
置表';
3.1.2 订åä¿¡æ¯è¡¨ order
订åç¸å ³æ°æ®æºä¿¡æ¯ï¼å¯¹åºè®¢åç±»çæ¥è¡¨ä»»å¡ã
å段å称 | å段类å | å段å«ä¹ | å¤æ³¨ |
---|---|---|---|
ID | long | èªå¢ID | |
order_id | char | 订åå· | |
order_amount | decimal | 订åéé¢ | |
order_discount | decimal | 订åä¼æ éé¢ | |
shipping_fee | decimal | 订åè¿è´¹ | |
receiver_name | varchar | ä¸å人å§å | |
receiver_state | varchar | ç | |
receiver_city | varchar | å¸ | |
receiver_district | varchar | åº | |
receiver_address | varchar | 详ç»å°å | |
create_time | dateTime | å建æ¶é´ | |
update_time | dateTime | æ´æ°æ¶é´ |
SQL
CREATE TABLE `order` (
`id` INT(11) NOT NULL AUTO_INCREMENT COMMENT 'èªå¢ä¸»é®',
`order_id` VARCHAR(64) NOT NULL DEFAULT '' COMMENT '订åID',
`order_amount` DECIMAL DEFAULT NULL DEFAULT 0 COMMENT '订åéé¢',
`order_discount` DECIMAL DEFAULT NULL DEFAULT 0 COMMENT '订åææ£éé¢',
`shipping_fee` DECIMAL DEFAULT NULL DEFAULT 0 COMMENT 'è¿è´¹',
`receiver_name` VARCHAR(64) NOT NULL DEFAULT '' COMMENT 'æ¶ä»¶äººå§å',
`receiver_state` VARCHAR(64) NOT NULL DEFAULT '' COMMENT 'ç',
`receiver_city` VARCHAR(64) NOT NULL DEFAULT '' COMMENT 'å¸',
`receiver_district` VARCHAR(64) NOT NULL DEFAULT '' COMMENT 'åº',
`receiver_address` VARCHAR(128) NOT NULL DEFAULT '' COMMENT '详ç»å°å',
`create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT 'å建æ¶é´',
`update_time` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'æ´æ°æ¶é´',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=INNODB DEFAULT CHARSET=UTF8MB4 COMMENT='订å表';
3.1.3 åè´§å表 waybill
åè´§åç¸å ³æ°æ®æºä¿¡æ¯ï¼å¯¹åºåè´§åç±»çæ¥è¡¨ä»»å¡ã
å段å称 | å段类å | å段å«ä¹ | å¤æ³¨ |
---|---|---|---|
ID | long | èªå¢ID | |
order_id | char | 订åå· | |
waybill_id | char | ç©æµåå·ID | |
express_sn | varchar | ç©æµç¼å· | |
express_name | varchar | ç©æµå ¬å¸ | |
receiver_name | varchar | ä¸å人å§å | |
receiver_state | varchar | ç | |
receiver_city | varchar | å¸ | |
receiver_district | varchar | åº | |
receiver_address | varchar | 详ç»å°å | |
out_time | dateTime | åè´§æ¶é´ | |
create_time | dateTime | å建æ¶é´ | |
update_time | dateTime | æ´æ°æ¶é´ |
SQL
CREATE TABLE `waybill` (
`id` INT(11) NOT NULL AUTO_INCREMENT COMMENT 'èªå¢ä¸»é®',
`order_id` VARCHAR(64) NOT NULL DEFAULT '' COMMENT '订åID',
`waybill_id` VARCHAR(64) NOT NULL DEFAULT '' COMMENT 'åè´§åID',
`express_sn` VARCHAR(128) DEFAULT NULL DEFAULT '' COMMENT 'ç©æµåå·',
`express_name` VARCHAR(64) DEFAULT NULL DEFAULT '' COMMENT 'ç©æµå
¬å¸å称',
`receiver_name` VARCHAR(64) NOT NULL DEFAULT '' COMMENT 'æ¶ä»¶äººå§å',
`receiver_state` VARCHAR(64) NOT NULL DEFAULT '' COMMENT 'ç',
`receiver_city` VARCHAR(64) NOT NULL DEFAULT '' COMMENT 'å¸',
`receiver_district` VARCHAR(64) NOT NULL DEFAULT '' COMMENT 'åº',
`receiver_address` VARCHAR(128) NOT NULL DEFAULT '' COMMENT '详ç»å°å',
`out_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT 'åè´§æ¶é´',
`create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT 'å建æ¶é´',
`update_time` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'æ´æ°æ¶é´',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=INNODB DEFAULT CHARSET=UTF8MB4 COMMENT='åè´§å表';
3.2 åè½æ解
1ãå端å®ç°
å端使ç¨Reactæ¡æ¶ï¼åµå ¥äºSpreadJSç»ä»¶ï¼åå§åæ¶ä»å端读åä»»å¡é ç½®å表æ°æ®å¹¶å±ç¤ºãå¯ä»å端é 置任å¡è§åï¼ä¸»è¦æ¯é 置模çä¿¡æ¯ã
2ãå端
å端æ¯ä¸ä¸ªSpringBoot项ç®ï¼åµå ¥GcExcelç»ä»¶å¯¹ç¼è¾ã导åºçæä½ï¼åæ¶åå©Quartzå®æ¶ä»»å¡è°åº¦æ¡æ¶å®ç°å®æ¶ä»»å¡ç管çï¼å¹¶æ¥å ¥äºä¼ä¸å¾®ä¿¡æ´é²ç群æºå¨äººæ¶æ¯å¯¹æ¥APIï¼åéæ¶æ¯å°ä¼ä¸å¾®ä¿¡ç¾¤ã
å®æ¶ä»»å¡è°åº¦æ¡æ¶quartz
Quartzçä¸ä¸ªæ ¸å¿æ¦å¿µï¼è°åº¦å¨ãä»»å¡ã触åå¨ï¼ä¸è ä¹é´çå ³ç³»æ¯ï¼
ä¸ä¸ªä½ä¸ï¼æ¯è¾éè¦çä¸ä¸ªè¦ç´ å°±æ¯Schedulerï¼JobDetailï¼Triggerï¼èTrigger对äºJobèè¨å°±å¥½æ¯ä¸ä¸ªé©±å¨å¨ï¼æ²¡æ触åå¨æ¥å®æ¶é©±å¨ä½ä¸ï¼ä½ä¸å°±æ æ³è¿è¡ï¼å¯¹äºJobèè¨ï¼ä¸ä¸ªJobå¯ä»¥å¯¹åºå¤ä¸ªTriggerï¼ä½å¯¹äºTriggerèè¨ï¼ä¸ä¸ªTriggeråªè½å¯¹åºä¸ä¸ªJobï¼æ以ä¸ä¸ªTriggeråªè½è¢«ææ´¾ç»ä¸ä¸ªJobï¼å¦æä½ éè¦ä¸ä¸ªæ´å¤æç触å计åï¼å¯ä»¥å建å¤ä¸ªTrigger并ææ´¾å®ä»¬ç»åä¸ä¸ªJobã
è°åº¦å¨ç主è¦API
Java
//ç»å®jobDetailä¸trigger
scheduler.scheduleJob(jobDetail, trigger);
//æ£æ¥JobDetailæ¯å¦åå¨
scheduler.checkExists(JobKey.jobKey(name, group))
//æ£æ¥Triggeræ¯å¦åå¨
scheduler.checkExists(TriggerKey.triggerKey(name, group))
//å é¤jobDetail
scheduler.deleteJob(JobKey.jobKey(name, group))
//ç«å³æ§è¡ä¸æ¬¡æå®çä»»å¡
scheduler.triggerJob(JobKey.jobKey(name, group), dataMap)
//å¯å¨ä»»å¡è°åº¦
scheduler.start();
//æåæå®çjob
scheduler.pauseJob(jobKey);
//ä»»å¡è°åº¦æèµ·ï¼å³æåæä½
scheduler.standby();
//å
³éä»»å¡è°åº¦ï¼åshutdown(false)
scheduler.shutdown();
//表示çå¾
æææ£å¨æ§è¡çJobæ§è¡å®æ¯ä¹åï¼åå
³éScheduler
scheduler.shutdown(true);
// 表示ç´æ¥å
³éScheduler
scheduler.shutdown(false);
å®æ¶ä»»å¡åºåè§åï¼
1ã使ç¨cronè¡¨è¾¾å¼ å®æ¶åé
Java
Trigger trigger = TriggerBuilder.newTrigger()
.withIdentity("trigger1", "group1")
.withSchedule(CronScheduleBuilder.cronSchedule("0/5 * * * * ?")) // æ¥å
.build();
JavaScript
//ç«å³å¼å§æ§è¡ï¼2ç§æ§è¡ä¸æ¬¡ï¼éå¤3次ï¼3ç§åç»ææ§è¡ï¼å½éå¤æ¬¡æ°æè
ç»ææ¶é´æä¸ä¸ªå
è¾¾å°æ¶ï¼å°±ä¼åæ¢æ§è¡ï¼
Trigger trigger = TriggerBuilder.newTrigger()
.withIdentity("trigger1", "triggerGroup1")
.startNow()
.withSchedule(SimpleScheduleBuilder.simpleSchedule().withIntervalInSeconds(2).withRepeatCount(3))
.endAt(new Date(new Date().getTime() + 3000L))
.build();
äºãæææ¼ç¤º
使ç¨æ¥éª¤è¯´æï¼
JSON
{"version":"15.0.2","sheetCount":1,"customList":[],"sheets":{"order":{"name":"order","isSelected":true,"rowCount":20,"columnCount":13,"frozenTrailingRowStickToEdge":true,"frozenTrailingColumnStickToEdge":true,"theme":"Office","data":{"defaultDataNode":{"style":{"themeFont":"Body"}}},"rowHeaderData":{"defaultDataNode":{"style":{"themeFont":"Body"}}},"colHeaderData":{"defaultDataNode":{"style":{"themeFont":"Body"}}},"columns":[{"name":"receiverName","displayName":"å§å","size":60,"visible":true},{"name":"orderAmount","displayName":"订åéé¢","size":80,"visible":true},{"name":"orderDiscount","displayName":"订åææ£","size":60,"visible":true}],"leftCellIndex":0,"topCellIndex":0,"selections":{"activeSelectedRangeIndex":-1,"length":0},"autoGenerateColumns":false,"rowOutlines":{"items":[]},"columnOutlines":{"items":[]},"cellStates":{},"states":{},"outlineColumnOptions":{},"autoMergeRangeInfos":[],"charts":[{"name":"Chart 1","x":4,"y":4,"width":480,"height":300,"startRow":0,"startRowOffset":4,"startColumn":0,"startColumnOffset":4,"endRow":15,"endRowOffset":4,"endColumn":7,"endColumnOffset":36,"isSelected":true,"typeName":"2","chartSpace":{"typeName":"chartSpace","roundedCorners":false,"chart":{"title":{"tx":{"rich":{"p":[{"elements":[{"elementType":0,"t":"Amount","rPr":{"latin":{"typeface":"+mn-lt"},"sz":18.67,"b":false,"solidFill":{"schemeClr":{"val":1,"lumMod":[65000],"lumOff":[35000]}}}}],"pPr":{"defRPr":{"latin":{"typeface":"+mn-lt"},"sz":18.67,"b":false,"solidFill":{"schemeClr":{"val":1,"lumMod":[65000],"lumOff":[35000]}}}},"endParaRPr":{}}],"bodyPr":{},"lstStyle":{}}},"overlay":false,"spPr":{"noFill":true,"ln":{"noFill":true},"effectLst":{}}},"autoTitleDeleted":false,"plotArea":{"axes":[{"axisType":0,"axId":59604390,"delete":false,"majorTickMark":2,"minorTickMark":2,"tickLblPos":2,"title":null,"axPos":0,"scaling":{"orientation":1},"spPr":{"ln":{"solidFill":{"schemeClr":{"val":1,"lumMod":[15000],"lumOff":[85000]}}}},"numFmt":{"formatCode":"General"},"txPr":{"p":[{"elements":[{"elementType":0,"t":"","rPr":{"latin":{"typeface":"+mn-lt"},"sz":12,"b":false,"solidFill":{"schemeClr":{"val":1,"lumMod":[65000],"lumOff":[35000]}}}}],"pPr":{"defRPr":{"latin":{"typeface":"+mn-lt"},"sz":12,"b":false,"solidFill":{"schemeClr":{"val":1,"lumMod":[65000],"lumOff":[35000]}}}},"endParaRPr":{}}]},"auto":true,"lblOffset":0,"tickMarkSkip":1,"noMultiLvlLbl":true,"AxisGroup":0,"AxisType":0,"crosses":1,"crossAx":36407267},{"axisType":3,"axId":36407267,"delete":false,"majorTickMark":2,"minorTickMark":2,"tickLblPos":2,"title":null,"axPos":1,"scaling":{"orientation":1},"spPr":{"ln":{"solidFill":{"schemeClr":{"val":1,"lumMod":[15000],"lumOff":[85000]}}}},"numFmt":{"formatCode":"General"},"txPr":{"p":[{"elements":[{"elementType":0,"t":"","rPr":{"latin":{"typeface":"+mn-lt"},"sz":12,"b":false,"solidFill":{"schemeClr":{"val":1,"lumMod":[65000],"lumOff":[35000]}}}}],"pPr":{"defRPr":{"latin":{"typeface":"+mn-lt"},"sz":12,"b":false,"solidFill":{"schemeClr":{"val":1,"lumMod":[65000],"lumOff":[35000]}}}},"endParaRPr":{}}]},"majorGridlines":{"spPr":{"ln":{"solidFill":{"srgbClr":{"val":[217,217,217]}},"w":1},"effectLst":{}}},"AxisGroup":0,"AxisType":1,"crosses":1,"crossBetween":0,"crossAx":59604390}],"chartGroups":[{"chartType":6,"ser":[{"seriesType":0,"idx":0,"order":0,"cat":{"strRef":{"f":"order!$A$1:$A$2"}},"val":{"numRef":{"f":"order!$B$1:$B$2","numCache":{"formatCode":"General"}}},"shape":2,"invertIfNegative":false},{"seriesType":0,"idx":1,"order":1,"cat":{"strRef":{"f":"order!$A$1:$A$2"}},"val":{"numRef":{"f":"order!$C$1:$C$2","numCache":{"formatCode":"General"}}},"shape":2,"invertIfNegative":false}],"axId":[59604390,36407267],"barDir":1,"grouping":1,"gapWidth":150,"varyColors":false,"overlap":-27}],"spPr":{"noFill":true,"ln":{"noFill":true}}},"legend":{"legendPos":4,"spPr":{"noFill":true,"ln":{"noFill":true}},"txPr":{"p":[{"elements":[{"elementType":0,"t":"","rPr":{"latin":{"typeface":"+mn-lt"},"sz":12,"b":false,"solidFill":{"schemeClr":{"val":1,"lumMod":[65000],"lumOff":[35000]}}}}],"pPr":{"defRPr":{"latin":{"typeface":"+mn-lt"},"sz":12,"b":false,"solidFill":{"schemeClr":{"val":1,"lumMod":[65000],"lumOff":[35000]}}}},"endParaRPr":{}}]}},"plotVisOnly":true,"dispBlanksAs":1,"dispNaAsBlank":false},"spPr":{"solidFill":{"schemeClr":{"val":0}},"ln":{"solidFill":{"schemeClr":{"val":1,"lumMod":[15000],"lumOff":[85000]}},"w":1}},"txPr":{"p":[{"elements":[{"elementType":0,"t":"","rPr":{"latin":{"typeface":"+mn-lt"},"b":false,"solidFill":{"schemeClr":{"val":1,"lumMod":[65000],"lumOff":[35000]}}}}],"pPr":{"defRPr":{"latin":{"typeface":"+mn-lt"},"b":false,"solidFill":{"schemeClr":{"val":1,"lumMod":[65000],"lumOff":[35000]}}}},"endParaRPr":{}}]}},"useAnimation":false}],"preserveUnsupportedChartFlag":false,"printInfo":{"paperSize":{"width":850,"height":1100,"kind":1}},"shapeCollectionOption":{"snapMode":0},"index":0}},"sheetTabCount":0,"pivotCaches":{},"i0c":0}