package cn.com.lzt.budget.data.util;

public class BudgetConstant {
    public static final String TEMPSHEET_MEASURE_CREATE="CREATE TABLE `%s` (\n" +
            "  `id` varchar(36) NOT NULL,\n" +
            "  `create_name` varchar(50) DEFAULT NULL COMMENT '创建人名称',\n" +
            "  `create_by` varchar(50) DEFAULT NULL COMMENT '创建人登录名称',\n" +
            "  `create_date` datetime DEFAULT NULL COMMENT '创建日期',\n" +
            "  `update_name` varchar(50) DEFAULT NULL COMMENT '更新人名称',\n" +
            "  `update_by` varchar(50) DEFAULT NULL COMMENT '更新人登录名称',\n" +
            "  `update_date` datetime DEFAULT NULL COMMENT '更新日期',\n" +
            "  `sys_org_code` varchar(50) DEFAULT NULL COMMENT '所属部门',\n" +
            "  `sys_company_code` varchar(50) DEFAULT NULL COMMENT '所属公司',\n" +
            "  `bpm_status` varchar(32) DEFAULT '1' COMMENT '流程状态',\n" +
            "  `tempsheet_id` varchar(32) DEFAULT NULL COMMENT '样表id',\n" +
            "  `period_id` varchar(32) DEFAULT NULL COMMENT '周期id',\n" +
            "  `period_year` varchar(32) DEFAULT NULL COMMENT '预算年份',\n" +
            "  `period_type` varchar(32) DEFAULT NULL COMMENT '预算类型',\n" +
            "  `period_detail_id` varchar(32) DEFAULT NULL COMMENT '预算周期明细id',\n" +
            "  `period_detail_name` varchar(255) DEFAULT NULL,\n" +
            "  `period_detail_start` datetime DEFAULT NULL COMMENT '预算周期开始',\n" +
            "  `period_detail_end` datetime DEFAULT NULL COMMENT '预算周期结束',\n" +
            "  `measure_id` varchar(32) DEFAULT NULL COMMENT '指标id',\n" +
            "  `measure_name` varchar(255) DEFAULT NULL COMMENT '指标名称',\n" +
            "  `include_tax` int(11) DEFAULT NULL COMMENT '是否含税',\n" +
            "  `data_type` varchar(32) DEFAULT NULL COMMENT '数据类型',\n" +
            "  `data_rules` varchar(512) DEFAULT NULL COMMENT '数据规则',\n" +
            "  `data_formula` varchar(255) DEFAULT NULL COMMENT '公式',\n" +
            "  `data_value` decimal(30,8) DEFAULT NULL COMMENT '数字值',\n" +
            "  `control_flag` VARCHAR(255) DEFAULT NULL COMMENT '控制预算',\n" +
            "  `ui_style` varchar(512) DEFAULT NULL COMMENT '样式json',\n" +
            "  `memo` varchar(512) DEFAULT NULL COMMENT '备注',\n" +
            "  `row` int(11) DEFAULT NULL COMMENT '行',\n" +
            "  `col` int(11) DEFAULT NULL COMMENT '列',\n" +
            "  `data_txt` varchar(512) DEFAULT NULL COMMENT '文本值',\n" +
            "  `function_id` varchar(45) DEFAULT NULL,\n" +
            "  `sheet_index` int(11) DEFAULT NULL,"+
            "  `show_type` VARCHAR(45) DEFAULT NULL,"+
            "  `find_key` VARCHAR(255) DEFAULT NULL,"+
            "  `entity_id` VARCHAR(45) DEFAULT NULL,"+
            "  `effect_cell` VARCHAR(255) DEFAULT NULL,"+
            "  `expect` int(11) DEFAULT NULL COMMENT '0 预计，1实际',\n" +
            "  PRIMARY KEY (`id`) \n" +
            ") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='预算样表指标'";
    public static final String INST_MEASURE_CREATE="CREATE TABLE `%s` (\n" +
            "  `id` varchar(36) NOT NULL,\n" +
            "  `create_name` varchar(50) DEFAULT NULL COMMENT '创建人名称',\n" +
            "  `create_by` varchar(50) DEFAULT NULL COMMENT '创建人登录名称',\n" +
            "  `create_date` datetime DEFAULT NULL COMMENT '创建日期',\n" +
            "  `update_name` varchar(50) DEFAULT NULL COMMENT '更新人名称',\n" +
            "  `update_by` varchar(50) DEFAULT NULL COMMENT '更新人登录名称',\n" +
            "  `update_date` datetime DEFAULT NULL COMMENT '更新日期',\n" +
            "  `sys_org_code` varchar(50) DEFAULT NULL COMMENT '所属部门',\n" +
            "  `sys_company_code` varchar(50) DEFAULT NULL COMMENT '所属公司',\n" +
            "  `bpm_status` varchar(32) DEFAULT '1' COMMENT '流程状态',\n" +
            "  `inst_id` varchar(32) DEFAULT NULL COMMENT '预算表id',\n" +
            "  `tempsheet_measure_id` varchar(45) DEFAULT NULL,\n" +
            "  `period_id` varchar(32) DEFAULT NULL COMMENT '周期id',\n" +
            "  `period_year` varchar(32) DEFAULT NULL COMMENT '预算年份',\n" +
            "  `period_type` varchar(32) DEFAULT NULL COMMENT '预算类型',\n" +
            "  `period_detail_id` varchar(32) DEFAULT NULL COMMENT '预算周期明细id',\n" +
            "  `period_detail_name` varchar(255) DEFAULT NULL,\n" +
            "  `period_detail_start` datetime DEFAULT NULL COMMENT '预算周期开始',\n" +
            "  `period_detail_end` datetime DEFAULT NULL COMMENT '预算周期结束',\n" +
            "  `measure_id` varchar(32) DEFAULT NULL COMMENT '指标id',\n" +
            "  `measure_name` varchar(255) DEFAULT NULL COMMENT '指标名称',\n" +
            "  `include_tax` int(11) DEFAULT NULL COMMENT '是否含税',\n" +
            "  `data_type` varchar(32) DEFAULT NULL COMMENT '数据类型',\n" +
            "  `data_rules` varchar(512) DEFAULT NULL COMMENT '数据规则',\n" +
            "  `data_formula` varchar(255) DEFAULT NULL COMMENT '公式',\n" +
            "  `data_value` decimal(30,8) DEFAULT NULL COMMENT '值',\n" +
            "  `control_flag` VARCHAR(255) DEFAULT NULL COMMENT '控制预算',\n" +
            "  `ui_style` varchar(512) DEFAULT NULL COMMENT '样式json',\n" +
            "  `memo` varchar(512) DEFAULT NULL COMMENT '备注',\n" +
            "  `row` int(11) DEFAULT NULL COMMENT '行',\n" +
            "  `col` int(11) DEFAULT NULL COMMENT '列',\n" +
            "  `expect` int(11) DEFAULT NULL COMMENT '0 预计，1实际',\n" +
            "  `data_txt` varchar(512) DEFAULT NULL,\n" +
            "  `function_id` varchar(45) DEFAULT NULL,\n" +
            "   `sheet_index` int(11) DEFAULT NULL,"+
            "  `show_type` VARCHAR(45) DEFAULT NULL,"+
            "  `find_key` VARCHAR(255) DEFAULT NULL,"+
            "  `entity_id` VARCHAR(45) DEFAULT NULL,"+
            "  `effect_cell` VARCHAR(255) DEFAULT NULL,"+
            "  PRIMARY KEY (`id`),\n" +
            "  KEY `inst_id` (`inst_id`,`row`,`col`)\n" +
            ") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=''";

