ticket summary component version milestone type owner status created _changetime _description _reporter 2 对working_date增加2012年数据 MIS系统 日常维护 xiejing closed 2011-12-26T15:19:18+08:00 2011-12-26T15:39:30+08:00 "== working_date表的用途： == 主要用于在预订资源计算预订单的有效工作日。[[BR]] 没有足够的天数的话就无法预订资源。所以在每一年年末需要将下一年的数据插入到该表中。[[BR]] == 添加步骤 == 1.先确定测试环境和正式环境中，该表的主键是否一致。如果不一致，将测试环境的序列的开始数据修改为正式环境该表主键+1。[[BR]] 2.修改cn.com.pc.mis.data_convert.handy报中的InitWorkingDate文件。 1)修改基本信息 {{{ //这里需要将area表中所有数据id都写进来，用"",""隔开 static int[] areaId ={727,767,839,840,856,864,867,11,928,908,828,834,837,849,854,863,865,866,887,929,931,932,933,939,940,829,830,836,841,843,850,860,862,869,871,930,935,938,527,588,608,647,671,672,687,688,689,690,707,427,450,451,452,447,448,449,507,508,509,668,1,2,3,4,5,6,7,8,9,10,227,247,287,307,347,348,367,387,388,389,407,408,428,487,547,548,567,568,569,587,589,590,591,627,667,669,670,467,607,609,827,831,832,835,838,842,844,845,846,847,851,852,853,855,857,858,859,868,747,787,807,833,848,861,870,909,934,936,937,941}; //插入数据的开始年份和结束年份 static int fromYear = 2012; static int toYear = 2012; }}} 2)修改节日信息 {{{ //元旦 cld.set(Calendar.MONTH,0); cld.set(Calendar.DAY_OF_MONTH,1); holiday.put(getFormateDate(cld.getTime()),""holiday""); cld.set(Calendar.MONTH,0); cld.set(Calendar.DAY_OF_MONTH,2); holiday.put(getFormateDate(cld.getTime()),""holiday""); cld.set(Calendar.MONTH,0); cld.set(Calendar.DAY_OF_MONTH,3); holiday.put(getFormateDate(cld.getTime()),""holiday""); //春节 cld.set(Calendar.MONTH,0); cld.set(Calendar.DAY_OF_MONTH,22); holiday.put(getFormateDate(cld.getTime()),""holiday""); cld.set(Calendar.MONTH,0); cld.set(Calendar.DAY_OF_MONTH,23); holiday.put(getFormateDate(cld.getTime()),""holiday""); cld.set(Calendar.MONTH,0); cld.set(Calendar.DAY_OF_MONTH,24); holiday.put(getFormateDate(cld.getTime()),""holiday""); cld.set(Calendar.MONTH,0); cld.set(Calendar.DAY_OF_MONTH,25); holiday.put(getFormateDate(cld.getTime()),""holiday""); cld.set(Calendar.MONTH,0); cld.set(Calendar.DAY_OF_MONTH,26); holiday.put(getFormateDate(cld.getTime()),""holiday""); cld.set(Calendar.MONTH,0); cld.set(Calendar.DAY_OF_MONTH,27); holiday.put(getFormateDate(cld.getTime()),""holiday""); cld.set(Calendar.MONTH,0); cld.set(Calendar.DAY_OF_MONTH,28); holiday.put(getFormateDate(cld.getTime()),""holiday""); cld.set(Calendar.MONTH,0); cld.set(Calendar.DAY_OF_MONTH,29); holiday.put(getFormateDate(cld.getTime()),""holiday""); //清明 cld.set(Calendar.MONTH,3); cld.set(Calendar.DAY_OF_MONTH,2); holiday.put(getFormateDate(cld.getTime()),""holiday""); cld.set(Calendar.MONTH,3); cld.set(Calendar.DAY_OF_MONTH,3); holiday.put(getFormateDate(cld.getTime()),""holiday""); cld.set(Calendar.MONTH,3); cld.set(Calendar.DAY_OF_MONTH,4); holiday.put(getFormateDate(cld.getTime()),""holiday""); //五一 cld.set(Calendar.MONTH,4); cld.set(Calendar.DAY_OF_MONTH,1); holiday.put(getFormateDate(cld.getTime()),""holiday""); cld.set(Calendar.MONTH,4); cld.set(Calendar.DAY_OF_MONTH,2); holiday.put(getFormateDate(cld.getTime()),""holiday""); cld.set(Calendar.MONTH,4); cld.set(Calendar.DAY_OF_MONTH,3); holiday.put(getFormateDate(cld.getTime()),""holiday""); //端午 cld.set(Calendar.MONTH,5); cld.set(Calendar.DAY_OF_MONTH,22); holiday.put(getFormateDate(cld.getTime()),""holiday""); cld.set(Calendar.MONTH,5); cld.set(Calendar.DAY_OF_MONTH,23); holiday.put(getFormateDate(cld.getTime()),""holiday""); cld.set(Calendar.MONTH,5); cld.set(Calendar.DAY_OF_MONTH,24); holiday.put(getFormateDate(cld.getTime()),""holiday""); //中秋 cld.set(Calendar.MONTH,8); cld.set(Calendar.DAY_OF_MONTH,30); holiday.put(getFormateDate(cld.getTime()),""holiday""); //国庆 cld.set(Calendar.MONTH,9); cld.set(Calendar.DAY_OF_MONTH,1); holiday.put(getFormateDate(cld.getTime()),""holiday""); cld.set(Calendar.MONTH,9); cld.set(Calendar.DAY_OF_MONTH,2); holiday.put(getFormateDate(cld.getTime()),""holiday""); cld.set(Calendar.MONTH,9); cld.set(Calendar.DAY_OF_MONTH,3); holiday.put(getFormateDate(cld.getTime()),""holiday""); cld.set(Calendar.MONTH,9); cld.set(Calendar.DAY_OF_MONTH,4); holiday.put(getFormateDate(cld.getTime()),""holiday""); cld.set(Calendar.MONTH,9); cld.set(Calendar.DAY_OF_MONTH,5); holiday.put(getFormateDate(cld.getTime()),""holiday""); cld.set(Calendar.MONTH,9); cld.set(Calendar.DAY_OF_MONTH,6); holiday.put(getFormateDate(cld.getTime()),""holiday""); cld.set(Calendar.MONTH,9); cld.set(Calendar.DAY_OF_MONTH,7); }}} 3)修改数据库信息 {{{ String sDBDriver=""oracle.jdbc.driver.OracleDriver""; sConnStr=""jdbc:oracle:thin:@192.168.75.100:1521:testdb""; conn = DriverManager.getConnection(sConnStr,""mis"",""******""); }}} 4)运行该文件。[[BR]] 3.刚刚运行生成的数据导入到正式环境中。并且将正式环境的序列开始数据修改为导入数据最大主键+1。 " xiejing 1 在提成管理中能对客服人员进行提成分配 MIS系统 需求 somebody closed 2011-11-14T09:54:30+08:00 2011-12-02T16:48:50+08:00 "需求描述：能在提成管理选择提成人员的时候，能在下拉框中查看到客服的信息。 具体实现过程： 由于在提出管理选择人员时查看到的是sales_person表中的信息，并且保存的该表的id。而MIS系统其他地方使用都是帐号进行操作的。所以需要把客服人员信息加入该表中。 为了不影响其他地方使用该表的数据，所以把所有的客服都放到新建的客服组，并且在维护用户页面进行添加，删除该表操作。 " xiejing