function htmltoword()
{
import('@.ORG.PHPWord', '', $ext = '.php');
$PHPWord = new PHPWord();
$content = <<<code
\t<table cellspacing="0" cellpadding="0"><tbody><tr class="firstRow"><td width="95" valign="top" style="border: 1px solid windowtext; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: 1px 1px 1px medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: 1px 1px 1px medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: 1px 1px 1px medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: 1px 1px 1px medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: 1px 1px 1px medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><br></td></tr><tr><td width="95" valign="top" style="border-width: medium 1px 1px; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;" rowspan="3"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td></tr><tr><td width="95" valign="top" style="border-width: medium 1px 1px; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px; word-break: break-all;">​<br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;" rowspan="3"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td></tr><tr><td width="95" valign="top" style="border-width: medium 1px 1px; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td></tr><tr><td width="95" valign="top" style="border-width: medium 1px 1px; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><br></td><td width="189" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;" rowspan="2" colspan="2"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td></tr><tr><td width="95" valign="top" style="border-width: medium 1px 1px; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td></tr><tr><td width="95" valign="top" style="border-width: medium 1px 1px; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td></tr></tbody></table>
\t\t<table cellspacing="0" cellpadding="0"><tbody><tr class="firstRow"><td width="142" valign="top" style="border: 1px solid windowtext; padding: 0px 7px;" rowspan="3"><p class="edit-text">11111</p></td><td width="142" valign="top" style="border-width: 1px 1px 1px medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><br></td><td width="142" valign="top" style="border-width: 1px 1px 1px medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><br></td><td width="142" valign="top" style="border-width: 1px 1px 1px medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><br></td></tr><tr><td width="426" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;" colspan="3"><p class="edit-text">444444</p></td></tr><tr><td width="142" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="142" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="142" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td></tr><tr><td width="142" valign="top" style="border-width: medium 1px 1px; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><br></td><td width="142" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="142" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="142" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td></tr><tr><td width="142" valign="top" style="border-width: medium 1px 1px; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;" rowspan="2"><p class="edit-text">22222</p></td><td width="426" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;" colspan="3"><p class="edit-text">33333</p></td></tr><tr><td width="142" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="142" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="142" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td></tr><tr><td width="142" valign="top" style="border-width: medium 1px 1px; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><br></td><td width="142" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="142" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="142" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td></tr><tr><td width="142" valign="top" style="border-width: medium 1px 1px; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><br></td><td width="142" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="142" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="142" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td></tr></tbody></table>
code;
$content = <<<code
<table width="100" cellspacing="0" cellpadding="0"><tbody><tr class="firstRow"><td width="2" style="border: 1px solid black; background: rgb(242, 242, 242) none repeat scroll 0% 0%; padding: 0px 7px;" rowspan="3"><p style="text-align:center"><strong><span style="font-family:宋体">接口名称</span></strong></p></td><td width="41" style="border-width: 1px 1px 1px medium; border-style: solid solid solid none; border-color: black black black -moz-use-text-color; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; background: rgb(242, 242, 242) none repeat scroll 0% 0%; padding: 0px 7px;" colspan="3"><p style="text-align:center"><strong><span style="font-family:宋体">源头数据库</span>(From)</strong></p></td><td width="45" style="border-width: 1px 1px 1px medium; border-style: solid solid solid none; border-color: black black black -moz-use-text-color; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; background: rgb(242, 242, 242) none repeat scroll 0% 0%; padding: 0px 7px;" colspan="3"><p style="text-align:center"><strong><span style="font-family:宋体">目标数据库</span>(To)</strong></p></td><td width="10" valign="top" style="border-width: 1px 1px 1px medium; border-style: solid solid solid none; border-color: black black black -moz-use-text-color; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; background: rgb(242, 242, 242) none repeat scroll 0% 0%; padding: 0px 7px;" rowspan="3"><p style="text-align:center"><strong><span style="font-family:宋体">说明</span></strong></p></td></tr><tr><td width="41" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; background: rgb(242, 242, 242) none repeat scroll 0% 0%; padding: 0px 7px;" colspan="3"><p style="text-align:left"><strong><span style="font-family:宋体">地址：</span>192.168.0.237</strong></p><p style="text-align:left"><strong><span style="font-family:宋体">数据库：</span>nydbexec</strong></p><p style="text-align:left"><strong><span style="font-family:宋体">端口：</span></strong></p><p style="text-align:left"><strong><span style="font-family:宋体">账号：</span>root</strong></p><p style="text-align:left"><strong><span style="font-family:宋体">密码：</span>tml123456</strong></p></td><td width="45" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; background: rgb(242, 242, 242) none repeat scroll 0% 0%; padding: 0px 7px;" colspan="3"><p style="text-align:left"><strong><span style="font-family:宋体">地址：</span>192.168.0.100</strong></p><p style="text-align:left"><strong><span style="font-family:宋体">数据库：</span>ufdata_101_2015</strong></p><p style="text-align:left"><strong><span style="font-family:宋体">端口：</span></strong></p><p style="text-align:left"><strong><span style="font-family:宋体">账号：</span>sa</strong></p><p style="text-align:left"><strong><span style="font-family:宋体">密码：</span></strong></p></td></tr><tr><td width="5" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; background: rgb(242, 242, 242) none repeat scroll 0% 0%; padding: 0px 7px;"><p style="text-align:center"><strong><span style="font-family:宋体">数据库表</span></strong></p></td><td width="5" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; background: rgb(242, 242, 242) none repeat scroll 0% 0%; padding: 0px 7px;"><p style="text-align:center"><strong><span style="font-family:宋体">属性</span></strong></p></td><td width="30" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; background: rgb(242, 242, 242) none repeat scroll 0% 0%; padding: 0px 7px;"><p style="text-align:center"><strong><span style="font-family:宋体">其他</span></strong></p></td><td width="2" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; background: rgb(242, 242, 242) none repeat scroll 0% 0%; padding: 0px 7px;"><p style="text-align:center"><strong><span style="font-family:宋体">数据库表</span></strong></p></td><td width="3" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; background: rgb(242, 242, 242) none repeat scroll 0% 0%; padding: 0px 7px;"><p style="text-align:center"><strong><span style="font-family:宋体">属性</span></strong></p></td><td width="39" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; background: rgb(242, 242, 242) none repeat scroll 0% 0%; padding: 0px 7px;"><p style="text-align:center"><strong><span style="font-family:宋体">其他</span></strong></p></td></tr><tr style=";height:120px"><td width="2" valign="top" height="120" style="border-width: medium 1px 1px; border-style: none solid solid; border-color: -moz-use-text-color black black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><p><span style="font-family: 宋体">薪资接口：</span></p><p><span style="font-family: 宋体">按需同步</span> <span style="font-family:宋体">按年份</span>+<span style="font-family:宋体">月份同步</span> <span style="font-family:宋体">，</span>pmp<span style="font-family:宋体">存出过程会按年份</span>+<span style="font-family:宋体">月份删除即将同步数据</span></p></td><td width="5" valign="top" height="120" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><p>U8<span style="font-family:宋体">数据源视图：</span> pmpgzview</p><p> </p></td><td width="5" valign="top" height="120" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><p>gzlbinfo.cgzdlname as <span style="font-family:宋体">工资大类</span>,</p><p>WA_GZData.cgzgradenum as <span style="font-family:宋体">类别编码</span>,</p><p>gzlbinfo.cgzgradename as <span style="font-family:宋体">类别名称</span>,</p><p>WA_GZData.cpsn_num AS <span style="font-family:宋体">人员编码</span> ,</p><p>hr_hi_person.cpsn_name as <span style="font-family:宋体">人员名称</span>,</p><p>WA_GZData.cDept_Num AS <span style="font-family:宋体">部门编码</span> ,</p><p>Department.cdepname as <span style="font-family:宋体">部门名称</span>,</p><p>WA_GZData.iPsnGrd_id AS iPsnGrd_id ,</p><p>WA_GZData.iYear AS <span style="font-family:宋体">年份</span> ,</p><p>iMonth AS <span style="font-family:宋体">月份</span> ,</p><p>iAccMonth AS iAccMonth ,</p><p>F_1 AS <span style="font-family:宋体">应发合计</span> ,</p><p>F_2 AS <span style="font-family:宋体">扣款合计</span> ,</p><p>F_3 AS <span style="font-family:宋体">实发合计</span> ,</p><p>F_4 AS <span style="font-family:宋体">本月扣零</span> ,</p><p>F_5 AS <span style="font-family:宋体">上月扣零</span> ,</p><p>F_6 AS <span style="font-family:宋体">代扣税</span> ,</p><p>F_7 AS <span style="font-family:宋体">计件工资</span> ,</p><p>WA_GZData.bLastFlag AS bLastFlag ,</p><p>WA_GZData.vStatus1 AS vStatus1 ,</p><p>WA_GZData.nStatus2 AS nStatus2 ,</p><p>WA_GZData.iRecordID AS iRecordID ,</p><p>F_1000 AS <span style="font-family:宋体">代付税</span> ,</p><p>F_1001 AS <span style="font-family:宋体">年终奖</span> ,</p><p>F_1002 AS <span style="font-family:宋体">年终奖代扣税</span> ,</p><p>F_1003 AS <span style="font-family:宋体">工资代扣税</span> ,</p><p>F_1004 AS <span style="font-family:宋体">扣税合计</span> ,</p><p>F_1005 AS <span style="font-family:宋体">年终奖代付税</span> ,</p><p>F_1006 AS <span style="font-family:宋体">工资代付税</span> ,</p><p>F_8 AS <span style="font-family:宋体">工资级别</span> ,</p><p>F_9 AS <span style="font-family:宋体">工资序列</span> ,</p><p>F_10 AS <span style="font-family:宋体">工资等级</span> ,</p><p>F_11 AS <span style="font-family:宋体">工资档次</span> ,</p><p>F_12 AS <span style="font-family:宋体">年岗位技能工资</span> ,</p><p>F_13 AS <span style="font-family:宋体">月工资</span> ,</p><p>F_14 AS <span style="font-family:宋体">月基薪</span> ,</p><p>F_15 AS <span style="font-family:宋体">月绩效</span> ,</p><p>F_16 AS <span style="font-family:宋体">年功工资</span> ,</p><p>F_17 AS <span style="font-family:宋体">加班工资</span> ,</p><p>F_18 AS <span style="font-family:宋体">月预扣风险金</span> ,</p><p>F_19 AS <span style="font-family:宋体">社保基数</span> ,</p><p>F_20 AS <span style="font-family:宋体">公积金基数</span> ,</p><p>F_21 AS <span style="font-family:宋体">养老保险金</span> ,</p><p>F_22 AS <span style="font-family:宋体">医疗保险金</span> ,</p><p>F_23 AS <span style="font-family:宋体">失业保险金</span> ,</p><p>F_24 AS <span style="font-family:宋体">生育保险金</span> ,</p><p>F_25 AS <span style="font-family:宋体">住房公积金</span> ,</p><p>F_26 AS <span style="font-family:宋体">社保调整</span> ,</p><p>F_27 AS <span style="font-family:宋体">计税金额</span> ,</p><p>F_28 AS <span style="font-family:宋体">其他免税项目</span> ,</p><p>F_29 AS <span style="font-family:宋体">应发小计</span> ,</p><p>F_30 AS <span style="font-family:宋体">通讯费扣款</span> ,</p><p>F_31 AS <span style="font-family:宋体">五险一金扣款</span> ,</p><p>F_32 AS <span style="font-family:宋体">病事缺扣款</span> ,</p><p>F_33 AS <span style="font-family:宋体">迟到扣款</span> ,</p><p>F_34 AS <span style="font-family:宋体">上月校错</span> ,</p><p>F_35 AS <span style="font-family:宋体">车贴</span> ,</p><p>F_36 AS <span style="font-family:宋体">财务挂账</span> ,</p><p>F_37 AS <span style="font-family:宋体">消财务挂账</span> ,</p><p>F_38 AS <span style="font-family:宋体">扣款小计</span> ,</p><p>F_39 AS <span style="font-family:宋体">一次性绩效发放</span> ,</p><p>F_40 AS <span style="font-family:宋体">季度绩效补差</span> ,</p><p>F_41 AS <span style="font-family:宋体">风险金调差</span> ,</p><p>F_42 AS <span style="font-family:宋体">本月实际计薪天数</span> ,</p><p>F_43 AS <span style="font-family:宋体">返风险金</span> ,</p><p>F_44 AS <span style="font-family:宋体">实习补助标准</span> ,</p><p>F_45 AS <span style="font-family:宋体">本月出勤率</span> ,</p><p>F_46 AS <span style="font-family:宋体">绩效考勤等级</span> ,</p><p>F_47 AS <span style="font-family:宋体">绩效摊销</span> ,</p><p>F_48 AS <span style="font-family:宋体">创新先进个人奖励</span> ,</p><p>F_49 AS <span style="font-family:宋体">缺勤天数</span> ,</p><p>F_50 AS <span style="font-family:宋体">平时加班天数</span> ,</p><p>F_51 AS <span style="font-family:宋体">迟到次数</span> ,</p><p>F_52 AS <span style="font-family:宋体">周末加班天数</span> ,</p><p>F_53 AS <span style="font-family:宋体">节假日加班天数</span></p></td><td width="30" valign="top" height="120" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><p><span style="font-family: 宋体">调用实例：</span></p><p>CALL `pmpxzin` ( -- pmp <span style="font-family:宋体">平台的数据接口</span></p><p>'001', -- <span style="font-family:宋体">工资大类</span></p><p>'001' , -- <span style="font-family:宋体">类别编码</span></p><p>'<span style="font-family:宋体">基本工资</span>' , -- <span style="font-family: 宋体">类别名称</span></p><p>'100001', -- <span style="font-family:宋体">人员编码</span></p><p>2 , -- <span style="font-family:宋体">部门编码</span></p><p>NULL , -- iPsnGrd_id</p><p>NULL , -- iPsnAmt</p><p>2015 , -- <span style="font-family:宋体">年份</span></p><p>8, -- <span style="font-family:宋体">月份</span></p><p>NULL , -- iAccMonth</p><p>3882.44 , -- <span style="font-family: 宋体">应发合计</span> </p><p>283.838 , -- <span style="font-family: 宋体">扣款合计</span> </p><p>4883.83 , -- <span style="font-family: 宋体">实发合计</span> </p><p>789.38 , -- <span style="font-family: 宋体">本月扣零</span> </p><p>483.83 , -- <span style="font-family: 宋体">上月扣零</span> </p><p>38.83 , -- <span style="font-family: 宋体">代扣税</span> </p><p>448 , -- <span style="font-family: 宋体">计件工资</span> </p><p>NULL , -- bLastFlag</p><p>NULL , -- vStatus1</p><p>NULL , -- nStatus2</p><p>NULL , -- iRecordID</p><p>38.3 , -- <span style="font-family: 宋体">代付税</span> </p><p>3448.38 , -- <span style="font-family: 宋体">年终奖</span> </p><p>32.23 , -- <span style="font-family: 宋体">年终奖代扣税</span> </p><p>449.3 , -- <span style="font-family: 宋体">工资代扣税</span> </p><p>22.82 , -- <span style="font-family: 宋体">扣税合计</span> </p><p>382.3 , -- <span style="font-family: 宋体">年终奖代付税</span> </p><p>373.8 , -- <span style="font-family: 宋体">工资代付税</span> </p><p>1 , -- <span style="font-family: 宋体">工资级别</span> </p><p>2 , -- <span style="font-family: 宋体">工资序列</span> </p><p>3 , -- <span style="font-family: 宋体">工资等级</span> </p><p>4 , -- <span style="font-family: 宋体">工资档次</span> </p><p>5 , -- <span style="font-family: 宋体">年岗位技能工资</span> </p><p>8000 , -- <span style="font-family: 宋体">月工资</span> </p><p>4000 , -- <span style="font-family: 宋体">月基薪</span> </p><p>2000 , -- <span style="font-family: 宋体">月绩效</span> </p><p>283.83 , -- <span style="font-family: 宋体">年功工资</span> </p><p>44.38 , -- <span style="font-family: 宋体">加班工资</span> </p><p>4.38 , -- <span style="font-family: 宋体">月预扣风险金</span> </p><p>34.82 , -- <span style="font-family: 宋体">社保基数</span> </p><p>44.83 , -- <span style="font-family: 宋体">公积金基数</span> </p><p>442.83 , -- <span style="font-family: 宋体">养老保险金</span> </p><p>32 , -- <span style="font-family: 宋体">医疗保险金</span> </p><p>443.8 , -- <span style="font-family: 宋体">失业保险金</span> </p><p>44.38 , -- <span style="font-family: 宋体">生育保险金</span> </p><p>33.38 , -- <span style="font-family: 宋体">住房公积金</span> </p><p>44.38 , -- <span style="font-family: 宋体">社保调整</span> </p><p>1903.8, -- <span style="font-family:宋体">计税金额</span> </p><p>43.11, -- <span style="font-family:宋体">其他免税项目</span> </p><p>7889.34, -- <span style="font-family:宋体">应发小计</span> </p><p>48.3, -- <span style="font-family:宋体">通讯费扣款</span> </p><p>889.2, -- <span style="font-family:宋体">五险一金扣款</span> </p><p>37.38, -- <span style="font-family:宋体">病事缺扣款</span> </p><p>28.77, -- <span style="font-family:宋体">迟到扣款</span> </p><p>12.38, -- <span style="font-family:宋体">上月校错</span> </p><p>1500, -- <span style="font-family:宋体">车贴</span> </p><p>38.84, -- <span style="font-family:宋体">财务挂账</span> </p><p>38.83, -- <span style="font-family:宋体">消财务挂账</span> </p><p>503.38, -- <span style="font-family:宋体">扣款小计</span> </p><p>3834.2, -- <span style="font-family:宋体">一次性绩效发放</span> </p><p>889.43, -- <span style="font-family:宋体">季度绩效补差</span></p><p>48.38, -- <span style="font-family:宋体">风险金调差</span></p><p>28, -- <span style="font-family:宋体">本月实际计薪天数</span></p><p>238.48, -- <span style="font-family:宋体">返风险金</span></p><p>1000, -- <span style="font-family:宋体">实习补助标准</span></p><p>100, -- <span style="font-family:宋体">本月出勤率</span></p><p>2, -- <span style="font-family:宋体">绩效考勤等级</span></p><p>448.38, -- <span style="font-family:宋体">绩效摊销</span></p><p>343.28, -- <span style="font-family:宋体">创新先进个人奖励</span></p><p>13, -- <span style="font-family:宋体">缺勤天数</span></p><p>12, -- <span style="font-family:宋体">平时加班天数</span></p><p>11, -- <span style="font-family:宋体">迟到次数</span></p><p>22, -- <span style="font-family:宋体">周末加班天数</span></p><p>24 -- <span style="font-family:宋体">节假日加班天数</span></p><p>)</p></td><td width="2" valign="top" height="120" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><p>Pmp<span style="font-family:宋体">目标</span></p><p><span style="font-family: 宋体">存出过程：</span> pmpxzin</p></td><td width="3" valign="top" height="120" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><p>cgzdlname, -- <span style="font-family:宋体">工资大类</span></p><p>cgzgradenum , -- <span style="font-family:宋体">类别编码</span></p><p>cgzgradename , -- <span style="font-family:宋体">类别名称</span></p><p>cpsnnum , -- <span style="font-family:宋体">人员编码</span></p><p>cDeptNum , -- <span style="font-family:宋体">部门编码</span></p><p>iYear , -- <span style="font-family:宋体">年份</span></p><p>iMonth , -- <span style="font-family:宋体">月份</span></p><p>yingfaheji , -- <span style="font-family: 宋体">应发合计</span> </p><p>koukuanheji , -- <span style="font-family: 宋体">扣款合计</span> </p><p>shifaheji , -- <span style="font-family: 宋体">实发合计</span> </p><p>benyuekouling , -- <span style="font-family: 宋体">本月扣零</span> </p><p>shangyuekouling , -- <span style="font-family: 宋体">上月扣零</span> </p><p>daikoushui , -- <span style="font-family: 宋体">代扣税</span> </p><p>jijiangongzi , -- <span style="font-family: 宋体">计件工资</span> </p><p>daifushui , -- <span style="font-family: 宋体">代付税</span> </p><p>nianzhongjiang , -- <span style="font-family: 宋体">年终奖</span> </p><p>nianzhongjiangdaikou , -- <span style="font-family: 宋体">年终奖代扣税</span> </p><p>gongzidaikoushui , -- <span style="font-family: 宋体">工资代扣税</span> </p><p>koushuiheji , -- <span style="font-family: 宋体">扣税合计</span> </p><p>nianzhongjiangdaifus , -- <span style="font-family: 宋体">年终奖代付税</span> </p><p>gongzidaifushui , -- <span style="font-family: 宋体">工资代付税</span> </p><p>gongzijibie , -- <span style="font-family: 宋体">工资级别</span> </p><p>gongzixulie , -- <span style="font-family: 宋体">工资序列</span> </p><p>gongzidengji , -- <span style="font-family: 宋体">工资等级</span> </p><p>gongzidangci , -- <span style="font-family: 宋体">工资档次</span> </p><p>niangangweijinengong , -- <span style="font-family: 宋体">年岗位技能工资</span> </p><p>yuegongzi , -- <span style="font-family: 宋体">月工资</span> </p><p>yuejixin , -- <span style="font-family: 宋体">月基薪</span> </p><p>yuejixiao , -- <span style="font-family: 宋体">月绩效</span> </p><p>niangonggongzi , -- <span style="font-family: 宋体">年功工资</span> </p><p>jiabangongzi , -- <span style="font-family: 宋体">加班工资</span> </p><p>yueyukoufengxianjin , -- <span style="font-family: 宋体">月预扣风险金</span> </p><p>shebaojishu , -- <span style="font-family: 宋体">社保基数</span> </p><p>gongjijinjishu , -- <span style="font-family: 宋体">公积金基数</span> </p><p>yanglaobaoxianjin , -- <span style="font-family: 宋体">养老保险金</span> </p><p>yiliaobaoxianjin , -- <span style="font-family: 宋体">医疗保险金</span> </p><p>shiyebaoxianjin , -- <span style="font-family: 宋体">失业保险金</span> </p><p>shengyubaoxianjin , -- <span style="font-family: 宋体">生育保险金</span> </p><p>zhufanggongjijin , -- <span style="font-family: 宋体">住房公积金</span> </p><p>shebaodiaozheng , -- <span style="font-family: 宋体">社保调整</span> </p><p>jishuijine , -- <span style="font-family: 宋体">计税金额</span> </p><p>qitamianshuixiangmu , -- <span style="font-family: 宋体">其他免税项目</span> </p><p>yingfaxiaoji , -- <span style="font-family: 宋体">应发小计</span> </p><p>tongxunfeikoukuan , -- <span style="font-family: 宋体">通讯费扣款</span> </p><p>wuxianyijinkoukuan , -- <span style="font-family: 宋体">五险一金扣款</span> </p><p>bingshiquekoukuan , -- <span style="font-family: 宋体">病事缺扣款</span> </p><p>chidaokoukuan , -- <span style="font-family: 宋体">迟到扣款</span> </p><p>shangyuexiaocuo , -- <span style="font-family: 宋体">上月校错</span> </p><p>chetie , -- <span style="font-family: 宋体">车贴</span> </p><p>caiwuguazhang , -- <span style="font-family: 宋体">财务挂账</span> </p><p>xiaocaiwuguazhang , -- <span style="font-family: 宋体">消财务挂账</span> </p><p>koukuanxiaoji , -- <span style="font-family: 宋体">扣款小计</span> </p><p>yicixingjixiaofafang , -- <span style="font-family: 宋体">一次性绩效发放</span> </p><p>jidujixiaobucha , -- <span style="font-family:宋体">季度绩效补差</span></p><p>fengxianjindiaocha , -- <span style="font-family:宋体">风险金调差</span></p><p>benyueshijijixintian , -- <span style="font-family:宋体">本月实际计薪天数</span></p><p>fanfengxianjin , -- <span style="font-family:宋体">返风险金</span></p><p>shixibuzhubiaozhun , -- <span style="font-family:宋体">实习补助标准</span></p><p>benyuechuqinlv , -- <span style="font-family:宋体">本月出勤率</span></p><p>jixiaokaoqindengji , -- <span style="font-family:宋体">绩效考勤等级</span></p><p>jixiaotanxiao , -- <span style="font-family:宋体">绩效摊销</span></p><p>chuangxinxianjingere , -- <span style="font-family:宋体">创新先进个人奖励</span></p><p>queqintianshu , -- <span style="font-family:宋体">缺勤天数</span></p><p>pingshijiabantianshu , -- <span style="font-family:宋体">平时加班天数</span></p><p>chidaocishu , -- <span style="font-family:宋体">迟到次数</span></p><p>zhoumojiabantianshu , -- <span style="font-family:宋体">周末加班天数</span></p><p>jiejiarijiabantiansh -- <span style="font-family:宋体">节假日加班天数</span></p><p><span style="font-family: 宋体">（</span>67<span style="font-family:宋体">个字段）</span></p></td><td width="39" valign="top" height="120" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><br></td><td width="10" valign="top" height="120" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><br></td></tr><tr style=";height:216px"><td width="2" valign="top" height="216" style="border-width: medium 1px 1px; border-style: none solid solid; border-color: -moz-use-text-color black black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><p><span style="font-family: 宋体">请假同步：</span></p><p>Pmp<span style="font-family:宋体">请假单终审后传递到</span>u8</p></td><td width="5" valign="top" height="216" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><p>Pmp<span style="font-family:宋体">数据源视图：</span> pmpqjsurview</p></td><td width="5" valign="top" height="216" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><p>yongyouorderno` AS <span style="font-family:宋体">创建人编码</span>,</p><p>mis_auto_ucjcm.`jieshuriqi AS <span style="font-family:宋体">结束时间</span>,</p><p> mis_auto_dtics.`u8leixingbianma` AS <span style="font-family:宋体">请假类型</span>,</p><p> ryinfoshenhe.name AS <span style="font-family:宋体">批准人</span>,</p><p> ryinfo.`name` AS <span style="font-family:宋体">创建人名</span>,</p><p> mis_auto_ucjcm.`kaishiriqi` AS <span style="font-family:宋体">开始时间</span>,</p><p>FROM_UNIXTIME(mis_auto_ucjcm.`createtime`,'%Y-%m-%d %H:%i:%s') AS <span style="font-family:宋体">创建时间</span>,</p><p> ryinfoqingjr.yongyouorderno AS <span style="font-family:宋体">请假人编码</span>,</p><p> mis_auto_ucjcm.qingjiashiyou AS <span style="font-family:宋体">请假原因</span>,</p><p> '' AS <span style="font-family:宋体">备注</span>,</p><p> mis_auto_ucjcm.`kaishiriqi` AS <span style="font-family:宋体">计划时间</span>,</p><p> ryinfoshenhe.yongyouorderno AS <span style="font-family:宋体">审核人编码</span>,</p><p> ryinfoshenhe.name AS <span style="font-family:宋体">审核人</span>,</p><p> process_info_history.`dotime` AS <span style="font-family:宋体">审核时间</span> ,</p><p>(CASE WHEN mis_auto_ucjcm.status=1 THEN '<span style="font-family:宋体">否</span>'</p><p> WHEN mis_auto_ucjcm.status=0 THEN '<span style="font-family:宋体">是</span>'</p><p> END ) AS <span style="font-family:宋体">审核状态</span></p><p> </p></td><td width="30" valign="top" height="216" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><p><span style="font-family: 宋体">调用实例：</span></p><p> </p><p>exec pmpqjwsc -- <span style="font-family:宋体">请假存储过程</span> <span style="font-family:宋体">调试</span></p><p> '100005', -- <span style="font-family:宋体">创建人编码</span></p><p> '2015-07-31 17:00' , -- <span style="font-family:宋体">结束时间</span> </p><p> 'BS00' , -- <span style="font-family:宋体">请假类型</span></p><p> '<span style="font-family:宋体">批准人名</span>' , -- <span style="font-family:宋体">批准人</span></p><p> '<span style="font-family:宋体">周庆红</span>' , -- <span style="font-family:宋体">创建人名</span></p><p> '2015-07-31 17:00' , -- <span style="font-family:宋体">开始日期</span> </p><p> '2015-07-31 17:00' , -- <span style="font-family:宋体">创建日期</span> </p><p> '100005' , --<span style="font-family:宋体">请假人编码</span></p><p> '<span style="font-family:宋体">请假原因</span>' , -- <span style="font-family:宋体">请假原因</span></p><p> ' <span style="font-family:宋体">备注说明</span> ' , --<span style="font-family:宋体">备注</span> </p><p> '2015-07-31 17:00' ,--<span style="font-family:宋体">计划时间</span></p><p> '100005' , -- <span style="font-family: 宋体">审核人编码</span> </p><p> '<span style="font-family:宋体">周庆红</span>' , -- <span style="font-family:宋体">审核人</span> </p><p> '2015-07-31 17:00' , -- <span style="font-family:宋体">审核时间</span> </p><p> 1 -- <span style="font-family:宋体">审核状态</span></p><p> </p><p> </p></td><td width="2" valign="top" height="216" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><p><span style="font-family: 宋体">目标：</span>U8<span style="font-family:宋体">存出过程</span> pmpqjwsc</p></td><td width="3" valign="top" height="216" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><p>exec pmpqjwsc -- <span style="font-family:宋体">请假存储过程</span> <span style="font-family:宋体">调试</span></p><p> '100005', -- <span style="font-family:宋体">创建人编码</span></p><p> '2015-07-31 17:00' , -- <span style="font-family:宋体">结束时间</span> </p><p> 'BS00' , -- <span style="font-family:宋体">请假类型</span></p><p> '<span style="font-family:宋体">批准人名</span>' , -- <span style="font-family:宋体">批准人</span></p><p> '<span style="font-family:宋体">周庆红</span>' , -- <span style="font-family:宋体">创建人名</span></p><p> '2015-07-31 17:00' , -- <span style="font-family:宋体">开始日期</span> </p><p> '2015-07-31 17:00' , -- <span style="font-family:宋体">创建日期</span> </p><p> '100005' , -- <span style="font-family:宋体">请假人</span></p><p> '<span style="font-family:宋体">请假原因</span>' , -- <span style="font-family:宋体">请假原因</span></p><p> ' <span style="font-family:宋体">备注说明</span> ' , --<span style="font-family:宋体">备注</span> </p><p> '2015-07-31 17:00' ,--<span style="font-family:宋体">计划时间</span></p><p> '100005' , -- <span style="font-family: 宋体">审核人编码</span> </p><p> '<span style="font-family:宋体">周庆红</span>' , -- <span style="font-family:宋体">审核人</span> </p><p> '2015-07-31 17:00' , -- <span style="font-family:宋体">审核时间</span> </p><p> 1</p></td><td width="39" valign="top" height="216" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><br></td><td width="10" valign="top" height="216" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><br></td></tr><tr style=";height:216px"><td width="2" valign="top" height="216" style="border-width: medium 1px 1px; border-style: none solid solid; border-color: -moz-use-text-color black black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><p><span style="font-family: 宋体">出差同步：</span></p><p>Pmp<span style="font-family:宋体">出差终审后传递到</span>u8</p></td><td width="5" valign="top" height="216" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><p>Pmp<span style="font-family:宋体">数据源视图：</span> pmpccsurview</p></td><td width="5" valign="top" height="216" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><p>ryinfo.yongyouorderno AS <span style="font-family:宋体">创建人编码</span>,</p><p>mis_auto_xeyis.`chuchajieshuoriqi` AS <span style="font-family:宋体">结束时间</span>,</p><p>ryinfochuc.`name`AS <span style="font-family:宋体">批准人</span>,</p><p>ryinfo.`name` AS <span style="font-family:宋体">创建人</span>,</p><p>mis_auto_xeyis.chuchakaishiriqi AS <span style="font-family:宋体">开始时间</span>,</p><p>mis_auto_xeyis.`createtime` AS <span style="font-family:宋体">创建时间</span>,</p><p>ryinfochucr.yongyouorderno AS <span style="font-family:宋体">出差人编码</span>,</p><p>mis_auto_vqzzh.`name` AS <span style="font-family:宋体">出差类型</span>,</p><p> mis_auto_xeyis.chuchashiyou AS <span style="font-family:宋体">出差事由</span>,</p><p> '' AS <span style="font-family:宋体">备注</span>,</p><p>ryinfochuc.`name` AS <span style="font-family:宋体">审核人名</span>,</p><p>process_info_history.`dotime` AS <span style="font-family:宋体">审核时间</span>,</p><p>(CASE WHEN mis_auto_xeyis.`status`='0' THEN '<span style="font-family:宋体">是</span>'</p><p> WHEN mis_auto_xeyis.`status`='1' THEN '<span style="font-family:宋体">否</span>' </p><p> END ) AS <span style="font-family:宋体">是否审核</span>,</p><p>ryinfochuc.yongyouorderno AS <span style="font-family:宋体">审核人编码</span>,</p></td><td width="30" valign="top" height="216" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><p> </p><p>exec pmpcc --<span style="font-family:宋体">出差调试</span> </p><p> 'demo', -- <span style="font-family: 宋体">创建人编码</span></p><p> '2015-08-04 00:00', -- <span style="font-family:宋体">结束时间</span></p><p> 'aaa', -- <span style="font-family: 宋体">批准人</span></p><p> 'demo', -- <span style="font-family: 宋体">创建人</span></p><p> '2015-08-03 00:00', -- <span style="font-family:宋体">开始时间</span></p><p> '2015-08-03 11:47:04', -- <span style="font-family:宋体">创建时间</span></p><p> '100001', -- <span style="font-family:宋体">出差人编码</span></p><p> 'DS01', -- <span style="font-family:宋体">出差类型</span></p><p> 'bbb', -- <span style="font-family: 宋体">出差事由</span></p><p> 'ccc111' , -- <span style="font-family:宋体">备注</span></p><p> 'demo',-- <span style="font-family:宋体">审核人名</span> </p><p> '2015-08-03 11:47:04' , -- <span style="font-family:宋体">审核时间</span> </p><p> 1 , -- <span style="font-family: 宋体">是否审核</span></p><p> 'demo' --<span style="font-family:宋体">审核人编码</span></p></td><td width="2" valign="top" height="216" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><p>U8<span style="font-family:宋体">目标：存出过程</span> pmpcc </p></td><td width="3" valign="top" height="216" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><p> </p><p> exec pmpcc --<span style="font-family:宋体">出差调试</span> </p><p> 'demo', -- <span style="font-family: 宋体">创建人编码</span></p><p> '2015-08-04 00:00', -- <span style="font-family:宋体">结束时间</span></p><p> 'aaa', -- <span style="font-family: 宋体">批准人</span></p><p> 'demo', -- <span style="font-family: 宋体">创建人</span></p><p> '2015-08-03 00:00', -- <span style="font-family:宋体">开始时间</span></p><p> '2015-08-03 11:47:04', -- <span style="font-family:宋体">创建时间</span></p><p> '100001', -- <span style="font-family:宋体">出差人编码</span></p><p> 'DS01', -- <span style="font-family:宋体">出差类型</span></p><p> 'bbb', -- <span style="font-family: 宋体">出差事由</span></p><p> 'ccc111' , -- <span style="font-family:宋体">备注</span></p><p> 'demo',-- <span style="font-family:宋体">审核人名</span> </p><p> '2015-08-03 11:47:04' , -- <span style="font-family:宋体">审核时间</span> </p><p> 1 , -- <span style="font-family: 宋体">是否审核</span></p><p> 'demo' --<span style="font-family:宋体">审核人编码</span></p><p> </p></td><td width="39" valign="top" height="216" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><br></td><td width="10" valign="top" height="216" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><br></td></tr></tbody></table>\t
code;
$content = htmlToWordXml($content);
// dump($content);
// exit;
$PHPWord = new PHPWord();
// dump(htmlToWordXml($content));
// exit;
$docfile = UPLOAD_SampleWord . "4444.docx";
$filenameUTF8 = UPLOAD_SampleWord . "5555.docx";
$document = $PHPWord->loadTemplate($docfile);
$document->clearAllBiaoji();
$content = <<<code
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<w:document xmlns:ve="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:m="http://schemas.openxmlformats.org/officeDocument/2006/math" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:wp="http://schemas.openxmlformats.org/drawingml/2006/wordprocessingDrawing" xmlns:w10="urn:schemas-microsoft-com:office:word" xmlns:w="http://schemas.openxmlformats.org/wordprocessingml/2006/main" xmlns:wne="http://schemas.microsoft.com/office/word/2006/wordml"><w:body>{$content}</w:body></w:document>
code;
// dump($content);exit;
// $bookNamearr = array();
// $bookNamearr["wang"] = array(
// "name" => "wang",
// "showname" => "",
// "original" => $content,
// "value" => $content,
// "is_datatable" => 0,
// "istestarea" => 1
// );
// foreach($bookNamearr as $k => $v)
// {
// if($v["is_datatable"]){
// $data = array();
// $data["showname"] = $v["showname"];
// $data["value"]= $v["value"];
// $data["showtype"]= $v["showtype"]!==NULL?$v["showtype"]:0;
// $data["showtitle"]= $v["showtitle"]!==NULL?$v["showtitle"]:0;
// if(isset($v["colORrow"])){
// $data["colORrow"] = $v["colORrow"];
// }
// if(is_array($v["value"]) && !isset($v["colORrow"])){
// foreach($v["value"] as $kk => $vv){
// $data["titleArr"][] = empty($vv["showname"])?"":$vv["showname"];
// }
// }
// $document->setValue($v["name"],$data);
// }else{
// $document->setValue($v["name"],$v);
// }
// }
// $document->clearTemplateTag();
// $document->save($filenameUTF8);
// $filenameUTF8 = UPLOAD_SampleWord."6789.docx";
// $document = $PHPWord->loadTemplate($imgurl);
$document->setStr($content);
$document->save($filenameUTF8);
header("Cache-Control: public");
header("Content-Type: application/force-download");
header("Content-Disposition: attachment; filename=" . basename($filenameUTF8));
readfile($filenameUTF8);
}
/**
* Set a Template value
*
* @param mixed $search
* @param mixed $replace
*/
public function setValue($search, $replace)
{
$findArr = $this->find($search);
if (count($findArr) == 0) {
return;
}
$yuan_xml = $this->_documentXML;
if (!is_array($replace["value"])) {
if ($replace["istestarea"] == 1 && !empty($replace["original"]) && mb_strpos($replace["original"], "<") !== FALSE || $search == "newTab" && !empty($replace["original"])) {
$xml = DOMDocument::loadXML($this->_documentXML, LIBXML_NOENT | LIBXML_XINCLUDE | LIBXML_NOERROR | LIBXML_NOWARNING);
if ($xml) {
$xmlTable = $xml->getElementsByTagName('p');
foreach ($xmlTable as $table) {
$text = $table->textContent;
if (mb_strpos($text, '${' . $search . "}") !== false) {
$element = $xml->createElement('replace', '###' . $search . '###');
$table->parentNode->insertBefore($element, $table);
$table->parentNode->removeChild($table);
}
}
$this->_documentXML = $xml->saveXML();
if (mb_strpos($this->_documentXML, '<replace>###' . $search . '###</replace>') !== false) {
if (mb_strpos($replace["original"], "<") !== FALSE) {
$replace["value"] = htmlToWordXml(html_entity_decode($replace["original"]));
}
$this->_documentXML = str_replace('<replace>###' . $search . '###</replace>', $replace["value"], $this->_documentXML);
}
if (!DOMDocument::loadXML($this->_documentXML, LIBXML_NOENT | LIBXML_XINCLUDE | LIBXML_NOERROR | LIBXML_NOWARNING)) {
// 转富文本格式有错时
$this->_documentXML = $yuan_xml;
}
}
} else {
if ($replace["ischecked"] == 1) {
$checkArr = explode(",", $replace["original"]);
$checkYuanArr = explode(",", $replace["checkList"]);
foreach ($checkYuanArr as $k => $v) {
$checksearch = $replace["name"] . $v;
if (in_array($v, $checkArr)) {
$checkReplaceValue = '<w:sym w:font="Wingdings 2" w:char="F052" />';
} else {
$checkReplaceValue = '<w:sym w:font="Wingdings 2" w:char="F0A3" />';
}
$xml = DOMDocument::loadXML($this->_documentXML, LIBXML_NOENT | LIBXML_XINCLUDE | LIBXML_NOERROR | LIBXML_NOWARNING);
if ($xml) {
$xmlTable = $xml->getElementsByTagName('t');
foreach ($xmlTable as $table) {
$text = $table->textContent;
if (mb_strpos($text, '${' . $checksearch . "}") !== false) {
$element = $xml->createElement('replace', '###' . $checksearch . '###');
$table->parentNode->appendChild($element);
$table->parentNode->removeChild($table);
}
}
$this->_documentXML = $xml->saveXML();
if (mb_strpos($this->_documentXML, '<replace>###' . $checksearch . '###</replace>') !== false) {
$this->_documentXML = str_replace('<replace>###' . $checksearch . '###</replace>', $checkReplaceValue, $this->_documentXML);
}
if (!DOMDocument::loadXML($this->_documentXML, LIBXML_NOENT | LIBXML_XINCLUDE | LIBXML_NOERROR | LIBXML_NOWARNING)) {
// 转富文本格式有错时
$this->_documentXML = $yuan_xml;
}
}
}
}
// $search = '/(?:\$|＄)(?:\{|｛)(\<.[^<>]*\>|\s*|\n*|\r*)*'.$search.'(\s*|\n*|\r*)*(\<.[^<>]*\>|\s*\n*\r*)*(?:\}|｝)/';
$search = '${' . $search . "}";
$this->_documentXML = str_replace($search, $replace["value"], $this->_documentXML);
}
} else {
if (!isset($replace["colORrow"])) {
//整个表格输出
$xml = DOMDocument::loadXML($this->_documentXML, LIBXML_NOENT | LIBXML_XINCLUDE | LIBXML_NOERROR | LIBXML_NOWARNING);
if ($xml) {
$xmlTable = $xml->getElementsByTagName('p');
foreach ($xmlTable as $table) {
$text = $table->textContent;
if (mb_strpos($text, '${' . $search . "}") !== false) {
$element = $xml->createElement('replace', '###' . $search . '###');
$table->parentNode->insertBefore($element, $table);
}
}
$this->_documentXML = $xml->saveXML();
}
// $search = '/(?:\$|＄)(?:\{|｛)(\<.[^<>]*\>|\s*|\n*|\r*)*'.$search.'(\s*|\n*|\r*)*(\<.[^<>]*\>|\s*\n*\r*)*(?:\}|｝)/';
if (!$replace["showtitle"]) {
$replace["showname"] = "";
}
$is_empty = true;
foreach ($replace["value"] as $k => $v) {
if (!empty($v["value"])) {
$is_empty = false;
break;
}
}
if (!$is_empty) {
$textStyle = array("name" => $replace["ziti"] ? $replace["ziti"] : "仿宋_GB2312", "size" => $replace["zihao"] ? $replace["zihao"] : 9, "spacing" => $replace["hangjianju"] ? $replace["hangjianju"] : 240);
$tableXmlStr = $this->getPHPWordTableXmlStr($replace["showname"], $replace["titleArr"], $replace["value"], NULL, $replace["showtype"], $textStyle, $replace["fieldwidth"]);
} else {
$tableXmlStr = "";
}
$this->_documentXML = str_replace('<replace>###' . $search . '###</replace>', $tableXmlStr, $this->_documentXML);
} else {
$xml = DOMDocument::loadXML($this->_documentXML, LIBXML_NOENT | LIBXML_XINCLUDE | LIBXML_NOERROR | LIBXML_NOWARNING);
if ($xml) {
$xmlTable = $xml->getElementsByTagName('tbl');
//横向填充
if (!empty($replace["showtype"])) {
foreach ($xmlTable as $table) {
$rows = $table->getElementsByTagName('tr');
foreach ($rows as $k => $row) {
$text = $row->textContent;
if (mb_strpos($text, '${' . $search . "}") !== false) {
$cols = $row->getElementsByTagName('tc');
$isFind = false;
$index = 0;
//value编号
foreach ($cols as $kk => $col) {
$text = $col->textContent;
if (mb_strpos($text, '${' . $search . "}") !== false) {
$isFind = true;
}
if (isset($replace["value"][$index]) && $isFind) {
$p = $col->getElementsByTagName('t');
if ($p->item(0)->nodeName == "w:t") {
$p->item(0)->nodeValue = $replace["value"][$index];
} else {
$element_r = $xml->createElement("w:r");
$element_rPr = $xml->createElement("w:rPr");
$element_rFonts = $xml->createElement("w:rFonts");
$element_rFonts->setAttribute("w:ascii", "仿宋_GB2312");
$element_rFonts->setAttribute("w:eastAsia", "仿宋_GB2312");
$element_rFonts->setAttribute("w:hAnsi", "仿宋_GB2312");
$element_rFonts->setAttribute("w:cs", "仿宋_GB2312");
$element_rPr->appendChild($element_rFonts);
$element_t = $xml->createElement("w:t");
$element_sz = $xml->createElement("w:sz");
$element_sz->setAttribute("w:val", "24");
$element_t->nodeValue = $replace["value"][$index];
$element_r->appendChild($element_rPr);
$element_rPr->appendChild($element_sz);
$element_r->appendChild($element_t);
$col->getElementsByTagName('p')->item(0)->appendChild($element_r);
}
$index++;
}
}
}
}
}
} else {
//竖向填充
foreach ($xmlTable as $table) {
$rows = $table->getElementsByTagName('tr');
$isFind = false;
$td_index = -1;
//行填充td编号
$index = 0;
//value编号
foreach ($rows as $k => $row) {
$text = $row->textContent;
if (mb_strpos($text, '${' . $search . "}") !== false || $td_index != -1) {
//填充td编号不为空时即已经找到标签并准备向下填充
$cols = $row->getElementsByTagName('tc');
foreach ($cols as $kk => $col) {
$text = $col->textContent;
if (mb_strpos($text, '${' . $search . "}") !== false && $td_index == -1) {
$isFind = true;
$td_index = $kk;
} elseif ($td_index != -1) {
$isFind = true;
}
$p = $col->getElementsByTagName('t');
if (isset($replace["value"][$index]) && $isFind && $td_index == $kk) {
if ($p->item(0)->nodeName == "w:t") {
$p->item(0)->nodeValue = $replace["value"][$index];
} else {
$element_r = $xml->createElement("w:r");
$element_rPr = $xml->createElement("w:rPr");
$element_rFonts = $xml->createElement("w:rFonts");
$element_rFonts->setAttribute("w:ascii", "仿宋_GB2312");
$element_rFonts->setAttribute("w:eastAsia", "仿宋_GB2312");
$element_rFonts->setAttribute("w:hAnsi", "仿宋_GB2312");
$element_rFonts->setAttribute("w:cs", "仿宋_GB2312");
$element_rPr->appendChild($element_rFonts);
$element_t = $xml->createElement("w:t");
$element_sz = $xml->createElement("w:sz");
$element_sz->setAttribute("w:val", "24");
$element_t->nodeValue = $replace["value"][$index];
$element_r->appendChild($element_rPr);
$element_rPr->appendChild($element_sz);
$element_r->appendChild($element_t);
$col->getElementsByTagName('p')->item(0)->appendChild($element_r);
}
$index++;
}
}
}
}
}
}
$res_string = $xml->saveXML();
$this->_documentXML = $res_string;
}
}
}
}
