package net.chenlin.dp.modules.api.service;
import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONObject;
import com.dingtalk.api.DefaultDingTalkClient;
import com.dingtalk.api.DingTalkClient;
import com.dingtalk.api.request.OapiGettokenRequest;
import com.dingtalk.api.request.OapiProcessinstanceCreateRequest;
import com.dingtalk.api.response.OapiGettokenResponse;
import com.dingtalk.api.response.OapiProcessinstanceCreateResponse;
import com.mysql.cj.util.StringUtils;
import com.taobao.api.ApiException;
import net.chenlin.dp.common.openapi4j.examples.voucher.VoucherAdd;
import net.chenlin.dp.common.openapi4j.exception.OpenAPIException;
import net.chenlin.dp.common.openapi4j.service.PersonService;
import net.chenlin.dp.common.openapi4j.util.PropUtil;
import net.chenlin.dp.common.utils.JSONUtils;
import net.chenlin.dp.common.utils.SpringContextUtils;
import net.chenlin.dp.modules.api.controller.DingdingOpenInterface;
import net.chenlin.dp.modules.sys.entity.SyViewEntity;
import net.chenlin.dp.modules.sys.service.testU8Service;
import net.sf.json.JSONArray;
import org.springframework.boot.configurationprocessor.json.JSONException;
import java.math.BigDecimal;
import java.util.*;
public class ReimbursementService {
private testU8Service u8Service= SpringContextUtils.getBean("testU8Service",testU8Service.class);
public static String gettoken = "";
/**
* （不再使用）
* @throws Exception
*/
public static void autoReimbursement() throws Exception {
DingdingOpenInterface dingdingOpenInterface = new DingdingOpenInterface();
Properties prop = PropUtil.getProperties("/config.properties");
String PROC = prop.getProperty("bx_process_code");
List<String> list = dingdingOpenInterface.getOrderIdList(PROC);
String job_number = "";//工号
String work_place = "";//办公地（潍坊对03账套 昆山对01账套）
String dept_code = ""; //部门编码
String account_code = ""; //科目编码
String type = ""; //数据源账套 1昆山，3潍坊
// List<SyViewEntity> listId = u8Service.selectView("报销单");
if(list.size() > 0){
outCycle:for(String o:list){
// if(listId.size() > 0){
// for(SyViewEntity en:listId){
// if(!StringUtils.isNullOrEmpty(en.getOaId()) && en.getOaId().equals(o)){
// continue outCycle;
// }
// }
// }
Map<String,Object> map = dingdingOpenInterface.getOrderDetails("01dc1264-85ab-41a5-8e15-a0905268e1b3");
// Map<String,Object> map = dingdingOpenInterface.getOrderDetails("435bfa21-2366-43e3-b71a-041485d51a31");
// Map<String,Object> map = dingdingOpenInterface.getOrderDetails(o);
if(StringUtils.isNullOrEmpty(map.get("result").toString()) || !map.get("result").toString().equals("agree")){
continue;
}
// System.out.println(map);
Map<String,Object> map1 = tableToMap2(map);
// System.out.println(map1);
Map<String,Object> mapPerson = dingdingOpenInterface.getViewByUserId(map.get("originator_userid").toString());
if(mapPerson !=null ){
job_number = mapPerson.get("job_number").toString();
work_place = mapPerson.get("work_place").toString();
if(StringUtils.isNullOrEmpty(work_place)){
continue;
}
if (work_place.equals("昆山")){
dept_code = getPerson(job_number,"1");
type = "1";
// System.out.println(dept_code);
System.out.println(dept_code);
}else if(work_place.equals("潍坊")){
dept_code = getPerson(job_number,"3");
type = "3";
}else{
continue;
}
}else{
continue;
}
if(map.get("originator_dept_name") == null){
continue;
}
String mess = null;
SyViewEntity entity = new SyViewEntity();
if(map.get("originator_dept_name").toString().equals("营销设计中心-设计部") ||
map.get("originator_dept_name").toString().equals("营销设计中心-项目部") ||
map.get("originator_dept_name").toString().equals("营销设计中心-市场部")){
map1.put("item_class","00");//项目大类 --研发项目
map1.put("item_id","YFYYYY00001");//项目名称 --项目研发-公共
}
if(map1.containsKey("差旅报销") && map1.get("差旅报销")!=null && Double.valueOf(map1.get("差旅报销").toString()) > 0){
account_code = getDeptCode(map.get("originator_dept_name").toString(),"差旅报销");
if(StringUtils.isNullOrEmpty(account_code) || account_code == null || account_code.equals("null")){
continue;
}
map1.put("abstract","差旅报销");
map1.put("naturalCurrency",map1.get("差旅报销"));
map1.put("account_code",account_code);//科目编码
map1.put("dept_code",dept_code);//部门编码
map1.put("job_number",job_number);//人员编码
entity.setParType("差旅报销");
// System.out.println("============================差旅报销"+account_code);
// System.out.println(map1);
try {
// mess = VoucherAdd.addVoucher(map1,map.get("business_id").toString()+"差旅",type);
}catch (Exception e){
mess = e.getMessage();
}
}
if(map1.containsKey("私车公用报销") && map1.get("私车公用报销")!=null && Double.valueOf(map1.get("私车公用报销").toString()) > 0){
account_code = getDeptCode(map.get("originator_dept_name").toString(),"私车公用报销");
if(StringUtils.isNullOrEmpty(account_code) || account_code == null || account_code.equals("null")){
continue;
}
map1.put("abstract","私车公用报销");
map1.put("naturalCurrency",map1.get("私车公用报销"));
map1.put("account_code",account_code);//科目编码
map1.put("dept_code",dept_code);//部门编码
map1.put("job_number",job_number);//人员编码
entity.setParType("私车公用报销");
// System.out.println("============================");
// System.out.println(map1);
// System.out.println("============================私车公用报销"+account_code);
try {
// mess = VoucherAdd.addVoucher(map1,map.get("business_id").toString()+"私车公用",type);
}catch (Exception e){
mess = e.getMessage();
}
}
if(map1.containsKey("其他报销科目") && map1.get("其他报销科目")!=null && Double.valueOf(map1.get("其他报销科目").toString()) > 0){
account_code = getDeptCode(map.get("originator_dept_name").toString(),"其他报销科目");
if(StringUtils.isNullOrEmpty(account_code) || account_code == null || account_code.equals("null")){
continue;
}
map1.put("abstract","其他报销科目");
map1.put("naturalCurrency",map1.get("其他报销科目"));
map1.put("account_code",account_code);//科目编码
map1.put("dept_code",dept_code);//部门编码
map1.put("job_number",job_number);//人员编码
entity.setParType("其他报销科目");
// System.out.println("============================其他报销科目"+account_code+"===="+map.get("originator_dept_name").toString());
// System.out.println("============================");
// System.out.println(map1);
try {
mess = VoucherAdd.addVoucher(map1,map.get("business_id").toString()+"其他",type,"");
}catch (Exception e){
mess = e.getMessage();
}
}
entity.setOaId(o);
entity.setDeptName(map.get("originator_dept_name").toString());
entity.setDeptCode(dept_code);
entity.setAccountCode(account_code);
entity.setJobNumber(job_number);
entity.setTableType("报销单");
entity.setSyMessage(mess);
try {
// u8Service.saveSyView(entity);
}catch (Exception e){
System.out.println("异常1");
}
}
}
}
/**
* 同步银行回单至u8凭证
* @throws Exception
* @param st js:江苏，sd:山东
*/
public void autoReimbursementNew(String st,String upTime) throws Exception {
DingdingOpenInterface dingdingOpenInterface = new DingdingOpenInterface();
Properties prop = PropUtil.getProperties("/config.properties");
String PROC = prop.getProperty("yhhd_process_code");
if(st.equals("sd")){
PROC = prop.getProperty("yhhdsd_process_code");
}
// List<String> list = dingdingOpenInterface.getOrderIdList(PROC);
// List<String> list = dingdingOpenInterface.getOrderIdList2("PROC-C1EBBC4A-AA0D-4101-BEE8-8BFA5FEFABD8",-5);
List<String> list = dingdingOpenInterface.getOrderIdList2(PROC,-31);
// System.out.println(list);
String job_number = "";//工号
String work_place = "";//办公地（潍坊对03账套 昆山对01账套）
String dept_code = ""; //部门编码
String type = ""; //数据源账套 1昆山，3潍坊
List<SyViewEntity> listId = u8Service.selectViewBy31("银行凭证至U8");
if(list.size() > 0){
outCycle:for(String o:list){
if(listId.size() > 0){
for(SyViewEntity en:listId){
if(!StringUtils.isNullOrEmpty(en.getOaId()) && en.getOaId().equals(o)){
continue outCycle;
}
}
}
// Map<String,Object> map = dingdingOpenInterface.getOrderDetails("57942341-3589-43d3-9984-9a786dc9f97d");//
Map<String,Object> map = dingdingOpenInterface.getOrderDetails(o);//
if(StringUtils.isNullOrEmpty(map.get("result").toString()) || !map.get("result").toString().equals("agree")){
continue;
}
Map<String,Object> map1 = tableToMap4(map);
Map<String,Object> mapPerson = dingdingOpenInterface.getViewByUserId((String) map1.get("申请人编码"));
if(mapPerson !=null ){
job_number = mapPerson.get("job_number").toString();//"CHK2019002";
work_place = mapPerson.get("work_place").toString();
if(StringUtils.isNullOrEmpty(work_place)){
continue;
}
if (work_place.equals("昆山")){
dept_code = getPerson(job_number,"1");
type = "1";
}else if(work_place.equals("潍坊")){
dept_code = getPerson(job_number,"3");
type = "3";
}else{
continue;
}
}else{
continue;
}
if(map1.get("申请人所属部门") == null){
continue;
}
//如果是以下部门，则需要填写项目大类和项目名称
if(map1.get("申请人所属部门").toString().equals("营销设计中心-设计部") ||
map1.get("申请人所属部门").toString().equals("营销设计中心-项目部") ||
map1.get("申请人所属部门").toString().equals("营销设计中心-市场部")){
map1.put("item_class","00");//项目大类 --研发项目
map1.put("item_id","YFYYYY00001");//项目名称 --项目研发-公共
}
if(map1.get("单据类型") == null){//备用金申请、报销申请
continue;
}
String mess = null;
map1.put("dept_code",dept_code);//部门编码
map1.put("job_number",job_number);//人员编码
SyViewEntity entity = new SyViewEntity();
entity.setOaId(o);
entity.setDeptName(map1.get("申请人所属部门").toString());
entity.setJobNumber(job_number);
entity.setTableType("银行凭证至U8");
if(map1.get("单据类型").toString().equals("备用金申请")){
entity.setParType("备用金至U8凭证");
map1.put("account_code_jf","122102");//科目编码(借方)
map1.put("account_code_df","10020101");//科目编码(贷方)
JSONArray jsonArray2 = JSONArray.fromObject(map1.get("备用金申请").toString());
if(jsonArray2.size() == 0){
continue ;
}
net.sf.json.JSONObject object1 = jsonArray2.getJSONObject(0);
map1.put("abstract",object1.get("申请事由"));
map1.put("naturalCurrency",object1.get("申请金额"));
try {
mess = VoucherAdd.addVoucher(map1,map.get("business_id").toString()+"备用金",type,upTime);
}catch (Exception e){
mess = e.getMessage();
}
}else if(map1.get("单据类型").toString().equals("报销申请")){
entity.setParType("报销申请至U8");
try {
mess = VoucherAdd.addVoucherNew(map1,map.get("business_id").toString()+"报销申请",type,upTime);
}catch (Exception e){
mess = e.getMessage();
}
}else{
continue ;
}
entity.setSyMessage(mess);
u8Service.saveSyView(entity);
}
}
}
/**
* 同步报销单至银行凭证
* @throws Exception
*/
public void autoOABankReceipt() throws Exception {
DingdingOpenInterface dingdingOpenInterface = new DingdingOpenInterface();
Properties prop = PropUtil.getProperties("/config.properties");
String PROC = prop.getProperty("bx_process_code");//报销单
String YHHD = prop.getProperty("yhhd_process_code");//银行回单（江苏）
String YHHDSD = prop.getProperty("yhhdsd_process_code");//银行回单（山东）
String agentid = prop.getProperty("agentid");
String deptid = prop.getProperty("deptid");
String userid = prop.getProperty("userid");
List<String> list = dingdingOpenInterface.getOrderIdList2(PROC,-20);
// List<String> list = dingdingOpenInterface.getOrderIdList("PROC-DD8FF68E-B90E-4885-8C17-F69E53BE5C81");
System.out.println("报销申请："+list);
List<SyViewEntity> listIdError = u8Service.selectViewByError("报销单至银行凭证");
List<SyViewEntity> listIdTrue = u8Service.selectViewByTrue("报销单至银行凭证");
if(list.size() > 0){
getToken();
outCycle:for(String o:list){
//获取当日同步失败的单据，控制当日不再同步
if(listIdError.size() > 0){
for(SyViewEntity en:listIdError){
if(!StringUtils.isNullOrEmpty(en.getOaId()) && en.getOaId().equals(o)){
continue outCycle;
}
}
}
//获取10天内同步成功的数据，控制不再同步
if(listIdTrue.size() > 0){
for(SyViewEntity en:listIdTrue){
if(!StringUtils.isNullOrEmpty(en.getOaId()) && en.getOaId().equals(o)){
continue outCycle;
}
}
}
// Map<String,Object> map = dingdingOpenInterface.getOrderDetails("e12ca8e8-e783-4652-b68e-e12648ed00c3");
Map<String,Object> map = dingdingOpenInterface.getOrderDetails(o);
if(StringUtils.isNullOrEmpty(map.get("result").toString()) || !map.get("result").toString().equals("agree")){
continue;
}
SyViewEntity entity = new SyViewEntity();
Map<String,Object> newMap = tableToMap2(map);
Map<String,Object> mapPerson = dingdingOpenInterface.getViewByUserId(map.get("originator_userid").toString());
String work_place = null;
if(mapPerson !=null ){
work_place = mapPerson.get("work_place").toString();
if(StringUtils.isNullOrEmpty(work_place)){
continue;
}
if (!work_place.equals("昆山") && !work_place.equals("潍坊")){
continue;
}
}else{
continue;
}
DingTalkClient client = new DefaultDingTalkClient("https://oapi.dingtalk.com/topapi/processinstance/create");
OapiProcessinstanceCreateRequest req = new OapiProcessinstanceCreateRequest();
req.setAgentId(Long.valueOf(agentid));
// req.setProcessCode("PROC-C1EBBC4A-AA0D-4101-BEE8-8BFA5FEFABD8");//银行回单TEST
if (work_place.equals("昆山")){
req.setProcessCode(YHHD);//银行回单（江苏）
}else{
req.setProcessCode(YHHDSD);//银行回单（山东）
}
req.setOriginatorUserId(userid);
req.setDeptId(Long.valueOf(deptid));
List<OapiProcessinstanceCreateRequest.FormComponentValueVo> formComponentValueVoList = new ArrayList<OapiProcessinstanceCreateRequest.FormComponentValueVo>();
//申请人编码
OapiProcessinstanceCreateRequest.FormComponentValueVo formComponentValueV5 = new OapiProcessinstanceCreateRequest.FormComponentValueVo();
formComponentValueV5.setName("申请人编码");
formComponentValueV5.setValue(map.get("originator_userid").toString());
formComponentValueVoList.add(formComponentValueV5);
//申请人名称
OapiProcessinstanceCreateRequest.FormComponentValueVo formComponentValueV6 = new OapiProcessinstanceCreateRequest.FormComponentValueVo();
formComponentValueV6.setName("申请人");
formComponentValueV6.setValue(map.get("title").toString());
formComponentValueVoList.add(formComponentValueV6);
//所属部门
OapiProcessinstanceCreateRequest.FormComponentValueVo formComponentValueV7 = new OapiProcessinstanceCreateRequest.FormComponentValueVo();
formComponentValueV7.setName("申请人所属部门");
formComponentValueV7.setValue(map.get("originator_dept_name").toString());
formComponentValueVoList.add(formComponentValueV7);
//单据类型（报销申请、备用金申请）
OapiProcessinstanceCreateRequest.FormComponentValueVo formComponentValueV8 = new OapiProcessinstanceCreateRequest.FormComponentValueVo();
formComponentValueV8.setName("单据类型");
formComponentValueV8.setValue("报销申请");
formComponentValueVoList.add(formComponentValueV8);
//申请时间
OapiProcessinstanceCreateRequest.FormComponentValueVo formComponentValueV9 = new OapiProcessinstanceCreateRequest.FormComponentValueVo();
formComponentValueV9.setName("申请时间");//create_time
formComponentValueV9.setValue(map.get("create_time").toString());
formComponentValueVoList.add(formComponentValueV9);
//联系人明细
OapiProcessinstanceCreateRequest.FormComponentValueVo formComponentValueVo1 = new OapiProcessinstanceCreateRequest.FormComponentValueVo();
OapiProcessinstanceCreateRequest.FormComponentValueVo Item1 = new OapiProcessinstanceCreateRequest.FormComponentValueVo();
Item1.setName("户名");
if(newMap.get("户名") == null){
continue ;
}
Item1.setValue(newMap.get("户名").toString());
OapiProcessinstanceCreateRequest.FormComponentValueVo Item2 = new OapiProcessinstanceCreateRequest.FormComponentValueVo();
Item2.setName("账号");
if(newMap.get("账号") != null){
Item2.setValue(newMap.get("账号").toString());
}else{
Item2.setValue("空");
}
OapiProcessinstanceCreateRequest.FormComponentValueVo Item3 = new OapiProcessinstanceCreateRequest.FormComponentValueVo();
Item3.setName("开户银行");
if(newMap.get("开户银行") != null){
Item3.setValue(newMap.get("开户银行").toString());
}else{
Item3.setValue("空");
}
formComponentValueVo1.setName("收款人");
formComponentValueVo1.setValue(JSON.toJSONString(Arrays.asList(Arrays.asList(Item1, Item2, Item3))));
formComponentValueVoList.add(formComponentValueVo1);
//差旅报销明细
if(newMap.get("差旅报销") != null && JSONArray.fromObject(newMap.get("差旅报销").toString()).size() > 0){
OapiProcessinstanceCreateRequest.FormComponentValueVo formComponentValueVo2 = new OapiProcessinstanceCreateRequest.FormComponentValueVo();
List<List<OapiProcessinstanceCreateRequest.FormComponentValueVo>> viewList2 = new ArrayList<>();
JSONArray jsonArray1 = JSONArray.fromObject(newMap.get("差旅报销").toString());
for (int j = 0; j < jsonArray1.size(); j++) {
List<OapiProcessinstanceCreateRequest.FormComponentValueVo> view = new ArrayList<>();
net.sf.json.JSONObject object1 = jsonArray1.getJSONObject(j);
if(object1.get("发生日期") != null && object1.get("结束日期") != null && object1.get("发生日期") != "" && object1.get("结束日期") != ""){
OapiProcessinstanceCreateRequest.FormComponentValueVo Item21 = new OapiProcessinstanceCreateRequest.FormComponentValueVo();
JSONArray jsonArray = new JSONArray();
jsonArray.add(object1.get("发生日期").toString());
jsonArray.add(object1.get("结束日期").toString());
Item21.setName("[\"发生日期\",\"结束日期\"]");
Item21.setValue(jsonArray.toString());
// Item21.setValue("[\"2019-02-19\",\"2019-02-25\"]");
view.add(Item21);
}else{
continue ;
}
if(object1.get("报销科目") != null) {
OapiProcessinstanceCreateRequest.FormComponentValueVo Item22 = new OapiProcessinstanceCreateRequest.FormComponentValueVo();
Item22.setName("报销科目");
Item22.setValue(object1.get("报销科目").toString());
view.add(Item22);
}else{
continue ;
}
if(object1.get("名称") != null && object1.get("名称") != "") {
OapiProcessinstanceCreateRequest.FormComponentValueVo Item23 = new OapiProcessinstanceCreateRequest.FormComponentValueVo();
Item23.setName("名称");
Item23.setValue(object1.get("名称").toString());
view.add(Item23);
}
if(object1.get("次数") != null && object1.get("次数") != "") {
OapiProcessinstanceCreateRequest.FormComponentValueVo Item24 = new OapiProcessinstanceCreateRequest.FormComponentValueVo();
Item24.setName("次数");
Item24.setValue(object1.get("次数").toString());
view.add(Item24);
}
if(object1.get("未税金额") != null && object1.get("未税金额") != "") {
OapiProcessinstanceCreateRequest.FormComponentValueVo Item25 = new OapiProcessinstanceCreateRequest.FormComponentValueVo();
Item25.setName("未税金额");
Item25.setValue(object1.get("未税金额").toString());
view.add(Item25);
}else{
continue ;
}
if(object1.get("税额") != null && object1.get("税额") != "") {
OapiProcessinstanceCreateRequest.FormComponentValueVo Item26 = new OapiProcessinstanceCreateRequest.FormComponentValueVo();
Item26.setName("税额");
Item26.setValue(object1.get("税额").toString());
view.add(Item26);
}
if(object1.get("费用说明") != null && object1.get("费用说明") != "") {
OapiProcessinstanceCreateRequest.FormComponentValueVo Item27 = new OapiProcessinstanceCreateRequest.FormComponentValueVo();
Item27.setName("费用说明");
Item27.setValue(object1.get("费用说明").toString());
view.add(Item27);
}
viewList2.add(view);
}
formComponentValueVo2.setName("差旅报销");
formComponentValueVo2.setValue(JSON.toJSONString(viewList2));
formComponentValueVoList.add(formComponentValueVo2);
}
//私车公用报销明细
if(newMap.get("私车公用报销") != null && JSONArray.fromObject(newMap.get("私车公用报销").toString()).size() > 0) {
OapiProcessinstanceCreateRequest.FormComponentValueVo formComponentValueVo3 = new OapiProcessinstanceCreateRequest.FormComponentValueVo();
List<List<OapiProcessinstanceCreateRequest.FormComponentValueVo>> viewList3 = new ArrayList<>();
JSONArray jsonArray1 = JSONArray.fromObject(newMap.get("私车公用报销").toString());
for (int j = 0; j < jsonArray1.size(); j++) {
List<OapiProcessinstanceCreateRequest.FormComponentValueVo> view = new ArrayList<>();
net.sf.json.JSONObject object1 = jsonArray1.getJSONObject(j);
if(object1.get("发生日期") != null && object1.get("结束日期") != null && object1.get("发生日期") != "" && object1.get("结束日期") != ""){
OapiProcessinstanceCreateRequest.FormComponentValueVo Item31 = new OapiProcessinstanceCreateRequest.FormComponentValueVo();
// Item31.setName("[\"发生日期\",\"结束日期\"]");
// Item31.setValue("[\"2019-02-19\",\"2019-02-25\"]");
// view.add(Item31);
JSONArray jsonArray = new JSONArray();
jsonArray.add(object1.get("发生日期").toString());
jsonArray.add(object1.get("结束日期").toString());
Item31.setName("[\"发生日期\",\"结束日期\"]");
Item31.setValue(jsonArray.toString());
view.add(Item31);
}else{
continue ;
}
if(object1.get("报销科目") != null) {
OapiProcessinstanceCreateRequest.FormComponentValueVo Item32 = new OapiProcessinstanceCreateRequest.FormComponentValueVo();
Item32.setName("报销科目");
Item32.setValue(object1.get("报销科目").toString());
view.add(Item32);
}else{
continue ;
}
if(object1.get("行程") != null) {
OapiProcessinstanceCreateRequest.FormComponentValueVo Item33 = new OapiProcessinstanceCreateRequest.FormComponentValueVo();
Item33.setName("行程");
Item33.setValue(object1.get("行程").toString());
view.add(Item33);
}
if(object1.get("次数") != null) {
OapiProcessinstanceCreateRequest.FormComponentValueVo Item34 = new OapiProcessinstanceCreateRequest.FormComponentValueVo();
Item34.setName("次数");
Item34.setValue(object1.get("次数").toString());
view.add(Item34);
}
if(object1.get("未税金额") != null) {
OapiProcessinstanceCreateRequest.FormComponentValueVo Item35 = new OapiProcessinstanceCreateRequest.FormComponentValueVo();
Item35.setName("未税金额");
Item35.setValue(object1.get("未税金额").toString());
view.add(Item35);
}else{
continue ;
}
if(object1.get("税额") != null) {
OapiProcessinstanceCreateRequest.FormComponentValueVo Item36 = new OapiProcessinstanceCreateRequest.FormComponentValueVo();
Item36.setName("税额");
Item36.setValue(object1.get("税额").toString());
view.add(Item36);
}
if(object1.get("费用说明") != null) {
OapiProcessinstanceCreateRequest.FormComponentValueVo Item37 = new OapiProcessinstanceCreateRequest.FormComponentValueVo();
Item37.setName("费用说明");
Item37.setValue(object1.get("费用说明").toString());
view.add(Item37);
}
// viewList3.add(Arrays.asList(Item31, Item32, Item33, Item34, Item35, Item36, Item37));
viewList3.add(view);
}
formComponentValueVo3.setName("私车公用报销");
formComponentValueVo3.setValue(JSON.toJSONString(viewList3));
formComponentValueVoList.add(formComponentValueVo3);
}
//其他报销科目明细
if(newMap.get("其他报销科目") != null && JSONArray.fromObject(newMap.get("其他报销科目").toString()).size() > 0) {
OapiProcessinstanceCreateRequest.FormComponentValueVo formComponentValueVo4 = new OapiProcessinstanceCreateRequest.FormComponentValueVo();
List<List<OapiProcessinstanceCreateRequest.FormComponentValueVo>> viewList4 = new ArrayList<>();
JSONArray jsonArray1 = JSONArray.fromObject(newMap.get("其他报销科目").toString());
for (int j = 0; j < jsonArray1.size(); j++) {
List<OapiProcessinstanceCreateRequest.FormComponentValueVo> view = new ArrayList<>();
net.sf.json.JSONObject object1 = jsonArray1.getJSONObject(j);
if(object1.get("发生日期") != null && object1.get("结束日期") != null && object1.get("发生日期") != "" && object1.get("结束日期") != ""){
OapiProcessinstanceCreateRequest.FormComponentValueVo Item41 = new OapiProcessinstanceCreateRequest.FormComponentValueVo();
// Item41.setName("[\"发生日期\",\"结束日期\"]");
// Item41.setValue("[\"2019-02-19\"");
// view.add(Item41);
JSONArray jsonArray = new JSONArray();
jsonArray.add(object1.get("发生日期").toString());
jsonArray.add(object1.get("结束日期").toString());
Item41.setName("[\"发生日期\",\"结束日期\"]");
Item41.setValue(jsonArray.toString());
view.add(Item41);
}else{
continue ;
}
if(object1.get("报销科目") != null) {
OapiProcessinstanceCreateRequest.FormComponentValueVo Item42 = new OapiProcessinstanceCreateRequest.FormComponentValueVo();
Item42.setName("报销科目");
Item42.setValue(object1.get("报销科目").toString());
view.add(Item42);
}else{
continue ;
}
if(object1.get("名称") != null) {
OapiProcessinstanceCreateRequest.FormComponentValueVo Item43 = new OapiProcessinstanceCreateRequest.FormComponentValueVo();
Item43.setName("名称");
Item43.setValue(object1.get("名称").toString());
view.add(Item43);
}
if(object1.get("单位") != null) {
OapiProcessinstanceCreateRequest.FormComponentValueVo Item44 = new OapiProcessinstanceCreateRequest.FormComponentValueVo();
Item44.setName("单位");
Item44.setValue(object1.get("单位").toString());
view.add(Item44);
}
if(object1.get("数量") != null) {
OapiProcessinstanceCreateRequest.FormComponentValueVo Item48 = new OapiProcessinstanceCreateRequest.FormComponentValueVo();
Item48.setName("数量");
Item48.setValue(object1.get("数量").toString());
view.add(Item48);
}
if(object1.get("未税金额") != null) {
OapiProcessinstanceCreateRequest.FormComponentValueVo Item45 = new OapiProcessinstanceCreateRequest.FormComponentValueVo();
Item45.setName("未税金额");
Item45.setValue(object1.get("未税金额").toString());
view.add(Item45);
}else{
continue ;
}
if(object1.get("税额") != null) {
OapiProcessinstanceCreateRequest.FormComponentValueVo Item46 = new OapiProcessinstanceCreateRequest.FormComponentValueVo();
Item46.setName("税额");
Item46.setValue(object1.get("税额").toString());
view.add(Item46);
}
if(object1.get("费用说明") != null) {
OapiProcessinstanceCreateRequest.FormComponentValueVo Item47 = new OapiProcessinstanceCreateRequest.FormComponentValueVo();
Item47.setName("费用说明");
Item47.setValue(object1.get("费用说明").toString());
view.add(Item47);
}
// viewList4.add(Arrays.asList(Item41, Item42, Item43, Item44, Item48, Item45, Item46, Item47));
viewList4.add(view);
}
if(viewList4.size() > 0){
formComponentValueVo4.setName("其他报销科目");
formComponentValueVo4.setValue(JSON.toJSONString(viewList4));
formComponentValueVoList.add(formComponentValueVo4);
}
}
req.setFormComponentValues(formComponentValueVoList);
String useridshenh = prop.getProperty("shenhe_userid");
if (!useridshenh.equals("")){
List<OapiProcessinstanceCreateRequest.ProcessInstanceApproverVo> processInstanceApproverVoList = new ArrayList<OapiProcessinstanceCreateRequest.ProcessInstanceApproverVo>();
OapiProcessinstanceCreateRequest.ProcessInstanceApproverVo processInstanceApproverVo = new OapiProcessinstanceCreateRequest.ProcessInstanceApproverVo();
processInstanceApproverVoList.add(processInstanceApproverVo);
processInstanceApproverVo.setTaskActionType("NONE");
processInstanceApproverVo.setUserIds(Arrays.asList(useridshenh));
req.setApproversV2(processInstanceApproverVoList);
}
OapiProcessinstanceCreateResponse rsp = client.execute(req, gettoken);
entity.setOaId(o);
entity.setOaNid(rsp.getProcessInstanceId());
entity.setDeptName(map.get("originator_dept_name").toString());
entity.setJobNumber(map.get("title").toString());
entity.setTableType("报销单至银行凭证");
entity.setSyMessage(rsp.getErrmsg());
if(rsp.isSuccess()){
entity.setSyState("true");
}else{
entity.setSyState("false");
}
try {
u8Service.saveSyView(entity);
}catch (Exception e){
System.out.println("异常2同步报销单至银行凭证");
}
// System.out.println("============"+JSON.toJSONString(rsp));
// System.out.println("============"+JSON.toJSONString(rsp.getErrmsg()));
// System.out.println("============"+JSON.toJSONString(rsp.isSuccess()));
}
}
}
public static Map<String,Object> tableToMap4(Map<String,Object> map1) throws Exception {
List<Map<String,Object>> listMap = (List<Map<String, Object>>) map1.get("form_component_values");
Map<String,Object> newMap = new HashMap<String,Object>();
// System.out.println(map1);
for(Map<String, Object> o:listMap){
if(o.get("name")==null || StringUtils.isNullOrEmpty(o.get("name").toString())){
continue;
}
if(o.get("name").equals("申请人编码") && o.get("value") != null){
newMap.put("申请人编码",o.get("value"));
}
if(o.get("name").equals("申请人所属部门") && o.get("value") != null){
newMap.put("申请人所属部门",o.get("value"));
}
if(o.get("name").equals("申请人") && o.get("value") != null){
newMap.put("申请人",o.get("value"));
}
if(o.get("name").equals("单据类型") && o.get("value") != null){
newMap.put("单据类型",o.get("value"));
}
if(o.get("name").equals("收款人") && o.get("value") != null){
JSONArray jsonArray = JSONArray.fromObject(o.get("value").toString());
if(jsonArray.size() > 0){
List<Map<String,Object>> listView = new ArrayList<>();
for(int i=0;i<jsonArray.size();i++){
net.sf.json.JSONObject object = jsonArray.getJSONObject(i);
if(object.get("rowValue") == null || object.get("rowValue") == ""){
continue;
}
JSONArray jsonArray1 = JSONArray.fromObject(object.get("rowValue").toString());
JSONObject map = new JSONObject();
if(jsonArray1.size() > 0){
for(int j=0;j<jsonArray1.size();j++){
net.sf.json.JSONObject object1 = jsonArray1.getJSONObject(j);
map.put(object1.get("label").toString(),object1.get("value"));
}
listView.add(map);
}
}
newMap.put("收款人",listView);
}
}
if(o.get("name").equals("备用金申请") && o.get("value") != null){
JSONArray jsonArray = JSONArray.fromObject(o.get("value").toString());
if(jsonArray.size() > 0){
List<Map<String,Object>> listView = new ArrayList<>();
for(int i=0;i<jsonArray.size();i++){
net.sf.json.JSONObject object = jsonArray.getJSONObject(i);
if(object.get("rowValue") == null || object.get("rowValue") == ""){
continue;
}
JSONArray jsonArray1 = JSONArray.fromObject(object.get("rowValue").toString());
JSONObject map = new JSONObject();
if(jsonArray1.size() > 0){
for(int j=0;j<jsonArray1.size();j++){
net.sf.json.JSONObject object1 = jsonArray1.getJSONObject(j);
if(object1.get("label").toString().equals("[\"使用日期\",\"归还日期\"]")){
JSONArray aa = JSONArray.fromObject(object1.get("value"));
if(aa.size() > 1){
map.put("使用日期",aa.get(0));
map.put("归还日期",aa.get(1));
}
}else{
map.put(object1.get("label").toString(),object1.get("value"));
}
}
listView.add(map);
}
}
newMap.put("备用金申请",listView);
}
}
if(o.get("name").equals("差旅报销") && o.get("value") != null){
JSONArray jsonArray = JSONArray.fromObject(o.get("value").toString());
if(jsonArray.size() > 0){
List<Map<String,Object>> listView = new ArrayList<>();
for(int i=0;i<jsonArray.size();i++){
net.sf.json.JSONObject object = jsonArray.getJSONObject(i);
if(object.get("rowValue") == null || object.get("rowValue") == ""){
continue;
}
JSONArray jsonArray1 = JSONArray.fromObject(object.get("rowValue").toString());
JSONObject map = new JSONObject();
if(jsonArray1.size() > 0){
for(int j=0;j<jsonArray1.size();j++){
net.sf.json.JSONObject object1 = jsonArray1.getJSONObject(j);
if(object1.get("label").toString().equals("[\"发生日期\",\"结束日期\"]")){
JSONArray aa = JSONArray.fromObject(object1.get("value"));
if(aa.size() > 1){
map.put("发生日期",aa.get(0));
map.put("结束日期",aa.get(1));
}
}else{
map.put(object1.get("label").toString(),object1.get("value"));
}
}
listView.add(map);
}
}
newMap.put("差旅报销",listView);
}
}
if(o.get("name").equals("私车公用报销") && o.get("value") != null){
JSONArray jsonArray = JSONArray.fromObject(o.get("value").toString());
if(jsonArray.size() > 0){
List<Map<String,Object>> listView = new ArrayList<>();
for(int i=0;i<jsonArray.size();i++){
net.sf.json.JSONObject object = jsonArray.getJSONObject(i);
if(object.get("rowValue") == null || object.get("rowValue") == ""){
continue;
}
JSONArray jsonArray1 = JSONArray.fromObject(object.get("rowValue").toString());
JSONObject map = new JSONObject();
if(jsonArray1.size() > 0){
for(int j=0;j<jsonArray1.size();j++){
net.sf.json.JSONObject object1 = jsonArray1.getJSONObject(j);
if(object1.get("label").toString().equals("[\"发生日期\",\"结束日期\"]")){
JSONArray aa = JSONArray.fromObject(object1.get("value"));
if(aa.size() > 1){
map.put("发生日期",aa.get(0));
map.put("结束日期",aa.get(1));
}
}else{
map.put(object1.get("label").toString(),object1.get("value"));
}
}
listView.add(map);
}
}
newMap.put("私车公用报销",listView);
}
}
if(o.get("name").equals("其他报销科目") && o.get("value") != null){
JSONArray jsonArray = JSONArray.fromObject(o.get("value").toString());
if(jsonArray.size() > 0){
List<Map<String,Object>> listView = new ArrayList<>();
for(int i=0;i<jsonArray.size();i++){
net.sf.json.JSONObject object = jsonArray.getJSONObject(i);
if(object.get("rowValue") == null || object.get("rowValue") == ""){
continue;
}
JSONArray jsonArray1 = JSONArray.fromObject(object.get("rowValue").toString());
JSONObject map = new JSONObject();
if(jsonArray1.size() > 0){
for(int j=0;j<jsonArray1.size();j++){
net.sf.json.JSONObject object1 = jsonArray1.getJSONObject(j);
if(object1.get("label").toString().equals("[\"发生日期\",\"结束日期\"]")){
JSONArray aa = JSONArray.fromObject(object1.get("value"));
if(aa.size() > 1){
map.put("发生日期",aa.get(0));
map.put("结束日期",aa.get(1));
}
}else{
map.put(object1.get("label").toString(),object1.get("value"));
}
}
listView.add(map);
}
}
newMap.put("其他报销科目",listView);
}
}
}
return newMap;
}
public static Map<String,Object> tableToMap2(Map<String,Object> map1) throws Exception {
List<Map<String,Object>> listMap = (List<Map<String, Object>>) map1.get("form_component_values");
Map<String,Object> newMap = new HashMap<String,Object>();
for(Map<String, Object> o:listMap){
if(o.get("component_type").equals("RecipientAccountField")){
Map<String,Object> mapValue = JSONUtils.jsonToMap((String) o.get("ext_value"));
newMap.put("户名",mapValue.get("name"));
newMap.put("账号",mapValue.get("cardNo"));
newMap.put("开户银行",mapValue.get("instName"));
}
if(o.get("name")==null || StringUtils.isNullOrEmpty(o.get("name").toString())){
continue;
}
if(o.get("name").equals("收款账号") && o.get("value") != null && newMap.get("账号") == null){
newMap.put("账号",o.get("value"));
}
if(o.get("name").equals("差旅报销") && o.get("value") != null){
JSONArray jsonArray = JSONArray.fromObject(o.get("value").toString());
if(jsonArray.size() > 0){
List<Map<String,Object>> listView = new ArrayList<>();
for(int i=0;i<jsonArray.size();i++){
net.sf.json.JSONObject object = jsonArray.getJSONObject(i);
JSONArray jsonArray1 = JSONArray.fromObject(object.get("rowValue").toString());
// Map<String,Object> map = new HashMap<>();
JSONObject map = new JSONObject();
if(jsonArray1.size() > 0){
for(int j=0;j<jsonArray1.size();j++){
net.sf.json.JSONObject object1 = jsonArray1.getJSONObject(j);
if(object1.get("label").toString().equals("[\"发生日期\",\"结束日期\"]")){
List<String> aa = (List<String>) object1.get("value");
if(aa.size() > 1){
map.put("发生日期",aa.get(0));
map.put("结束日期",aa.get(1));
}
}else if(object1.get("label").toString().equals("报销科目")){
List<String> aa = (List<String>) object1.get("value");
if(aa.size() > 0){
map.put("报销科目",aa.get(0));
}
}else{
map.put(object1.get("label").toString(),object1.get("value"));
}
}
listView.add(map);
}
}
newMap.put("差旅报销",listView);
}
}
if(o.get("name").equals("私车公用报销") && o.get("value") != null){
JSONArray jsonArray = JSONArray.fromObject(o.get("value").toString());
if(jsonArray.size() > 0){
List<Map<String,Object>> listView = new ArrayList<>();
for(int i=0;i<jsonArray.size();i++){
net.sf.json.JSONObject object = jsonArray.getJSONObject(i);
JSONArray jsonArray1 = JSONArray.fromObject(object.get("rowValue").toString());
// Map<String,Object> map = new HashMap<>();
JSONObject map = new JSONObject();
if(jsonArray1.size() > 0){
for(int j=0;j<jsonArray1.size();j++){
net.sf.json.JSONObject object1 = jsonArray1.getJSONObject(j);
if(object1.get("label").toString().equals("[\"发生日期\",\"结束日期\"]")){
List<String> aa = (List<String>) object1.get("value");
if(aa.size() > 1){
map.put("发生日期",aa.get(0));
map.put("结束日期",aa.get(1));
}
}else if(object1.get("label").toString().equals("报销科目")){
List<String> aa = (List<String>) object1.get("value");
if(aa.size() > 0){
map.put("报销科目",aa.get(0));
}
}else{
map.put(object1.get("label").toString(),object1.get("value"));
}
}
listView.add(map);
}
}
newMap.put("私车公用报销",listView);
}
}
if(o.get("name").equals("其他报销科目") && o.get("value") != null){
JSONArray jsonArray = JSONArray.fromObject(o.get("value").toString());
if(jsonArray.size() > 0){
List<Map<String,Object>> listView = new ArrayList<>();
for(int i=0;i<jsonArray.size();i++){
net.sf.json.JSONObject object = jsonArray.getJSONObject(i);
JSONArray jsonArray1 = JSONArray.fromObject(object.get("rowValue").toString());
// Map<String,Object> map = new HashMap<>();
JSONObject map = new JSONObject();
if(jsonArray1.size() > 0){
for(int j=0;j<jsonArray1.size();j++){
net.sf.json.JSONObject object1 = jsonArray1.getJSONObject(j);
if(object1.get("label").toString().equals("[\"发生日期\",\"结束日期\"]")){
List<String> aa = (List<String>) object1.get("value");
if(aa.size() > 1){
map.put("发生日期",aa.get(0));
map.put("结束日期",aa.get(1));
}
}else if(object1.get("label").toString().equals("报销科目")){
List<String> aa = (List<String>) object1.get("value");
if(aa.size() > 0){
map.put("报销科目",aa.get(0));
}
}else{
map.put(object1.get("label").toString(),object1.get("value"));
}
}
listView.add(map);
}
}
newMap.put("其他报销科目",listView);
}
}
}
// System.out.println("=========================");
// System.out.println("=========================");
return newMap;
}
public static Map<String,Object> tableToMap3(Map<String,Object> map1){
List<Map<String,Object>> listMap = (List<Map<String, Object>>) map1.get("form_component_values");
// System.out.println(listMap);
Map<String,Object> newMap = new HashMap<>();
int st = 0;
for(Map<String, Object> o:listMap){
// System.out.println(o);
// System.out.println("=========================");
if(o.get("name")==null || StringUtils.isNullOrEmpty(o.get("name").toString())){
continue;
}
if(o.get("name").equals("差旅报销")){
st = 1;
}
if(o.get("name").equals("私车公用报销")){
st = 2;
}
if(o.get("name").equals("其他报销科目")){
st = 3;
}
if(st == 1 && o.get("name").equals("合计")){
if(newMap.containsKey("差旅报销")){
newMap.put("差旅报销",Double.valueOf(o.get("value").toString())+Double.valueOf(newMap.get("差旅报销").toString()) );
}else {
newMap.put("差旅报销",o.get("value"));
}
}
if(st == 2 && o.get("name").equals("合计")){
if(newMap.containsKey("私车公用报销")){
newMap.put("私车公用报销",Double.valueOf(o.get("value").toString())+Double.valueOf(newMap.get("私车公用报销").toString()) );
}else {
newMap.put("私车公用报销",o.get("value"));
}
}
if(st == 3 && o.get("name").equals("合计")){
if(newMap.containsKey("其他报销科目")){
newMap.put("其他报销科目",Double.valueOf(o.get("value").toString())+Double.valueOf(newMap.get("其他报销科目").toString()) );
}else {
newMap.put("其他报销科目",o.get("value"));
}
}
}
return newMap;
}
/**
* 通过部门名称对应u8科目编码
* @param dept
* @return
*/
public static String getDeptCode(String dept,String type){
if(dept.equals("营销设计中心-总经理室") || dept.equals("营销设计中心-采购部") || dept.equals("共享中心-财务部") || dept.equals("共享中心-人事行政部")){
if("差旅报销".equals(type)){
return "66020704";
}else if("私车公用报销".equals(type)){
return "66020702";
}else{
return "66020706";
}
}else if(dept.equals("营销设计中心-销售部")){
if("差旅报销".equals(type)){
return "6601070104";
}else if("私车公用报销".equals(type)){
return "6601070102";
}else{
return "6601070106";
}
}else if(dept.equals("营销设计中心-设计部")){
if("差旅报销".equals(type)){
return "66040704";
}else if("私车公用报销".equals(type)){
return "66040702";
}else{
return "66040706";
}
}else if(dept.equals("营销设计中心-项目部") || dept.equals("营销设计中心-市场部")){
if("差旅报销".equals(type)){
return "6601070204";
}else if("私车公用报销".equals(type)){
return "6601070202";
}else{
return "6601070206";
}
}
return null;
}
/**
* 根据人员编码查询u8人员信息
* @param id
* @param ds
*/
public static String getPerson(String id,String ds){
Properties prop = PropUtil.getProperties("/config.properties");
String to_account = prop.getProperty("to_account");
PersonService par = new PersonService();
String code = "";
try {
JSONObject record = par.get(id, to_account,ds);
if(record.get("errcode").equals("0")){
JSONObject record1 = (JSONObject) record.get("person");
code = record1.get("cdept_num").toString();
}
// System.out.println(record);
} catch (OpenAPIException e) {
return code;
}
return code;
}
/**
* 获取钉钉企业内部应用的access_token
*/
public static void getToken(){
try {
Properties prop = PropUtil.getProperties("/config.properties");
String appkey = prop.getProperty("ding_appkey");
String appsecret = prop.getProperty("ding_appsecret");
DingTalkClient client = new DefaultDingTalkClient("https://oapi.dingtalk.com/gettoken");
OapiGettokenRequest req = new OapiGettokenRequest();
req.setHttpMethod("GET");
req.setAppkey(appkey);
req.setAppsecret(appsecret);
OapiGettokenResponse rsp = client.execute(req);
Map<String,String> map;
map = toMap(rsp.getBody());
if(map.get("errcode").equals("0")){
gettoken = map.get("access_token");
}else{
gettoken = "error";
}
} catch (ApiException | JSONException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}
}
public static Map toMap(String jsonString) throws JSONException {
org.springframework.boot.configurationprocessor.json.JSONObject jsonObject = new org.springframework.boot.configurationprocessor.json.JSONObject(jsonString);
Map result = new HashMap();
Iterator iterator = jsonObject.keys();
String key = null;
String value = null;
while (iterator.hasNext()) {
key = (String) iterator.next();
value = jsonObject.getString(key);
result.put(key, value);
}
return result;
}
public static void main(String[] args) throws Exception {
// autoOABankReceipt();
// autoReimbursement();
// autoReimbursementNew("js");
// String aa = "";
// if("12334".contains("1")){
// System.out.println("sssssssssss");
// }
// BigDecimal aa = new BigDecimal("10");
// BigDecimal multiply = aa.multiply(BigDecimal.valueOf(0.09)).multiply(aa);
// System.out.println(multiply);
// DingdingOpenInterface dingdingOpenInterface = new DingdingOpenInterface();
// Properties prop = PropUtil.getProperties("/config.properties");
// String PROC = prop.getProperty("bx_process_code");
// String PROC1 = prop.getProperty("byj_process_code");
// List<String> list = dingdingOpenInterface.getOrderIdList2(PROC,-2);
// List<String> list1 = dingdingOpenInterface.getOrderIdList2(PROC1,-7);
// System.out.println(list);
// System.out.println("========1======");
// Thread.currentThread().sleep(5000);//延迟5秒
// Thread.sleep(3000);//与上行代码无区别
// System.out.println("========2======");
// System.out.println(list1);
}
}