package com.product.org.admin.controller;

import com.product.common.lang.StringUtils;
import com.product.core.config.CoreConst;
import com.product.core.config.Global;
import com.product.core.controller.support.AbstractBaseController;
import com.product.core.dao.BaseDao;
import com.product.core.entity.FieldSetEntity;
import com.product.core.entity.RequestParameterEntity;
import com.product.core.exception.BaseException;
import com.product.core.spring.context.SpringMVCContextHolder;
import com.product.module.sys.version.ApiVersion;
import com.product.org.admin.config.CmnConst;
import com.product.org.admin.config.SystemCode;
import com.product.util.BaseUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import javax.servlet.http.HttpServletRequest;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;

/**
 * @Author cheng
 * @Description 附件
 * @Date 2021/4/23 16:31
 * @Version 1.0
 */
@RestController
@RequestMapping("/api/attachment")
public class AttachmentController extends AbstractBaseController {

    @Autowired
    BaseDao baseDao;

    @PostMapping("/find-attachment/{version}")
    @ApiVersion(1)
    public String findAttachment(HttpServletRequest request) {
        try {
            FieldSetEntity fse = null;
            Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA);
            RequestParameterEntity rpe = (RequestParameterEntity) bean;
            if (null != rpe && null != rpe.getFormData()) {
                fse = rpe.getFormData();
            }
            if (fse == null) {
                SpringMVCContextHolder.getSystemLogger().error(SystemCode.SYSTEM_FORM_NODATA.getValue(), SystemCode.SYSTEM_FORM_NODATA.getText());
                return this.error(SystemCode.SYSTEM_FORM_NODATA.getValue(), SystemCode.SYSTEM_FORM_NODATA.getText());
            }
            // 验证表名  附件表关联的表名 字段名是否正确
            if (!CmnConst.PRODUCT_SYS_ATTACHMENTS.equals(fse.getTableName()) || StringUtils.isEmpty(fse.getUUID()) || StringUtils.isEmpty(fse.getString(CmnConst.TABLE_NAME)) || StringUtils.isEmpty(fse.getString(CmnConst.FIELD_NAME))) {
                SpringMVCContextHolder.getSystemLogger().error(SystemCode.SYSTEM_FORM_COUNT.getValue(), SystemCode.SYSTEM_FORM_COUNT.getText());
                return this.error(SystemCode.SYSTEM_FORM_COUNT.getValue(), SystemCode.SYSTEM_FORM_COUNT.getText());
            }
            List<Object> params = new ArrayList<>();
            //luoxin 去掉限制后子流程表也可以引用主流程附件
//            params.add(fse.getString(CmnConst.TABLE_NAME));
//            params.add(fse.getString(CmnConst.FIELD_NAME));
            params.addAll(Arrays.asList(fse.getUUID().split(",")));
            StringBuilder sb = new StringBuilder();
            sb.append("select a.uuid,a.file_name name,a.view_online_sign,ifnull(b.dict_value,a.attachment_type_uuid) file_type,");
            sb.append("ifnull((select 1 from dual where ");
            sb.append(BaseUtil.buildQuestionMarkFilter("LOWER(ifnull(b.dict_value,a.attachment_type_uuid))", Global.getSystemConfig("can.web.online.edit", "doc,docx,xls,xlsx.ppt,pptx,wps,cvs").split(","), true));
            sb.append(") ,0)edit_online ");
            sb.append("  from ");
            sb.append(fse.getTableName());
            sb.append(" a left join product_sys_dict b on b.dict_name='upload_file_format' and b.uuid=a.attachment_type_uuid where ");
            //luoxin 去掉限制后子流程表也可以引用主流程附件
//            sb.append(" where attachment_data_table=? and attachment_data_field=? and ");
            sb.append(BaseUtil.buildQuestionMarkFilter("a.uuid", params.size(), true));
            return OK_List(baseDao.listTable(sb.toString(), params.toArray()));
        } catch (BaseException e) {
            e.printStackTrace();
            SpringMVCContextHolder.getSystemLogger().error(e);
            return error(e.getCode(), e.getMessage());
        } catch (Exception e) {
            e.printStackTrace();
            SpringMVCContextHolder.getSystemLogger().error(e);
            SpringMVCContextHolder.getSystemLogger().error(SystemCode.ATTACHMENT_FIND_FIAL.getValue(), SystemCode.ATTACHMENT_FIND_FIAL.getText());
            return error(SystemCode.ATTACHMENT_FIND_FIAL.getValue(), SystemCode.ATTACHMENT_FIND_FIAL.getText());
        }
    }

}