Esempio n. 1
0
    $a8 = unserialize(work_db($id, '_19_58_a8'));
    $a9 = unserialize(work_db($id, '_19_58_a9'));
    $a10 = unserialize(work_db($id, '_19_58_a10'));
    $a11 = unserialize(work_db($id, '_19_58_a11'));
    $a12 = unserialize(work_db($id, '_19_58_a12'));
    $a13 = unserialize(work_db($id, '_19_58_a13'));
    $a14 = unserialize(work_db($id, '_19_58_a14'));
    for ($i = 0; $i < 15; $i++) {
        $m++;
        $htmls .= "<tr height=33 style='mso-height-source:userset;height:24.95pt'>\n  <td height=33 class=xl24 width=38 style='height:24.95pt;border-top:none;\n  width:29pt'>" . $m . "</td>\n  <td class=xl24 width=87 style='border-top:none;border-left:none;width:65pt'>" . $a1[$i] . "</td>\n  <td class=xl24 width=119 style='border-top:none;border-left:none;width:89pt'>" . $a2[$i] . "</td>\n  <td class=xl24 width=86 style='border-top:none;border-left:none;width:65pt'>" . $a3[$i] . "</td>\n  <td class=xl24 width=86 style='border-top:none;border-left:none;width:65pt'>" . $a4[$i] . "</td>\n  <td class=xl24 width=113 style='border-top:none;border-left:none;width:85pt'>" . $a5[$i] . "</td>\n  <td class=xl24 width=98 style='border-top:none;border-left:none;width:74pt'>" . $a6[$i] . "</td>\n  <td class=xl24 width=91 style='border-top:none;border-left:none;width:68pt'>" . $a7[$i] . "</td>\n  <td class=xl24 width=93 style='border-top:none;border-left:none;width:70pt'>" . $a8[$i] . "</td>\n  <td class=xl24 width=88 style='border-top:none;border-left:none;width:66pt'>" . $a9[$i] . "</td>\n  <td class=xl24 width=82 style='border-top:none;border-left:none;width:62pt'>" . $a10[$i] . "</td>\n  <td class=xl24 width=112 style='border-top:none;border-left:none;width:84pt'>" . $a11[$i] . "</td>\n  <td class=xl24 width=94 style='border-top:none;border-left:none;width:71pt'>" . $a12[$i] . "</td>\n  <td class=xl24 width=80 style='border-top:none;border-left:none;width:60pt'>" . $a13[$i] . "</td>\n  <td class=xl24 width=130 style='border-top:none;border-left:none;width:98pt'>" . $a14[$i] . "</td>\n </tr>";
    }
    $htmls .= "<tr height=33 style='mso-height-source:userset;height:24.95pt'>\n  <td colspan=4 height=33 class=xl27 width=330 style='height:24.95pt;\n  width:248pt'>编制:" . work_db($id, '_19_58_3') . "</td>\n  <td colspan=11 class=xl27 width=1067 style='width:803pt'>审核:" . w_p_v(190, $id, 'name') . "</td>\n </tr>\n <![if supportMisalignedColumns]>\n <tr height=0 style='display:none'>\n  <td width=38 style='width:29pt'></td>\n  <td width=87 style='width:65pt'></td>\n  <td width=119 style='width:89pt'></td>\n  <td width=86 style='width:65pt'></td>\n  <td width=86 style='width:65pt'></td>\n  <td width=113 style='width:85pt'></td>\n  <td width=98 style='width:74pt'></td>\n  <td width=91 style='width:68pt'></td>\n  <td width=93 style='width:70pt'></td>\n  <td width=88 style='width:66pt'></td>\n  <td width=82 style='width:62pt'></td>\n  <td width=112 style='width:84pt'></td>\n  <td width=94 style='width:71pt'></td>\n  <td width=80 style='width:60pt'></td>\n  <td width=130 style='width:98pt'></td>\n </tr>\n <![endif]>\n</table>\n\n</body>\n\n</html>\n\n";
    return $htmls;
}
?>



<!--内容部份 -->
<?php 
$docs = trim(xls_views($row['id'], $row['uid']));
$Path = "data/excel/workclass/" . $row['id'] . ".xls";
$fp = fopen($Path, "w");
fwrite($fp, $docs);
fclose($fp);
echo $docs;
?>
<!--/内容部份 -->