    public static final String TEMPSHEET_TYPE_NORMAL ="normal";//成本通用样表
    public static final String TEMPSHEET_TYPE_NORMAL_SPECIAL ="normal_special";//专项通用样表
    public static final String TEMPSHEET_TYPE_ORDERS ="orders";
    public static final String TEMPSHEET_TYPE_HR ="hr";
    public static final String TEMPSHEET_TYPE_ACTUAL_STA="actual_sta";//执行统计表
    public static final String TEMPSHEET_TYPE_LEADER="leader";//执行统计表

    public static final  int EXPECT_YES=1;//预计
    public static final  int EXPECT_NO=0;//实际

    public static final int PROC_STATUS_VERIFY =1;//审核中
    public static final int PROC_STATUS_JOINT =2;//审核结束，进入会审阶段
    public static final int PROC_STATUS_FINAL =3;//会审结束，进入终审阶段
    public static final int PROC_STATUS_END=4;//结束

    public static final int TASK_STATUS_INIT=1;//开始
    public static final int TASK_STATUS_END=4;//结束

    public static final int VERIFY_STATUS_PASS=1;//通过
    public static final int VERIFY_STATUS_REFUSED=-1;//不通过

    public static final String VERIFY_GROUP_JOINT="joint";//会审
    public static final String VERIFY_GROUP_FINAL="final";//终审