<?php 
include_once 'footer_view.php';
Esempio n. 2
0
  <x:WindowHeight>11640</x:WindowHeight>
  <x:WindowWidth>19200</x:WindowWidth>
  <x:WindowTopX>0</x:WindowTopX>
  <x:WindowTopY>90</x:WindowTopY>
  <x:ProtectStructure>False</x:ProtectStructure>
  <x:ProtectWindows>False</x:ProtectWindows>
 </x:ExcelWorkbook>
</xml><![endif]-->
</head>

<body link=blue vlink=purple class=xl65>';
    $htmls .= "<table x:str border=0 cellpadding=0 cellspacing=0 width=715 style='border-collapse:\n collapse;table-layout:fixed;width:536pt'>\n <col class=xl65 width=160 span=3 style='mso-width-source:userset;mso-width-alt:\n 5120;width:120pt'>\n <col class=xl65 width=235 style='mso-width-source:userset;mso-width-alt:7520;\n width:176pt'>\n <tr height=49 style='mso-height-source:userset;height:36.75pt'>\n  <td colspan=4 height=49 class=xl66 width=715 style='height:36.75pt;\n  width:536pt'>" . $title . "</td>\n </tr>\n <tr height=39 style='mso-height-source:userset;height:29.25pt'>\n  <td height=39 class=xl67 width=160 style='height:29.25pt;width:120pt'>经办人</td>\n  <td class=xl73 width=160 style='border-left:none;width:120pt'>" . project_db($id, '_4_10_2_1') . "</td>\n  <td class=xl68 width=160 style='border-left:none;width:120pt'>日期</td>\n  <td class=xl74 width=235 style='border-left:none;width:176pt'>" . project_db($id, '_4_10_2_2') . "</td>\n </tr>\n <tr height=39 style='mso-height-source:userset;height:29.25pt'>\n  <td height=39 class=xl69 width=160 style='height:29.25pt;border-top:none;\n  width:120pt'>合同项目</td>\n  <td colspan=3 class=xl75 width=555 style='border-right:1.0pt solid black;\n  border-left:none;width:416pt'>" . project_db($id, '_4_10_2_3') . "</td>\n </tr>\n <tr height=39 style='mso-height-source:userset;height:29.25pt'>\n  <td height=39 class=xl69 width=160 style='height:29.25pt;border-top:none;\n  width:120pt'>甲方</td>\n  <td class=xl78 width=160 style='border-top:none;border-left:none;width:120pt'>" . project_db($id, '_4_10_2_4') . "</td>\n  <td class=xl70 width=160 style='border-top:none;border-left:none;width:120pt'>乙方</td>\n  <td class=xl79 width=235 style='border-top:none;border-left:none;width:176pt'>" . project_db($id, '_4_10_2_5') . "</td>\n </tr>\n <tr height=39 style='mso-height-source:userset;height:29.25pt'>\n  <td height=39 class=xl69 width=160 style='height:29.25pt;border-top:none;\n  width:120pt'>合同编号</td>\n  <td class=xl78 width=160 style='border-top:none;border-left:none;width:120pt'>" . project_db($id, '_4_10_2_6') . "</td>\n  <td class=xl70 width=160 style='border-top:none;border-left:none;width:120pt'>项目地点</td>\n  <td class=xl79 width=235 style='border-top:none;border-left:none;width:176pt'>" . project_db($id, '_4_10_2_7') . "</td>\n </tr>\n <tr height=39 style='mso-height-source:userset;height:29.25pt'>\n  <td height=39 class=xl69 width=160 style='height:29.25pt;border-top:none;\n  width:120pt'>合同类型</td>\n  <td class=xl78 width=160 style='border-top:none;border-left:none;width:120pt'>" . project_db($id, '_4_10_2_8') . "</td>\n  <td class=xl70 width=160 style='border-top:none;border-left:none;width:120pt'>合同期限</td>\n  <td class=xl79 width=235 style='border-top:none;border-left:none;width:176pt'>" . project_db($id, '_4_10_2_9') . "</td>\n </tr>\n <tr height=39 style='mso-height-source:userset;height:29.25pt'>\n  <td height=39 class=xl69 width=160 style='height:29.25pt;border-top:none;\n  width:120pt'>合同金额</td>\n  <td colspan=3 class=xl78 width=555 style='border-right:1.0pt solid black;\n  border-left:none;width:416pt'>" . project_db($id, '_4_10_2_10') . "</td>\n </tr>\n <tr height=39 style='mso-height-source:userset;height:29.25pt'>\n  <td height=39 class=xl69 width=160 style='height:29.25pt;border-top:none;\n  width:120pt'>大写</td>\n  <td colspan=3 class=xl78 width=555 style='border-right:1.0pt solid black;\n  border-left:none;width:416pt'>" . project_db($id, '_4_10_2_11') . "</td>\n </tr>\n <tr height=57 style='mso-height-source:userset;height:42.75pt'>\n  <td height=57 class=xl69 width=160 style='height:42.75pt;border-top:none;\n  width:120pt'>付款方式</td>\n  <td colspan=3 class=xl78 width=555 style='border-right:1.0pt solid black;\n  border-left:none;width:416pt'>" . project_db($id, '_4_10_2_12') . "</td>\n </tr>\n <tr height=159 style='mso-height-source:userset;height:119.25pt'>\n  <td height=159 class=xl69 width=160 style='height:119.25pt;border-top:none;\n  width:120pt'>项目内容说明</td>\n  <td colspan=3 class=xl78 width=555 style='border-right:1.0pt solid black;\n  border-left:none;width:416pt'>" . project_db($id, '_4_10_2_13') . "</td>\n </tr>\n <tr height=74 style='mso-height-source:userset;height:55.5pt'>\n  <td height=74 class=xl69 width=160 style='height:55.5pt;border-top:none;\n  width:120pt'>备注</td>\n  <td colspan=3 class=xl78 width=555 style='border-right:1.0pt solid black;\n  border-left:none;width:416pt'>" . project_db($id, '_4_10_2_14') . "</td>\n </tr>\n <tr height=44 style='mso-height-source:userset;height:33.0pt'>\n  <td height=44 class=xl69 width=160 style='height:33.0pt;border-top:none;\n  width:120pt'>部门负责人审批</td>\n  <td class=xl78 width=160 style='border-top:none;border-left:none;width:120pt'>" . w_p_v(4, $id, 'name') . "</td>\n  <td class=xl70 width=160 style='border-top:none;border-left:none;width:120pt'>运营负责人审批</td>\n  <td class=xl79 width=235 style='border-top:none;border-left:none;width:176pt'>" . w_p_v(5, $id, 'name') . "</td>\n </tr>\n <tr height=44 style='mso-height-source:userset;height:33.0pt'>\n  <td height=44 class=xl71 width=160 style='height:33.0pt;border-top:none;\n  width:120pt'>财务负责人审批</td>\n  <td class=xl80 width=160 style='border-top:none;border-left:none;width:120pt'>" . w_p_v(6, $id, 'name') . "</td>\n  <td class=xl72 width=160 style='border-top:none;border-left:none;width:120pt'>总经理审批</td>\n  <td class=xl81 width=235 style='border-top:none;border-left:none;width:176pt'>" . w_p_v(7, $id, 'name') . "</td>\n </tr>\n <![if supportMisalignedColumns]>\n <tr height=0 style='display:none'>\n  <td width=160 style='width:120pt'></td>\n  <td width=160 style='width:120pt'></td>\n  <td width=160 style='width:120pt'></td>\n  <td width=235 style='width:176pt'></td>\n </tr>\n <![endif]>\n</table>\n\n</body>\n\n</html>\n\n";
    return $htmls;
}
?>



<!--内容部份 -->
<?php 
$docs = trim(xls_views($row['lid'], $row['uid'], $row['title']));
$Path = "data/excel/project/l_" . $row['lid'] . ".xls";
$fp = fopen($Path, "w");
fwrite($fp, $docs);
fclose($fp);
echo $docs;
?>
<!--/内容部份 -->

<?php 
include_once 'footer_view.php';