    public static final String MEASURE_SHOWTYPE_TEN_THOUSAND = "ten_thousand";
    public static final String MEASURE_SHOWTYPE_HUNDRED_MILLION = "hundred_million";

    public static int INST_STATUS_INIT=0;//初始化
    public static int INST_STATUS_VERIFY=1;//已上报
    public static int INST_STATUS_JOINT=2;//已审核
    public static int INST_STATUS_FINAL=3;//已会审
    public static int INST_STATUS_END=4;//已终审
    public static int INST_STATUS_REFUSE=-1;//驳回
    public static int INST_STATUS_FROZEN=-2;//冻结

    public static int WRITE_BACK_SUCCESS=1;//回写成功
    public static int WRITE_BACK_ERROR=-1;//回写失败 ,报错
    public static int WRITE_BACK_ENTITY_NOT_FOUND=-2;//回写失败，预算主体
    public static int WRITE_BACK_MEASURE_NOT_FOUND=-3;//回写失败，未找到相关指标
    public static int WRITE_BACK_PERIOD_NOT_FOUND=-4;//回写失败，未找时间指标
    public static int WRITE_BACK_INST_MEASURE_NOT_FOUND=-5;//回写失败，未找到回写项
    public static int WRITE_BACK_OVER_LIMIT=-10;//回写失败，超过预算限制

    public static String COMPANY_ENTITY_ID="4028e4a55f6c84ec015f6ca5c6ab0001";

    public static enum BudgetType{
       tempsheet,//样表
        costbreakdown;//成本分解总表
    }

    public static enum OrdersKindType{
        m,//消耗品
        dizhi,//低值易耗 固定资产
        gzf,//工作服
        dcg;//代采购
    }
//执行统计表
    public static enum ActualStaKind{
     main,//预算执行总表
      labor,//预算执行表-人工
      pu,//预算执行表-采购
     maintain,//预算执行表-维保
    other,//预算执行表-其他费用
    manage;//预算执行表-管理费用
    }

    public static enum BusType{//回写业务类型
        tmp_company("对外付款"),
        inner_user("员工报销"),
        contract_payment("外包合同付款"),
        cloth("服装管理"),
        wages("薪资管理"),//定时任务
        finance_writeback("财务补录"),
        adjust("预算调整")
            ;
        private String name;
        private BusType(String name){
            this.name =name ;
        }

        public String getName() {
            return name;
        }

        public void setName(String name) {
            this.name = name;
        }
    }

    //控制周期
    public static enum ControlPeriod {
        year("年度")
        ,quarter_avg("季度平均")
        ,quarter_avg_acc("季度累进")
        ,month_avg("月平均")
        ,month_avg_acc("月累进")
        ;
        private String name;
        private ControlPeriod(String name){
            this.name =name ;
        }

        public String getName() {
            return name;
        }

        public void setName(String name) {
            this.name = name;
        }
    }

}