PHP project_dbの例

プログラミング言語: PHP

メソッド/関数: project_db

hotexamples.comのコード掲載数: 10

PHP project_db - 10件のコード例が見つかりました。すべてオープンソースプロジェクトから抽出されたPHPのproject_dbの実例で、最も評価が高いものを厳選しています。コード例の評価を行っていただくことで、より質の高いコード例が表示されるようになります。

コード例 #1

ファイルを表示

ファイル: type_4.php プロジェクト: haogm123/ydoa

     <x:Print>
      <x:ValidPrinterInfo/>
      <x:PaperSizeIndex>9</x:PaperSizeIndex>
      <x:HorizontalResolution>200</x:HorizontalResolution>
      <x:VerticalResolution>200</x:VerticalResolution>
     </x:Print>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
  </x:ExcelWorksheets>
  <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>';
$html .= "<table x:str border=0 cellpadding=0 cellspacing=0 width=706 style='border-collapse:\n collapse;table-layout:fixed;width:530pt'>\n <col width=140 style='mso-width-source:userset;mso-width-alt:4480;width:105pt'>\n <col width=213 style='mso-width-source:userset;mso-width-alt:6816;width:160pt'>\n <col width=140 style='mso-width-source:userset;mso-width-alt:4480;width:105pt'>\n <col width=213 style='mso-width-source:userset;mso-width-alt:6816;width:160pt'>\n <tr height=59 style='mso-height-source:userset;height:44.25pt'>\n  <td colspan=4 height=59 class=xl69 width=706 style='height:44.25pt;\n  width:530pt'>" . $row['title'] . "</td>\n </tr>\n <tr height=34 style='mso-height-source:userset;height:25.5pt'>\n  <td height=34 class=xl65 style='height:25.5pt'>客户名称</td>\n  <td class=xl77 width=213 style='border-left:none;width:160pt'>" . project_db($row['id'], '_4_4_1_1') . "</td>\n  <td class=xl66 style='border-left:none'>项目名称</td>\n  <td class=xl78 width=213 style='border-left:none;width:160pt'>" . project_db($row['id'], '_4_4_1_2') . "</td>\n </tr>\n <tr height=34 style='mso-height-source:userset;height:25.5pt'>\n  <td height=34 class=xl67 style='height:25.5pt;border-top:none'>项目类型</td>\n  <td colspan=3 class=xl70 width=566 style='border-right:1.0pt solid black;\n  border-left:none;width:425pt'><span\n  style='mso-spacerun:yes'>" . project_db($row['id'], '_4_4_1_3') . "</span></td>\n </tr>\n <tr height=34 style='mso-height-source:userset;height:25.5pt'>\n  <td height=34 class=xl67 style='height:25.5pt;border-top:none'>项目地点</td>\n  <td colspan=3 class=xl73 width=566 style='border-right:1.0pt solid black;\n  border-left:none;width:425pt'>" . project_db($row['id'], '_4_4_1_4') . "</td>\n </tr>\n <tr height=34 style='mso-height-source:userset;height:25.5pt'>\n  <td height=34 class=xl67 style='height:25.5pt;border-top:none'>项目期限</td>\n  <td colspan=3 class=xl73 width=566 style='border-right:1.0pt solid black;\n  border-left:none;width:425pt'>" . project_db($row['id'], '_4_4_1_5') . "</td>\n </tr>\n <tr height=34 style='mso-height-source:userset;height:25.5pt'>\n  <td height=34 class=xl67 style='height:25.5pt;border-top:none'>预估项目金额</td>\n  <td colspan=3 class=xl73 width=566 style='border-right:1.0pt solid black;\n  border-left:none;width:425pt'>" . project_db($row['id'], '_4_4_1_6') . "</td>\n </tr>\n <tr height=158 style='mso-height-source:userset;height:118.5pt'>\n  <td height=158 class=xl67 style='height:118.5pt;border-top:none'>前期接洽甲方意见</td>\n  <td colspan=3 class=xl73 width=566 style='border-right:1.0pt solid black;\n  border-left:none;width:425pt'>" . project_db($row['id'], '_4_4_1_7') . "</td>\n </tr>\n <tr height=34 style='mso-height-source:userset;height:25.5pt'>\n  <td height=34 class=xl67 style='height:25.5pt;border-top:none'>前期接洽业务员</td>\n  <td colspan=3 class=xl73 width=566 style='border-right:1.0pt solid black;\n  border-left:none;width:425pt'>" . project_db($row['id'], '_4_4_1_8') . "</td>\n </tr>\n <tr height=120 style='mso-height-source:userset;height:90.0pt'>\n  <td height=120 class=xl67 style='height:90.0pt;border-top:none'>备注</td>\n  <td colspan=3 class=xl73 width=566 style='border-right:1.0pt solid black;\n  border-left:none;width:425pt'>" . project_db($row['id'], '_4_4_1_9') . "</td>\n </tr>\n <tr height=44 style='mso-height-source:userset;height:33.0pt'>\n  <td height=44 class=xl68 style='height:33.0pt;border-top:none'>部门负责人审批</td>\n  <td colspan=3 class=xl75 width=566 style='border-right:1.0pt solid black;\n  border-left:none;width:425pt'>" . w_p_v(2, $row['id'], 'name') . "</td>\n </tr>\n <![if supportMisalignedColumns]>\n <tr height=0 style='display:none'>\n  <td width=140 style='width:105pt'></td>\n  <td width=213 style='width:160pt'></td>\n  <td width=140 style='width:105pt'></td>\n  <td width=213 style='width:160pt'></td>\n </tr>\n <![endif]>\n</table>\n\n</body>\n\n</html>\n";
?>
</div>
<?php 
$Path = "data/excel/project/p_" . $row['id'] . ".xls";
$fp = fopen($Path, "w");
fwrite($fp, $html);
fclose($fp);

コード例 #2

ファイルを表示

ファイル: 4_11_view.php プロジェクト: haogm123/ydoa

function xls_views($id, $uid, $title)
{
    $htmls .= '<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=Content-Type content="text/html; charset=utf-8">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 11">
<!--[if gte mso 9]><xml>
 <o:DocumentProperties>
  <o:Created>1996-12-17T01:32:42Z</o:Created>
  <o:LastSaved>2013-05-06T02:57:41Z</o:LastSaved>
  <o:Version>11.9999</o:Version>
 </o:DocumentProperties>
 <o:OfficeDocumentSettings>
  <o:RemovePersonalInformation/>
 </o:OfficeDocumentSettings>
</xml><![endif]-->
<style>
<!--table
	{mso-displayed-decimal-separator:"\\.";
	mso-displayed-thousand-separator:"\\,";}
@page
	{margin:1.0in .75in 1.0in .75in;
	mso-header-margin:.5in;
	mso-footer-margin:.5in;}
tr
	{mso-height-source:auto;
	mso-ruby-visibility:none;}
col
	{mso-width-source:auto;
	mso-ruby-visibility:none;}
br
	{mso-data-placement:same-cell;}
.style0
	{mso-number-format:General;
	text-align:general;
	vertical-align:bottom;
	white-space:nowrap;
	mso-rotate:0;
	mso-background-source:auto;
	mso-pattern:auto;
	color:windowtext;
	font-size:12.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	border:none;
	mso-protection:locked visible;
	mso-style-name:常规;
	mso-style-id:0;}
td
	{mso-style-parent:style0;
	padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:12.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-number-format:General;
	text-align:general;
	vertical-align:bottom;
	border:none;
	mso-background-source:auto;
	mso-pattern:auto;
	mso-protection:locked visible;
	white-space:nowrap;
	mso-rotate:0;}
.xl24
	{mso-style-parent:style0;
	text-align:left;
	vertical-align:middle;
	white-space:normal;}
.xl25
	{mso-style-parent:style0;
	font-size:20.0pt;
	text-align:center;
	vertical-align:middle;
	white-space:normal;}
.xl26
	{mso-style-parent:style0;
	text-align:center;
	vertical-align:middle;
	border:.5pt solid windowtext;
	white-space:normal;}
.xl27
	{mso-style-parent:style0;
	text-align:left;
	vertical-align:middle;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:none;
	border-left:none;
	white-space:normal;}
ruby
	{ruby-align:left;}
rt
	{color:windowtext;
	font-size:9.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-char-type:none;
	display:none;}
-->
</style>
<!--[if gte mso 9]><xml>
 <x:ExcelWorkbook>
  <x:ExcelWorksheets>
   <x:ExcelWorksheet>
    <x:Name>Sheet1</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>285</x:DefaultRowHeight>
     <x:Print>
      <x:ValidPrinterInfo/>
      <x:PaperSizeIndex>9</x:PaperSizeIndex>
      <x:HorizontalResolution>180</x:HorizontalResolution>
      <x:VerticalResolution>180</x:VerticalResolution>
     </x:Print>
     <x:CodeName>Sheet1</x:CodeName>
     <x:Selected/>
     <x:Panes>
      <x:Pane>
       <x:Number>3</x:Number>
       <x:ActiveRow>1</x:ActiveRow>
       <x:ActiveCol>8</x:ActiveCol>
      </x:Pane>
     </x:Panes>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
   <x:ExcelWorksheet>
    <x:Name>Sheet2</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>285</x:DefaultRowHeight>
     <x:CodeName>Sheet2</x:CodeName>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
   <x:ExcelWorksheet>
    <x:Name>Sheet3</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>285</x:DefaultRowHeight>
     <x:CodeName>Sheet3</x:CodeName>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
  </x:ExcelWorksheets>
  <x:WindowHeight>4530</x:WindowHeight>
  <x:WindowWidth>8505</x:WindowWidth>
  <x:WindowTopX>480</x:WindowTopX>
  <x:WindowTopY>120</x:WindowTopY>
  <x:AcceptLabelsInFormulas/>
  <x:ProtectStructure>False</x:ProtectStructure>
  <x:ProtectWindows>False</x:ProtectWindows>
 </x:ExcelWorkbook>
</xml><![endif]-->
</head>

<body link=blue vlink=purple>';
    $htmls .= "<table x:str border=0 cellpadding=0 cellspacing=0 width=1262 style='border-collapse:\n collapse;table-layout:fixed;width:948pt'>\n <col width=63 style='mso-width-source:userset;mso-width-alt:2016;width:47pt'>\n <col width=133 style='mso-width-source:userset;mso-width-alt:4256;width:100pt'>\n <col width=209 style='mso-width-source:userset;mso-width-alt:6688;width:157pt'>\n <col width=98 style='mso-width-source:userset;mso-width-alt:3136;width:74pt'>\n <col width=139 style='mso-width-source:userset;mso-width-alt:4448;width:104pt'>\n <col width=167 style='mso-width-source:userset;mso-width-alt:5344;width:125pt'>\n <col width=85 style='mso-width-source:userset;mso-width-alt:2720;width:64pt'>\n <col width=186 style='mso-width-source:userset;mso-width-alt:5952;width:140pt'>\n <col width=182 style='mso-width-source:userset;mso-width-alt:5824;width:137pt'>\n <tr height=80 style='mso-height-source:userset;height:60.0pt'>\n  <td colspan=9 height=80 class=xl25 width=1262 style='height:60.0pt;\n  width:948pt'>" . project_db($id, '_4_11_2_date') . "工程制作进度</td>\n </tr>\n <tr height=47 style='mso-height-source:userset;height:35.25pt'>\n  <td height=47 class=xl26 width=63 style='height:35.25pt;width:47pt'>序号</td>\n  <td class=xl26 width=133 style='border-left:none;width:100pt'>班组</td>\n  <td class=xl26 width=209 style='border-left:none;width:157pt'>工作内容</td>\n  <td class=xl26 width=98 style='border-left:none;width:74pt'>负责人</td>\n  <td class=xl26 width=139 style='border-left:none;width:104pt'>实际工作人员</td>\n  <td class=xl26 width=167 style='border-left:none;width:125pt'>外请人员</td>\n  <td class=xl26 width=85 style='border-left:none;width:64pt'>是否完成<br>\n    本日工作</td>\n  <td class=xl26 width=186 style='border-left:none;width:140pt'>未完成情况</td>\n  <td class=xl26 width=182 style='border-left:none;width:137pt'>其他备注</td>\n </tr>";
    $m = 0;
    $a1 = unserialize(project_db($id, '_4_11_2_a1'));
    $a2 = unserialize(project_db($id, '_4_11_2_a2'));
    $a3 = unserialize(project_db($id, '_4_11_2_a3'));
    $a4 = unserialize(project_db($id, '_4_11_2_a4'));
    $a5 = unserialize(project_db($id, '_4_11_2_a5'));
    $a6 = unserialize(project_db($id, '_4_11_2_a6'));
    $a7 = unserialize(project_db($id, '_4_11_2_a7'));
    $a8 = unserialize(project_db($id, '_4_11_2_a8'));
    for ($i = 0; $i < 15; $i++) {
        $m++;
        $htmls .= " <tr height=33 style='mso-height-source:userset;height:24.95pt'>\n  <td height=33 class=xl26 width=63 style='height:24.95pt;border-top:none;\n  width:47pt'>" . $m . "</td>\n  <td class=xl26 width=133 style='border-top:none;border-left:none;width:100pt'>" . $a1[$i] . "</td>\n  <td class=xl26 width=209 style='border-top:none;border-left:none;width:157pt'>" . $a2[$i] . "</td>\n  <td class=xl26 width=98 style='border-top:none;border-left:none;width:74pt'>" . $a3[$i] . "</td>\n  <td class=xl26 width=139 style='border-top:none;border-left:none;width:104pt'>" . $a4[$i] . "</td>\n  <td class=xl26 width=167 style='border-top:none;border-left:none;width:125pt'>" . $a5[$i] . "</td>\n  <td class=xl26 width=85 style='border-top:none;border-left:none;width:64pt'>" . $a6[$i] . "</td>\n  <td class=xl26 width=186 style='border-top:none;border-left:none;width:140pt'>" . $a7[$i] . "</td>\n  <td class=xl26 width=182 style='border-top:none;border-left:none;width:137pt'>" . $a8[$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=503 style='height:24.95pt;\n  width:378pt'>填报人：" . get_realname($uid) . "</td>\n  <td colspan=5 class=xl24 style='mso-ignore:colspan'></td>\n </tr>\n <![if supportMisalignedColumns]>\n <tr height=0 style='display:none'>\n  <td width=63 style='width:47pt'></td>\n  <td width=133 style='width:100pt'></td>\n  <td width=209 style='width:157pt'></td>\n  <td width=98 style='width:74pt'></td>\n  <td width=139 style='width:104pt'></td>\n  <td width=167 style='width:125pt'></td>\n  <td width=85 style='width:64pt'></td>\n  <td width=186 style='width:140pt'></td>\n  <td width=182 style='width:137pt'></td>\n </tr>\n <![endif]>\n</table>\n\n</body>\n\n</html>\n\n\n";
    return $htmls;
}

コード例 #3

ファイルを表示

ファイル: 4_10_view.php プロジェクト: haogm123/ydoa

function xls_views($id, $uid, $title)
{
    $htmls .= '<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=Content-Type content="text/html; charset=utf-8">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 11">
<!--[if gte mso 9]><xml>
 <o:DocumentProperties>
  <o:Created>2006-09-13T11:21:51Z</o:Created>
  <o:LastSaved>2013-05-03T03:55:31Z</o:LastSaved>
  <o:Version>11.9999</o:Version>
 </o:DocumentProperties>
 <o:OfficeDocumentSettings>
  <o:RemovePersonalInformation/>
 </o:OfficeDocumentSettings>
</xml><![endif]-->
<style>
<!--table
	{mso-displayed-decimal-separator:"\\.";
	mso-displayed-thousand-separator:"\\,";}
@page
	{margin:.75in .7in .75in .7in;
	mso-header-margin:.3in;
	mso-footer-margin:.3in;}
tr
	{mso-height-source:auto;
	mso-ruby-visibility:none;}
col
	{mso-width-source:auto;
	mso-ruby-visibility:none;}
br
	{mso-data-placement:same-cell;}
.style0
	{mso-number-format:General;
	text-align:general;
	vertical-align:middle;
	white-space:nowrap;
	mso-rotate:0;
	mso-background-source:auto;
	mso-pattern:auto;
	color:black;
	font-size:11.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	border:none;
	mso-protection:locked visible;
	mso-style-name:常规;
	mso-style-id:0;}
td
	{mso-style-parent:style0;
	padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:black;
	font-size:11.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-number-format:General;
	text-align:general;
	vertical-align:middle;
	border:none;
	mso-background-source:auto;
	mso-pattern:auto;
	mso-protection:locked visible;
	white-space:nowrap;
	mso-rotate:0;}
.xl65
	{mso-style-parent:style0;
	text-align:center;}
.xl66
	{mso-style-parent:style0;
	font-size:14.0pt;
	font-weight:700;
	text-align:center;}
.xl67
	{mso-style-parent:style0;
	text-align:center;
	border-top:1.0pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:1.0pt solid windowtext;
	white-space:normal;}
.xl68
	{mso-style-parent:style0;
	text-align:center;
	border-top:1.0pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl69
	{mso-style-parent:style0;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:1.0pt solid windowtext;
	white-space:normal;}
.xl70
	{mso-style-parent:style0;
	text-align:center;
	border:.5pt solid windowtext;
	white-space:normal;}
.xl71
	{mso-style-parent:style0;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:1.0pt solid windowtext;
	border-left:1.0pt solid windowtext;
	white-space:normal;}
.xl72
	{mso-style-parent:style0;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:1.0pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl73
	{mso-style-parent:style0;
	text-align:left;
	border-top:1.0pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl74
	{mso-style-parent:style0;
	text-align:left;
	border-top:1.0pt solid windowtext;
	border-right:1.0pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl75
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl76
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	white-space:normal;}
.xl77
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:1.0pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	white-space:normal;}
.xl78
	{mso-style-parent:style0;
	text-align:left;
	border:.5pt solid windowtext;
	white-space:normal;}
.xl79
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:1.0pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl80
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:1.0pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl81
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:1.0pt solid windowtext;
	border-bottom:1.0pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
ruby
	{ruby-align:left;}
rt
	{color:windowtext;
	font-size:9.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-char-type:none;
	display:none;}
-->
</style>
<!--[if gte mso 9]><xml>
 <x:ExcelWorkbook>
  <x:ExcelWorksheets>
   <x:ExcelWorksheet>
    <x:Name>Sheet1</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>439</x:DefaultRowHeight>
     <x:Unsynced/>
     <x:Print>
      <x:ValidPrinterInfo/>
      <x:PaperSizeIndex>9</x:PaperSizeIndex>
      <x:HorizontalResolution>200</x:HorizontalResolution>
      <x:VerticalResolution>200</x:VerticalResolution>
     </x:Print>
     <x:Selected/>
     <x:Panes>
      <x:Pane>
       <x:Number>3</x:Number>
       <x:ActiveRow>16</x:ActiveRow>
       <x:ActiveCol>1</x:ActiveCol>
      </x:Pane>
     </x:Panes>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
   <x:ExcelWorksheet>
    <x:Name>Sheet2</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>270</x:DefaultRowHeight>
     <x:Print>
      <x:ValidPrinterInfo/>
      <x:PaperSizeIndex>9</x:PaperSizeIndex>
      <x:HorizontalResolution>200</x:HorizontalResolution>
      <x:VerticalResolution>200</x:VerticalResolution>
     </x:Print>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
   <x:ExcelWorksheet>
    <x:Name>Sheet3</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>270</x:DefaultRowHeight>
     <x:Print>
      <x:ValidPrinterInfo/>
      <x:PaperSizeIndex>9</x:PaperSizeIndex>
      <x:HorizontalResolution>200</x:HorizontalResolution>
      <x:VerticalResolution>200</x:VerticalResolution>
     </x:Print>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
  </x:ExcelWorksheets>
  <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;
}

コード例 #4

ファイルを表示

ファイル: 16_ngyanshoudan_view.php プロジェクト: haogm123/ydoa

function xls_views($id, $uid, $title)
{
    $htmls .= '<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=Content-Type content="text/html; charset=utf-8">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 11">
<!--[if gte mso 9]><xml>
 <o:DocumentProperties>
  <o:Created>2006-09-13T11:21:51Z</o:Created>
  <o:LastSaved>2013-05-06T09:23:03Z</o:LastSaved>
  <o:Version>11.9999</o:Version>
 </o:DocumentProperties>
 <o:OfficeDocumentSettings>
  <o:RemovePersonalInformation/>
 </o:OfficeDocumentSettings>
</xml><![endif]-->
<style>
<!--table
	{mso-displayed-decimal-separator:"\\.";
	mso-displayed-thousand-separator:"\\,";}
@page
	{margin:.75in .7in .75in .7in;
	mso-header-margin:.3in;
	mso-footer-margin:.3in;}
tr
	{mso-height-source:auto;
	mso-ruby-visibility:none;}
col
	{mso-width-source:auto;
	mso-ruby-visibility:none;}
br
	{mso-data-placement:same-cell;}
.style0
	{mso-number-format:General;
	text-align:general;
	vertical-align:middle;
	white-space:nowrap;
	mso-rotate:0;
	mso-background-source:auto;
	mso-pattern:auto;
	color:black;
	font-size:11.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	border:none;
	mso-protection:locked visible;
	mso-style-name:常规;
	mso-style-id:0;}
td
	{mso-style-parent:style0;
	padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:black;
	font-size:11.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-number-format:General;
	text-align:general;
	vertical-align:middle;
	border:none;
	mso-background-source:auto;
	mso-pattern:auto;
	mso-protection:locked visible;
	white-space:nowrap;
	mso-rotate:0;}
.xl65
	{mso-style-parent:style0;
	text-align:center;
	border-top:1.0pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:1.0pt solid windowtext;
	white-space:normal;}
.xl66
	{mso-style-parent:style0;
	text-align:center;
	border-top:1.0pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl67
	{mso-style-parent:style0;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:1.0pt solid windowtext;
	white-space:normal;}
.xl68
	{mso-style-parent:style0;
	text-align:center;
	border:.5pt solid windowtext;
	white-space:normal;}
.xl69
	{mso-style-parent:style0;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:1.0pt solid windowtext;
	border-left:1.0pt solid windowtext;
	white-space:normal;}
.xl70
	{mso-style-parent:style0;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:1.0pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl71
	{mso-style-parent:style0;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:1.0pt solid windowtext;
	border-bottom:1.0pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl72
	{mso-style-parent:style0;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:none;
	border-left:1.0pt solid windowtext;
	white-space:normal;}
.xl73
	{mso-style-parent:style0;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:none;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl74
	{mso-style-parent:style0;
	text-align:left;
	border-top:1.0pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl75
	{mso-style-parent:style0;
	text-align:left;
	border-top:1.0pt solid windowtext;
	border-right:1.0pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl76
	{mso-style-parent:style0;
	text-align:left;
	border:.5pt solid windowtext;
	white-space:normal;}
.xl77
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:1.0pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl78
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:none;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl79
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:1.0pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl80
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:1.0pt solid windowtext;
	border-bottom:none;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl81
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:1.0pt solid windowtext;
	border-bottom:1.0pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl82
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl83
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	white-space:normal;}
.xl84
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:1.0pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	white-space:normal;}
.xl85
	{mso-style-parent:style0;
	font-size:14.0pt;
	font-weight:700;
	text-align:center;
	white-space:normal;}
.xl86
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:1.0pt solid windowtext;
	white-space:normal;}
.xl87
	{mso-style-parent:style0;
	text-align:left;
	border-top:none;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:1.0pt solid windowtext;
	white-space:normal;}
.xl88
	{mso-style-parent:style0;
	text-align:left;
	border-top:none;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl89
	{mso-style-parent:style0;
	text-align:left;
	border-top:none;
	border-right:1.0pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
ruby
	{ruby-align:left;}
rt
	{color:windowtext;
	font-size:9.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-char-type:none;
	display:none;}
-->
</style>
<!--[if gte mso 9]><xml>
 <x:ExcelWorkbook>
  <x:ExcelWorksheets>
   <x:ExcelWorksheet>
    <x:Name>Sheet1</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>270</x:DefaultRowHeight>
     <x:Print>
      <x:ValidPrinterInfo/>
      <x:PaperSizeIndex>9</x:PaperSizeIndex>
      <x:HorizontalResolution>200</x:HorizontalResolution>
      <x:VerticalResolution>200</x:VerticalResolution>
     </x:Print>
     <x:Zoom>115</x:Zoom>
     <x:Selected/>
     <x:Panes>
      <x:Pane>
       <x:Number>3</x:Number>
       <x:ActiveRow>16</x:ActiveRow>
       <x:ActiveCol>2</x:ActiveCol>
      </x:Pane>
     </x:Panes>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
   <x:ExcelWorksheet>
    <x:Name>Sheet2</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>270</x:DefaultRowHeight>
     <x:Print>
      <x:ValidPrinterInfo/>
      <x:PaperSizeIndex>9</x:PaperSizeIndex>
      <x:HorizontalResolution>200</x:HorizontalResolution>
      <x:VerticalResolution>200</x:VerticalResolution>
     </x:Print>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
   <x:ExcelWorksheet>
    <x:Name>Sheet3</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>270</x:DefaultRowHeight>
     <x:Print>
      <x:ValidPrinterInfo/>
      <x:PaperSizeIndex>9</x:PaperSizeIndex>
      <x:HorizontalResolution>200</x:HorizontalResolution>
      <x:VerticalResolution>200</x:VerticalResolution>
     </x:Print>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
  </x:ExcelWorksheets>
  <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>';
    $htmls .= "<table x:str border=0 cellpadding=0 cellspacing=0 width=706 style='border-collapse:\n collapse;table-layout:fixed;width:530pt'>\n <col width=140 style='mso-width-source:userset;mso-width-alt:4480;width:105pt'>\n <col width=213 style='mso-width-source:userset;mso-width-alt:6816;width:160pt'>\n <col width=140 style='mso-width-source:userset;mso-width-alt:4480;width:105pt'>\n <col width=213 style='mso-width-source:userset;mso-width-alt:6816;width:160pt'>\n <tr height=59 style='mso-height-source:userset;height:44.25pt'>\n  <td colspan=4 height=59 class=xl85 width=706 style='height:44.25pt;\n  width:530pt'>" . $title . "</td>\n </tr>\n <tr height=34 style='mso-height-source:userset;height:25.5pt'>\n  <td height=34 class=xl65 width=140 style='height:25.5pt;width:105pt'>客户名称</td>\n  <td class=xl74 width=213 style='border-left:none;width:160pt'>" . project_db($id, '_4_16_3_1') . "</td>\n  <td class=xl66 width=140 style='border-left:none;width:105pt'>项目名称</td>\n  <td class=xl75 width=213 style='border-left:none;width:160pt'>" . project_db($id, '_4_16_3_2') . "</td>\n </tr>\n <tr height=34 style='mso-height-source:userset;height:25.5pt'>\n  <td height=34 class=xl67 width=140 style='height:25.5pt;border-top:none;\n  width:105pt'>施工单位</td>\n  <td colspan=3 class=xl76 width=566 style='border-right:1.0pt solid black;\n  border-left:none;width:425pt'>" . project_db($id, '_4_16_3_3') . "</td>\n </tr>\n <tr height=34 style='mso-height-source:userset;height:25.5pt'>\n  <td height=34 class=xl67 width=140 style='height:25.5pt;border-top:none;\n  width:105pt'>项目类型</td>\n  <td colspan=3 class=xl76 width=566 style='border-right:1.0pt solid black;\n  border-left:none;width:425pt'>" . project_db($id, '_4_16_3_4') . "</td>\n </tr>\n <tr height=34 style='mso-height-source:userset;height:25.5pt'>\n  <td height=34 class=xl67 width=140 style='height:25.5pt;border-top:none;\n  width:105pt'>项目地点</td>\n  <td colspan=3 class=xl76 width=566 style='border-right:1.0pt solid black;\n  border-left:none;width:425pt'>" . project_db($id, '_4_16_3_5') . "</td>\n </tr>\n <tr height=34 style='mso-height-source:userset;height:25.5pt'>\n  <td height=34 class=xl67 width=140 style='height:25.5pt;border-top:none;\n  width:105pt'>开工日期</td>\n  <td class=xl76 width=213 style='border-top:none;border-left:none;width:160pt'>" . project_db($id, '_4_16_3_6') . "</td>\n  <td class=xl68 width=140 style='border-top:none;border-left:none;width:105pt'>验收日期</td>\n  <td class=xl77 width=213 style='border-top:none;border-left:none;width:160pt'>" . project_db($id, '_4_16_3_7') . "</td>\n </tr>\n <tr height=34 style='mso-height-source:userset;height:25.5pt'>\n  <td colspan=4 height=34 class=xl86 width=706 style='border-right:1.0pt solid black;\n  height:25.5pt;width:530pt'><span\n  style='mso-spacerun:yes'>&nbsp;&nbsp;&nbsp;&nbsp; </span>施工内容：</td>\n </tr>\n <tr height=158 style='mso-height-source:userset;height:118.5pt'>\n  <td colspan=4 height=158 class=xl86 width=706 style='border-right:1.0pt solid black;\n  height:118.5pt;width:530pt'>" . project_db($id, '_4_16_3_8') . "</td>\n </tr>\n <tr height=34 style='mso-height-source:userset;height:25.5pt'>\n  <td height=34 class=xl69 width=140 style='height:25.5pt;border-top:none;\n  width:105pt'>项目负责人</td>\n  <td class=xl70 width=213 style='border-top:none;border-left:none;width:160pt'>" . project_db($id, '_4_16_3_9') . "</td>\n  <td class=xl70 width=140 style='border-top:none;border-left:none;width:105pt'>日期</td>\n  <td class=xl71 width=213 style='border-top:none;border-left:none;width:160pt'>" . project_db($id, '_4_16_3_10') . "</td>\n </tr>\n <tr height=34 style='mso-height-source:userset;height:25.5pt'>\n  <td colspan=4 height=34 class=xl87 width=706 style='border-right:1.0pt solid black;\n  height:25.5pt;width:530pt'><span style='mso-spacerun:yes'>&nbsp;&nbsp;&nbsp;\n  </span>竣工确认：</td>\n </tr>\n <tr height=158 style='mso-height-source:userset;height:118.5pt'>\n  <td colspan=4 height=158 class=xl86 width=706 style='border-right:1.0pt solid black;\n  height:118.5pt;width:530pt'>" . project_db($id, '_4_16_3_11') . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl67 width=140 style='height:27.95pt;border-top:none;\n  width:105pt'>现场确认单</td>\n  <td colspan=3 class=xl82 width=566 style='border-right:1.0pt solid black;\n  border-left:none;width:425pt'>" . project_db($id, '_4_16_3_12') . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl72 width=140 style='height:27.95pt;border-top:none;\n  width:105pt'>甲方验收人</td>\n  <td class=xl78 width=213 style='border-top:none;border-left:none;width:160pt'>" . project_db($id, '_4_16_3_13') . "</td>\n  <td class=xl73 width=140 style='border-top:none;border-left:none;width:105pt'>日期</td>\n  <td class=xl80 width=213 style='border-top:none;border-left:none;width:160pt'>" . project_db($id, '_4_16_3_14') . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl69 width=140 style='height:27.95pt;width:105pt'>填报人</td>\n  <td class=xl79 width=213 style='border-left:none;width:160pt'>" . project_db($id, '_4_16_3_15') . "</td>\n  <td class=xl70 width=140 style='border-left:none;width:105pt'>审核人</td>\n  <td class=xl81 width=213 style='border-left:none;width:160pt'>" . w_p_v(43, $id, 'name') . "</td>\n </tr>\n <![if supportMisalignedColumns]>\n <tr height=0 style='display:none'>\n  <td width=140 style='width:105pt'></td>\n  <td width=213 style='width:160pt'></td>\n  <td width=140 style='width:105pt'></td>\n  <td width=213 style='width:160pt'></td>\n </tr>\n <![endif]>\n</table>\n\n</body>\n\n</html>\n\n\n";
    return $htmls;
}

コード例 #5

ファイルを表示

ファイル: 19_gaiquerenjilu_view.php プロジェクト: haogm123/ydoa

function xls_views($id, $uid, $title)
{
    $htmls .= '<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=Content-Type content="text/html; charset=utf-8">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 11">
<!--[if gte mso 9]><xml>
 <o:DocumentProperties>
  <o:Created>2006-09-13T11:21:51Z</o:Created>
  <o:LastSaved>2013-05-07T08:01:26Z</o:LastSaved>
  <o:Version>11.9999</o:Version>
 </o:DocumentProperties>
 <o:OfficeDocumentSettings>
  <o:RemovePersonalInformation/>
 </o:OfficeDocumentSettings>
</xml><![endif]-->
<style>
<!--table
	{mso-displayed-decimal-separator:"\\.";
	mso-displayed-thousand-separator:"\\,";}
@page
	{margin:.75in .7in .75in .7in;
	mso-header-margin:.3in;
	mso-footer-margin:.3in;}
tr
	{mso-height-source:auto;
	mso-ruby-visibility:none;}
col
	{mso-width-source:auto;
	mso-ruby-visibility:none;}
br
	{mso-data-placement:same-cell;}
.style0
	{mso-number-format:General;
	text-align:general;
	vertical-align:middle;
	white-space:nowrap;
	mso-rotate:0;
	mso-background-source:auto;
	mso-pattern:auto;
	color:black;
	font-size:11.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	border:none;
	mso-protection:locked visible;
	mso-style-name:常规;
	mso-style-id:0;}
td
	{mso-style-parent:style0;
	padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:black;
	font-size:11.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-number-format:General;
	text-align:general;
	vertical-align:middle;
	border:none;
	mso-background-source:auto;
	mso-pattern:auto;
	mso-protection:locked visible;
	white-space:nowrap;
	mso-rotate:0;}
.xl65
	{mso-style-parent:style0;
	text-align:left;}
.xl66
	{mso-style-parent:style0;
	font-size:14.0pt;
	font-weight:700;
	text-align:center;
	white-space:normal;}
.xl67
	{mso-style-parent:style0;
	text-align:center;
	border-top:1.0pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:1.0pt solid windowtext;
	white-space:normal;}
.xl68
	{mso-style-parent:style0;
	text-align:center;
	border-top:1.0pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl69
	{mso-style-parent:style0;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:1.0pt solid windowtext;
	white-space:normal;}
.xl70
	{mso-style-parent:style0;
	text-align:center;
	border:.5pt solid windowtext;
	white-space:normal;}
.xl71
	{mso-style-parent:style0;
	text-align:center;
	border-top:none;
	border-right:none;
	border-bottom:1.0pt solid windowtext;
	border-left:1.0pt solid windowtext;
	background:silver;
	mso-pattern:auto none;
	white-space:normal;}
.xl72
	{mso-style-parent:style0;
	text-align:center;
	border-top:none;
	border-right:none;
	border-bottom:1.0pt solid windowtext;
	border-left:none;
	background:silver;
	mso-pattern:auto none;
	white-space:normal;}
.xl73
	{mso-style-parent:style0;
	text-align:center;
	border-top:none;
	border-right:1.0pt solid windowtext;
	border-bottom:1.0pt solid windowtext;
	border-left:none;
	background:silver;
	mso-pattern:auto none;
	white-space:normal;}
.xl74
	{mso-style-parent:style0;
	text-align:center;
	border-top:1.0pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:1.0pt solid windowtext;
	background:silver;
	mso-pattern:auto none;
	white-space:normal;}
.xl75
	{mso-style-parent:style0;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:1.0pt solid windowtext;
	background:silver;
	mso-pattern:auto none;
	white-space:normal;}
.xl76
	{mso-style-parent:style0;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:none;
	border-left:1.0pt solid windowtext;
	background:silver;
	mso-pattern:auto none;
	white-space:normal;}
.xl77
	{mso-style-parent:style0;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:none;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl78
	{mso-style-parent:style0;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:1.0pt solid windowtext;
	border-left:1.0pt solid windowtext;
	background:silver;
	mso-pattern:auto none;
	white-space:normal;}
.xl79
	{mso-style-parent:style0;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:1.0pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl80
	{mso-style-parent:style0;
	text-align:left;
	border:.5pt solid windowtext;
	white-space:normal;}
.xl81
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:1.0pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl82
	{mso-style-parent:style0;
	text-align:left;
	border-top:1.0pt solid windowtext;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl83
	{mso-style-parent:style0;
	text-align:left;
	border-top:1.0pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	white-space:normal;}
.xl84
	{mso-style-parent:style0;
	text-align:left;
	border-top:1.0pt solid windowtext;
	border-right:1.0pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl85
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl86
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	white-space:normal;}
.xl87
	{mso-style-parent:style0;
	text-align:left;
	border-top:1.0pt solid windowtext;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl88
	{mso-style-parent:style0;
	text-align:left;
	border-top:1.0pt solid windowtext;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	white-space:normal;}
.xl89
	{mso-style-parent:style0;
	text-align:left;
	border-top:1.0pt solid windowtext;
	border-right:1.0pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	white-space:normal;}
.xl90
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl91
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	white-space:normal;}
.xl92
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:1.0pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	white-space:normal;}
.xl93
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:none;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl94
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:none;
	border-left:none;
	white-space:normal;}
.xl95
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:1.0pt solid windowtext;
	border-bottom:none;
	border-left:none;
	white-space:normal;}
.xl96
	{mso-style-parent:style0;
	text-align:left;
	border-top:1.0pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl97
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:1.0pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl98
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:1.0pt solid windowtext;
	border-left:none;
	white-space:normal;}
.xl99
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:1.0pt solid windowtext;
	border-bottom:1.0pt solid windowtext;
	border-left:none;
	white-space:normal;}
.xl100
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:1.0pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl101
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:1.0pt solid windowtext;
	border-bottom:1.0pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl102
	{mso-style-parent:style0;
	text-align:left;
	border-top:1.0pt solid windowtext;
	border-right:none;
	border-bottom:1.0pt solid windowtext;
	border-left:1.0pt solid windowtext;
	white-space:normal;}
.xl103
	{mso-style-parent:style0;
	text-align:left;
	border-top:1.0pt solid windowtext;
	border-right:none;
	border-bottom:1.0pt solid windowtext;
	border-left:none;
	white-space:normal;}
.xl104
	{mso-style-parent:style0;
	text-align:left;
	border-top:1.0pt solid windowtext;
	border-right:1.0pt solid windowtext;
	border-bottom:1.0pt solid windowtext;
	border-left:none;
	white-space:normal;}
ruby
	{ruby-align:left;}
rt
	{color:windowtext;
	font-size:9.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-char-type:none;
	display:none;}
-->
</style>
<!--[if gte mso 9]><xml>
 <x:ExcelWorkbook>
  <x:ExcelWorksheets>
   <x:ExcelWorksheet>
    <x:Name>Sheet1</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>499</x:DefaultRowHeight>
     <x:Unsynced/>
     <x:Print>
      <x:ValidPrinterInfo/>
      <x:PaperSizeIndex>9</x:PaperSizeIndex>
      <x:HorizontalResolution>200</x:HorizontalResolution>
      <x:VerticalResolution>200</x:VerticalResolution>
     </x:Print>
     <x:Selected/>
     <x:TopRowVisible>21</x:TopRowVisible>
     <x:Panes>
      <x:Pane>
       <x:Number>3</x:Number>
       <x:ActiveRow>27</x:ActiveRow>
       <x:ActiveCol>1</x:ActiveCol>
      </x:Pane>
     </x:Panes>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
   <x:ExcelWorksheet>
    <x:Name>Sheet2</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>270</x:DefaultRowHeight>
     <x:Print>
      <x:ValidPrinterInfo/>
      <x:PaperSizeIndex>9</x:PaperSizeIndex>
      <x:HorizontalResolution>200</x:HorizontalResolution>
      <x:VerticalResolution>200</x:VerticalResolution>
     </x:Print>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
   <x:ExcelWorksheet>
    <x:Name>Sheet3</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>270</x:DefaultRowHeight>
     <x:Print>
      <x:ValidPrinterInfo/>
      <x:PaperSizeIndex>9</x:PaperSizeIndex>
      <x:HorizontalResolution>200</x:HorizontalResolution>
      <x:VerticalResolution>200</x:VerticalResolution>
     </x:Print>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
  </x:ExcelWorksheets>
  <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>';
    $htmls .= "<table x:str border=0 cellpadding=0 cellspacing=0 width=1048 style='border-collapse:\n collapse;table-layout:fixed;width:788pt'>\n <col width=122 style='mso-width-source:userset;mso-width-alt:3904;width:92pt'>\n <col width=126 span=2 style='mso-width-source:userset;mso-width-alt:4032;\n width:95pt'>\n <col width=122 style='mso-width-source:userset;mso-width-alt:3904;width:92pt'>\n <col width=247 style='mso-width-source:userset;mso-width-alt:7904;width:185pt'>\n <col class=xl65 width=305 style='mso-width-source:userset;mso-width-alt:9760;\n width:229pt'>\n <tr height=66 style='mso-height-source:userset;height:50.1pt'>\n  <td colspan=5 height=66 class=xl66 width=743 style='height:50.1pt;width:559pt'>" . $title . "</td>\n  <td class=xl65 width=305 style='width:229pt'></td>\n </tr>\n <tr height=34 style='mso-height-source:userset;height:25.5pt'>\n  <td height=34 class=xl67 width=122 style='height:25.5pt;width:92pt'>项目名称</td>\n  <td colspan=2 class=xl82 width=252 style='border-right:.5pt solid black;\n  border-left:none;width:190pt'>" . project_db($id, '_4_19_3_1') . "</td>\n  <td class=xl68 width=122 style='border-left:none;width:92pt'>日期</td>\n  <td class=xl84 width=247 style='border-left:none;width:185pt'>" . project_db($id, '_4_19_3_2') . "</td>\n  <td class=xl65></td>\n </tr>\n <tr height=33 style='mso-height-source:userset;height:24.95pt'>\n  <td height=33 class=xl69 width=122 style='height:24.95pt;border-top:none;\n  width:92pt'>合同编号</td>\n  <td colspan=4 class=xl80 width=621 style='border-right:1.0pt solid black;\n  border-left:none;width:467pt'>" . project_db($id, '_4_19_3_3') . "</td>\n  <td class=xl65></td>\n </tr>\n <tr height=34 style='mso-height-source:userset;height:25.5pt'>\n  <td height=34 class=xl69 width=122 style='height:25.5pt;border-top:none;\n  width:92pt'>项目类型</td>\n  <td colspan=4 class=xl80 width=621 style='border-right:1.0pt solid black;\n  border-left:none;width:467pt' >" . project_db($id, '_4_19_3_4') . "</td>\n  <td class=xl65></td>\n </tr>\n <tr height=34 style='mso-height-source:userset;height:25.5pt'>\n  <td height=34 class=xl69 width=122 style='height:25.5pt;border-top:none;\n  width:92pt'>项目地点</td>\n  <td colspan=4 class=xl80 width=621 style='border-right:1.0pt solid black;\n  border-left:none;width:467pt'>" . project_db($id, '_4_19_3_5') . "</td>\n  <td class=xl65></td>\n </tr>\n <tr height=34 style='mso-height-source:userset;height:25.5pt'>\n  <td height=34 class=xl69 width=122 style='height:25.5pt;border-top:none;\n  width:92pt'>项目期限</td>\n  <td colspan=4 class=xl80 width=621 style='border-right:1.0pt solid black;\n  border-left:none;width:467pt'>" . project_db($id, '_4_19_3_6') . "</td>\n  <td class=xl65></td>\n </tr>\n <tr height=161 style='mso-height-source:userset;height:120.75pt'>\n  <td height=161 class=xl69 width=122 style='height:120.75pt;border-top:none;\n  width:92pt'>项目需求</td>\n  <td colspan=4 class=xl80 width=621 style='border-right:1.0pt solid black;\n  border-left:none;width:467pt'>" . project_db($id, '_4_19_3_7') . "</td>\n  <td class=xl65></td>\n </tr>\n <tr height=34 style='mso-height-source:userset;height:25.5pt'>\n  <td height=34 class=xl69 width=122 style='height:25.5pt;border-top:none;\n  width:92pt'>业务员</td>\n  <td colspan=2 class=xl85 width=252 style='border-right:.5pt solid black;\n  border-left:none;width:190pt'>" . project_db($id, '_4_19_3_8') . "</td>\n  <td class=xl70 width=122 style='border-top:none;border-left:none;width:92pt'>填报人</td>\n  <td class=xl81 width=247 style='border-top:none;border-left:none;width:185pt'>" . project_db($id, '_4_19_3_9') . "</td>\n  <td class=xl65></td>\n </tr>\n <tr height=33 style='mso-height-source:userset;height:24.95pt'>\n  <td colspan=5 height=33 class=xl71 width=743 style='border-right:1.0pt solid black;\n  height:24.95pt;width:559pt'>项目前期分析确认</td>\n  <td class=xl65></td>\n </tr>\n <tr height=33 style='mso-height-source:userset;height:24.95pt'>\n  <td rowspan=6 height=288 class=xl74 width=122 style='height:217.0pt;\n  border-top:none;width:92pt'>设计部确认</td>\n  <td class=xl68 width=126 style='border-top:none;border-left:none;width:95pt'>设计方案</td>\n  <td colspan=3 class=xl87 width=495 style='border-right:1.0pt solid black;\n  border-left:none;width:372pt'>" . project_db($id, '_4_19_4_t1') . "</td>\n  <td class=xl65></td>\n </tr>\n <tr height=33 style='mso-height-source:userset;height:24.95pt'>\n  <td height=33 class=xl70 width=126 style='height:24.95pt;border-top:none;\n  border-left:none;width:95pt'>设计图纸</td>\n  <td colspan=3 class=xl90 width=495 style='border-right:1.0pt solid black;\n  border-left:none;width:372pt'>" . project_db($id, '_4_19_4_t2') . "</td>\n  <td class=xl65></td>\n </tr>\n <tr height=103 style='mso-height-source:userset;height:77.25pt'>\n  <td height=103 class=xl70 width=126 style='height:77.25pt;border-top:none;\n  border-left:none;width:95pt'>设计部意见</td>\n  <td colspan=3 class=xl90 width=495 style='border-right:1.0pt solid black;\n  border-left:none;width:372pt'>" . project_db($id, '_4_19_4_t3') . "</td>\n  <td class=xl65></td>\n </tr>\n <tr height=33 style='mso-height-source:userset;height:24.95pt'>\n  <td height=33 class=xl70 width=126 style='height:24.95pt;border-top:none;\n  border-left:none;width:95pt'>填报人</td>\n  <td colspan=3 class=xl90 width=495 style='border-right:1.0pt solid black;\n  border-left:none;width:372pt'>" . project_db($id, '_4_19_4_t4') . "</td>\n  <td class=xl65></td>\n </tr>\n <tr height=33 style='mso-height-source:userset;height:24.95pt'>\n  <td height=33 class=xl70 width=126 style='height:24.95pt;border-top:none;\n  border-left:none;width:95pt'>审核人</td>\n  <td colspan=3 class=xl90 width=495 style='border-right:1.0pt solid black;\n  border-left:none;width:372pt'>" . project_db($id, '_4_19_4_t5') . "</td>\n  <td class=xl65></td>\n </tr>\n <tr height=53 style='mso-height-source:userset;height:39.95pt'>\n  <td height=53 class=xl77 width=126 style='height:39.95pt;border-top:none;\n  border-left:none;width:95pt'>审核意见</td>\n  <td colspan=3 class=xl93 width=495 style='border-right:1.0pt solid black;\n  border-left:none;width:372pt'>" . w_p_v(58, $id, 'lnstructions') . "</td>\n  <td class=xl65></td>\n </tr>\n <tr height=103 style='mso-height-source:userset;height:77.25pt'>\n  <td rowspan=9 height=387 class=xl74 width=122 style='height:291.85pt;\n  width:92pt'>运营部确认</td>\n  <td class=xl68 width=126 style='border-left:none;width:95pt'>工艺方案</td>\n  <td colspan=3 class=xl96 width=495 style='border-right:1.0pt solid black;\n  border-left:none;width:372pt'>" . project_db($id, '_4_19_4_t11') . "</td>\n  <td class=xl65></td>\n </tr>\n <tr height=33 style='mso-height-source:userset;height:24.95pt'>\n  <td height=33 class=xl70 width=126 style='height:24.95pt;border-top:none;\n  border-left:none;width:95pt'>结构图纸</td>\n  <td colspan=3 class=xl80 width=495 style='border-right:1.0pt solid black;\n  border-left:none;width:372pt'>" . project_db($id, '_4_19_4_t12') . "</td>\n  <td class=xl65></td>\n </tr>\n <tr height=33 style='mso-height-source:userset;height:24.95pt'>\n  <td height=33 class=xl70 width=126 style='height:24.95pt;border-top:none;\n  border-left:none;width:95pt'>预算</td>\n  <td colspan=3 class=xl80 width=495 style='border-right:1.0pt solid black;\n  border-left:none;width:372pt'>" . project_db($id, '_4_19_4_t13') . "</td>\n  <td class=xl65></td>\n </tr>\n <tr height=33 style='mso-height-source:userset;height:24.95pt'>\n  <td height=33 class=xl70 width=126 style='height:24.95pt;border-top:none;\n  border-left:none;width:95pt'>成本</td>\n  <td colspan=3 class=xl80 width=495 style='border-right:1.0pt solid black;\n  border-left:none;width:372pt'>" . project_db($id, '_4_19_4_t14') . "</td>\n  <td class=xl65></td>\n </tr>\n <tr height=33 style='mso-height-source:userset;height:24.95pt'>\n  <td height=33 class=xl70 width=126 style='height:24.95pt;border-top:none;\n  border-left:none;width:95pt'>报价</td>\n  <td colspan=3 class=xl80 width=495 style='border-right:1.0pt solid black;\n  border-left:none;width:372pt'>" . project_db($id, '_4_19_4_t15') . "</td>\n  <td class=xl65></td>\n </tr>\n <tr height=33 style='mso-height-source:userset;height:24.95pt'>\n  <td height=33 class=xl70 width=126 style='height:24.95pt;border-top:none;\n  border-left:none;width:95pt'>项目材料清单</td>\n  <td colspan=3 class=xl80 width=495 style='border-right:1.0pt solid black;\n  border-left:none;width:372pt'>" . project_db($id, '_4_19_4_t16') . "</td>\n  <td class=xl65></td>\n </tr>\n <tr height=33 style='mso-height-source:userset;height:24.95pt'>\n  <td height=33 class=xl70 width=126 style='height:24.95pt;border-top:none;\n  border-left:none;width:95pt'>填报人</td>\n  <td colspan=3 class=xl80 width=495 style='border-right:1.0pt solid black;\n  border-left:none;width:372pt'>" . project_db($id, '_4_19_4_t17') . "</td>\n  <td class=xl65></td>\n </tr>\n <tr height=33 style='mso-height-source:userset;height:24.95pt'>\n  <td height=33 class=xl70 width=126 style='height:24.95pt;border-top:none;\n  border-left:none;width:95pt'>审核人</td>\n  <td colspan=3 class=xl80 width=495 style='border-right:1.0pt solid black;\n  border-left:none;width:372pt'>" . project_db($id, '_4_19_4_t18') . "</td>\n  <td class=xl65></td>\n </tr>\n <tr height=53 style='mso-height-source:userset;height:39.95pt'>\n  <td height=53 class=xl77 width=126 style='height:39.95pt;border-top:none;\n  border-left:none;width:95pt'>审核意见</td>\n  <td colspan=3 class=xl97 width=495 style='border-right:1.0pt solid black;\n  border-left:none;width:372pt'>" . w_p_v(59, $id, 'lnstructions') . "</td>\n  <td class=xl65></td>\n </tr>\n <tr height=103 style='mso-height-source:userset;height:77.25pt'>\n  <td rowspan=5 height=325 class=xl74 width=122 style='border-bottom:1.0pt solid black;\n  height:244.35pt;width:92pt'>工程部确认</td>\n  <td class=xl68 width=126 style='border-left:none;width:95pt'>工艺确认</td>\n  <td colspan=3 class=xl96 width=495 style='border-right:1.0pt solid black;\n  border-left:none;width:372pt'>" . project_db($id, '_4_19_4_t21') . "</td>\n  <td class=xl65></td>\n </tr>\n <tr height=103 style='mso-height-source:userset;height:77.25pt'>\n  <td height=103 class=xl70 width=126 style='height:77.25pt;border-top:none;\n  border-left:none;width:95pt'>制作方案</td>\n  <td colspan=3 class=xl80 width=495 style='border-right:1.0pt solid black;\n  border-left:none;width:372pt'>" . project_db($id, '_4_19_4_t22') . "</td>\n  <td class=xl65></td>\n </tr>\n <tr height=33 style='mso-height-source:userset;height:24.95pt'>\n  <td height=33 class=xl70 width=126 style='height:24.95pt;border-top:none;\n  border-left:none;width:95pt'>填报人</td>\n  <td colspan=3 class=xl80 width=495 style='border-right:1.0pt solid black;\n  border-left:none;width:372pt'>" . project_db($id, '_4_19_4_t23') . "</td>\n  <td class=xl65></td>\n </tr>\n <tr height=33 style='mso-height-source:userset;height:24.95pt'>\n  <td height=33 class=xl70 width=126 style='height:24.95pt;border-top:none;\n  border-left:none;width:95pt'>审核人</td>\n  <td colspan=3 class=xl80 width=495 style='border-right:1.0pt solid black;\n  border-left:none;width:372pt'>" . project_db($id, '_4_19_4_t24') . "</td>\n  <td class=xl65></td>\n </tr>\n <tr height=53 style='mso-height-source:userset;height:39.95pt'>\n  <td height=53 class=xl79 width=126 style='height:39.95pt;border-top:none;\n  border-left:none;width:95pt'>审核意见</td>\n  <td colspan=3 class=xl100 width=495 style='border-right:1.0pt solid black;\n  border-left:none;width:372pt'>" . w_p_v(60, $id, 'lnstructions') . "</td>\n  <td class=xl65></td>\n </tr>\n <tr height=34 style='mso-height-source:userset;height:25.5pt'>\n  <td colspan=5 height=34 class=xl102 width=743 style='border-right:1.0pt solid black;\n  height:25.5pt;width:559pt'>副总确认：" . w_p_v(61, $id, 'name') . "</td>\n  <td class=xl65></td>\n </tr>\n <![if supportMisalignedColumns]>\n <tr height=0 style='display:none'>\n  <td width=122 style='width:92pt'></td>\n  <td width=126 style='width:95pt'></td>\n  <td width=126 style='width:95pt'></td>\n  <td width=122 style='width:92pt'></td>\n  <td width=247 style='width:185pt'></td>\n  <td width=305 style='width:229pt'></td>\n </tr>\n <![endif]>\n</table>\n\n</body>\n\n</html>\n\n\n";
    return $htmls;
}

コード例 #6

ファイルを表示

ファイル: 11_xiangmunxi_view.php プロジェクト: haogm123/ydoa

function xls_views($id, $uid, $title)
{
    $htmls .= '<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=Content-Type content="text/html; charset=utf-8">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 11">
<!--[if gte mso 9]><xml>
 <o:DocumentProperties>
  <o:Author>Windows 用户</o:Author>
  <o:LastAuthor>fdsfds</o:LastAuthor>
  <o:LastPrinted>2013-05-03T12:44:48Z</o:LastPrinted>
  <o:Created>2012-09-20T07:02:14Z</o:Created>
  <o:LastSaved>2013-05-06T07:08:00Z</o:LastSaved>
  <o:Company>Users</o:Company>
  <o:Version>11.9999</o:Version>
 </o:DocumentProperties>
</xml><![endif]-->
<style>
<!--table
	{mso-displayed-decimal-separator:"\\.";
	mso-displayed-thousand-separator:"\\,";}
@page
	{margin:.63in .7in .75in .41in;
	mso-header-margin:.3in;
	mso-footer-margin:.3in;}
.font10
	{color:black;
	font-size:12.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;}
.font11
	{color:black;
	font-size:11.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;}
tr
	{mso-height-source:auto;
	mso-ruby-visibility:none;}
col
	{mso-width-source:auto;
	mso-ruby-visibility:none;}
br
	{mso-data-placement:same-cell;}
.style0
	{mso-number-format:General;
	text-align:general;
	vertical-align:middle;
	white-space:nowrap;
	mso-rotate:0;
	mso-background-source:auto;
	mso-pattern:auto;
	color:black;
	font-size:11.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	border:none;
	mso-protection:locked visible;
	mso-style-name:常规;
	mso-style-id:0;}
td
	{mso-style-parent:style0;
	padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:black;
	font-size:11.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-number-format:General;
	text-align:general;
	vertical-align:middle;
	border:none;
	mso-background-source:auto;
	mso-pattern:auto;
	mso-protection:locked visible;
	white-space:nowrap;
	mso-rotate:0;}
.xl65
	{mso-style-parent:style0;
	font-family:"Times New Roman", serif;
	mso-font-charset:0;}
.xl66
	{mso-style-parent:style0;
	font-family:"Times New Roman", serif;
	mso-font-charset:0;
	text-align:center;
	border-top:1.0pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:1.0pt solid windowtext;
	white-space:normal;}
.xl67
	{mso-style-parent:style0;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:1.0pt solid windowtext;
	white-space:normal;}
.xl68
	{mso-style-parent:style0;
	font-family:"Times New Roman", serif;
	mso-font-charset:0;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:1.0pt solid windowtext;
	white-space:normal;}
.xl69
	{mso-style-parent:style0;
	font-family:"Times New Roman", serif;
	mso-font-charset:0;
	text-align:center;
	border:.5pt solid windowtext;
	white-space:normal;}
.xl70
	{mso-style-parent:style0;
	text-align:center;
	border:.5pt solid windowtext;
	white-space:normal;}
.xl71
	{mso-style-parent:style0;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:1.0pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl72
	{mso-style-parent:style0;
	font-size:12.0pt;
	mso-number-format:"_ * \\#\\,\\#\\#0\\.00_ \\;_ * \\-\\#\\,\\#\\#0\\.00_ \\;_ * \\0022-\\0022??_ \\;_ \\@_ ";
	text-align:center;
	border:.5pt solid windowtext;
	white-space:normal;}
.xl73
	{mso-style-parent:style0;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:1.0pt solid windowtext;
	border-left:1.0pt solid windowtext;
	white-space:normal;}
.xl74
	{mso-style-parent:style0;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:1.0pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl75
	{mso-style-parent:style0;
	font-size:12.0pt;
	font-family:"Times New Roman", serif;
	mso-font-charset:0;
	text-align:left;
	border:.5pt solid windowtext;
	white-space:normal;}
.xl76
	{mso-style-parent:style0;
	font-size:12.0pt;
	font-family:"Times New Roman", serif;
	mso-font-charset:0;
	mso-number-format:"_ * \\#\\,\\#\\#0\\.00_ \\;_ * \\-\\#\\,\\#\\#0\\.00_ \\;_ * \\0022-\\0022??_ \\;_ \\@_ ";
	text-align:left;
	border:.5pt solid windowtext;
	white-space:normal;}
.xl77
	{mso-style-parent:style0;
	font-size:12.0pt;
	font-family:"Times New Roman", serif;
	mso-font-charset:0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:1.0pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl78
	{mso-style-parent:style0;
	font-size:12.0pt;
	font-family:"Times New Roman", serif;
	mso-font-charset:0;
	mso-number-format:"_ * \\#\\,\\#\\#0\\.00_ \\;_ * \\-\\#\\,\\#\\#0\\.00_ \\;_ * \\0022-\\0022??_ \\;_ \\@_ ";
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:1.0pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl79
	{mso-style-parent:style0;
	font-family:"Times New Roman", serif;
	mso-font-charset:0;
	mso-number-format:"_ * \\#\\,\\#\\#0\\.00_ \\;_ * \\-\\#\\,\\#\\#0\\.00_ \\;_ * \\0022-\\0022??_ \\;_ \\@_ ";
	text-align:left;
	border:.5pt solid windowtext;
	white-space:normal;}
.xl80
	{mso-style-parent:style0;
	font-family:"Times New Roman", serif;
	mso-font-charset:0;
	mso-number-format:"_ * \\#\\,\\#\\#0\\.00_ \\;_ * \\-\\#\\,\\#\\#0\\.00_ \\;_ * \\0022-\\0022??_ \\;_ \\@_ ";
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:1.0pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl81
	{mso-style-parent:style0;
	font-family:"Times New Roman", serif;
	mso-font-charset:0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:1.0pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl82
	{mso-style-parent:style0;
	font-family:"Times New Roman", serif;
	mso-font-charset:0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:1.0pt solid windowtext;
	border-bottom:1.0pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl83
	{mso-style-parent:style0;
	font-size:12.0pt;
	font-family:"Times New Roman", serif;
	mso-font-charset:0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl84
	{mso-style-parent:style0;
	font-size:12.0pt;
	font-family:"Times New Roman", serif;
	mso-font-charset:0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	white-space:normal;}
.xl85
	{mso-style-parent:style0;
	font-size:12.0pt;
	font-family:"Times New Roman", serif;
	mso-font-charset:0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:1.0pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	white-space:normal;}
.xl86
	{mso-style-parent:style0;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:1.0pt solid windowtext;
	white-space:normal;}
.xl87
	{mso-style-parent:style0;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	white-space:normal;}
.xl88
	{mso-style-parent:style0;
	font-size:18.0pt;
	font-weight:700;
	text-align:center;
	white-space:normal;}
.xl89
	{mso-style-parent:style0;
	font-size:18.0pt;
	font-weight:700;
	font-family:"Times New Roman", serif;
	mso-font-charset:0;
	text-align:center;
	white-space:normal;}
.xl90
	{mso-style-parent:style0;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:1.0pt solid windowtext;
	background:silver;
	mso-pattern:auto none;
	white-space:normal;}
.xl91
	{mso-style-parent:style0;
	text-align:center;
	border:.5pt solid windowtext;
	background:silver;
	mso-pattern:auto none;
	white-space:normal;}
.xl92
	{mso-style-parent:style0;
	font-size:12.0pt;
	font-family:"Times New Roman", serif;
	mso-font-charset:0;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:1.0pt solid windowtext;
	background:silver;
	mso-pattern:auto none;
	white-space:normal;}
.xl93
	{mso-style-parent:style0;
	font-size:12.0pt;
	font-family:"Times New Roman", serif;
	mso-font-charset:0;
	text-align:center;
	border:.5pt solid windowtext;
	background:silver;
	mso-pattern:auto none;
	white-space:normal;}
.xl94
	{mso-style-parent:style0;
	font-size:12.0pt;
	font-family:"Times New Roman", serif;
	mso-font-charset:0;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:1.0pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	background:silver;
	mso-pattern:auto none;
	white-space:normal;}
.xl95
	{mso-style-parent:style0;
	font-size:12.0pt;
	font-family:"Times New Roman", serif;
	mso-font-charset:0;
	text-align:left;
	border-top:1.0pt solid windowtext;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl96
	{mso-style-parent:style0;
	font-size:12.0pt;
	font-family:"Times New Roman", serif;
	mso-font-charset:0;
	text-align:left;
	border-top:1.0pt solid windowtext;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	white-space:normal;}
.xl97
	{mso-style-parent:style0;
	font-size:12.0pt;
	font-family:"Times New Roman", serif;
	mso-font-charset:0;
	text-align:left;
	border-top:1.0pt solid windowtext;
	border-right:1.0pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	white-space:normal;}
ruby
	{ruby-align:left;}
rt
	{color:windowtext;
	font-size:9.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-char-type:none;
	display:none;}
-->
</style>
<!--[if gte mso 9]><xml>
 <x:ExcelWorkbook>
  <x:ExcelWorksheets>
   <x:ExcelWorksheet>
    <x:Name>Sheet1</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>300</x:DefaultRowHeight>
     <x:Print>
      <x:ValidPrinterInfo/>
      <x:PaperSizeIndex>9</x:PaperSizeIndex>
      <x:HorizontalResolution>600</x:HorizontalResolution>
      <x:VerticalResolution>600</x:VerticalResolution>
     </x:Print>
     <x:Selected/>
     <x:TopRowVisible>12</x:TopRowVisible>
     <x:Panes>
      <x:Pane>
       <x:Number>3</x:Number>
       <x:ActiveRow>29</x:ActiveRow>
       <x:ActiveCol>3</x:ActiveCol>
      </x:Pane>
     </x:Panes>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
   <x:ExcelWorksheet>
    <x:Name>Sheet2</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>270</x:DefaultRowHeight>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
   <x:ExcelWorksheet>
    <x:Name>Sheet3</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>270</x:DefaultRowHeight>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
  </x:ExcelWorksheets>
  <x:WindowHeight>4395</x:WindowHeight>
  <x:WindowWidth>15075</x:WindowWidth>
  <x:WindowTopX>0</x:WindowTopX>
  <x:WindowTopY>165</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=740 style='border-collapse:\n collapse;table-layout:fixed;width:556pt'>\n <col class=xl65 width=185 span=4 style='mso-width-source:userset;mso-width-alt:\n 5920;width:139pt'>\n <tr height=66 style='mso-height-source:userset;height:50.1pt'>\n  <td colspan=4 height=66 class=xl88 width=740 style='height:50.1pt;width:556pt'><span\n  style='mso-spacerun:yes'>&nbsp;</span>" . $title . "</td>\n </tr>\n <tr height=31 style='mso-height-source:userset;height:23.25pt'>\n  <td height=31 class=xl66 width=185 style='height:23.25pt;width:139pt'><font\n  class='font11'>客户名称</font></td>\n  <td colspan=3 class=xl95 width=555 style='border-right:1.0pt solid black;\n  border-left:none;width:417pt'>" . project_db($id, '_4_11_3_1') . "</td>\n </tr>\n <tr height=31 style='mso-height-source:userset;height:23.25pt'>\n  <td height=31 class=xl67 width=185 style='height:23.25pt;border-top:none;\n  width:139pt'>项目名称</td>\n  <td colspan=3 class=xl83 width=555 style='border-right:1.0pt solid black;\n  border-left:none;width:417pt'>" . project_db($id, '_4_11_3_2') . "</td>\n </tr>\n <tr height=31 style='mso-height-source:userset;height:23.25pt'>\n  <td height=31 class=xl67 width=185 style='height:23.25pt;border-top:none;\n  width:139pt'>项目内容</td>\n  <td colspan=3 class=xl83 width=555 style='border-right:1.0pt solid black;\n  border-left:none;width:417pt'>" . project_db($id, '_4_11_3_3') . "</td>\n </tr>\n <tr height=31 style='mso-height-source:userset;height:23.25pt'>\n  <td height=31 class=xl67 width=185 style='height:23.25pt;border-top:none;\n  width:139pt'>项目周期</td>\n  <td colspan=3 class=xl83 width=555 style='border-right:1.0pt solid black;\n  border-left:none;width:417pt'>" . project_db($id, '_4_11_3_4') . "</td>\n </tr>\n <tr height=31 style='mso-height-source:userset;height:23.25pt'>\n  <td height=31 class=xl67 width=185 style='height:23.25pt;border-top:none;\n  width:139pt'>项目地点</td>\n  <td colspan=3 class=xl83 width=555 style='border-right:1.0pt solid black;\n  border-left:none;width:417pt'>" . project_db($id, '_4_11_3_5') . "</td>\n </tr>\n <tr height=31 style='mso-height-source:userset;height:23.25pt'>\n  <td height=31 class=xl68 width=185 style='height:23.25pt;border-top:none;\n  width:139pt'><font class='font11'>合同编号</font></td>\n  <td class=xl75 width=185 style='border-top:none;border-left:none;width:139pt'>" . project_db($id, '_4_11_3_6') . "</td>\n  <td class=xl69 width=185 style='border-top:none;border-left:none;width:139pt'><font\n  class='font11'>工单号</font></td>\n  <td class=xl77 width=185 style='border-top:none;border-left:none;width:139pt'>" . project_db($id, '_4_11_3_7') . "</td>\n </tr>\n <tr height=31 style='mso-height-source:userset;height:23.25pt'>\n  <td height=31 class=xl68 width=185 style='height:23.25pt;border-top:none;\n  width:139pt'><font class='font11'>签订合同金额</font></td>\n  <td class=xl76 width=185 style='border-top:none;border-left:none;width:139pt'>" . project_db($id, '_4_11_3_8') . "</td>\n  <td class=xl70 width=185 style='border-top:none;border-left:none;width:139pt'>增/减项后实际合同金额</td>\n  <td class=xl78 width=185 style='border-top:none;border-left:none;width:139pt'>" . project_db($id, '_4_11_3_9') . "</td>\n </tr>\n <tr height=31 style='mso-height-source:userset;height:23.25pt'>\n  <td height=31 class=xl68 width=185 style='height:23.25pt;border-top:none;\n  width:139pt'><font class='font11'>预算成本</font></td>\n  <td class=xl76 width=185 style='border-top:none;border-left:none;width:139pt'>" . project_db($id, '_4_11_3_10') . "</td>\n  <td class=xl70 width=185 style='border-top:none;border-left:none;width:139pt'>实际成本</td>\n  <td class=xl78 width=185 style='border-top:none;border-left:none;width:139pt'>" . project_db($id, '_4_11_3_11') . "</td>\n </tr>\n <tr height=31 style='mso-height-source:userset;height:23.25pt'>\n  <td colspan=4 height=31 class=xl92 width=740 style='border-right:1.0pt solid black;\n  height:23.25pt;width:556pt'><font class='font10'>实际成本明细</font></td>\n </tr>\n <tr height=31 style='mso-height-source:userset;height:23.25pt'>\n  <td colspan=2 height=31 class=xl86 width=370 style='border-right:.5pt solid black;\n  height:23.25pt;width:278pt'>成本明细</td>\n  <td class=xl70 width=185 style='border-top:none;border-left:none;width:139pt'>金额</td>\n  <td class=xl71 width=185 style='border-top:none;border-left:none;width:139pt'>所占比例</td>\n </tr>";
    $a1 = unserialize(project_db($id, '_4_11_3_a1'));
    $a2 = unserialize(project_db($id, '_4_11_3_a2'));
    $htmls .= "<tr height=31 style='mso-height-source:userset;height:23.25pt'>\n  <td rowspan=14 height=434 class=xl67 width=185 style='height:325.5pt;\n  border-top:none;width:139pt'>直接成本</td>\n  <td class=xl70 width=185 style='border-top:none;border-left:none;width:139pt'>材料费（本地）</td>\n  <td class=xl76 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a1[0] . "</td>\n  <td class=xl78 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a2[0] . "</td>\n </tr>\n <tr height=31 style='mso-height-source:userset;height:23.25pt'>\n  <td height=31 class=xl70 width=185 style='height:23.25pt;border-top:none;\n  border-left:none;width:139pt'>材料费（外埠采购）</td>\n  <td class=xl76 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a1[1] . "</td>\n  <td class=xl78 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a2[1] . "</td>\n </tr>\n <tr height=31 style='mso-height-source:userset;height:23.25pt'>\n  <td height=31 class=xl70 width=185 style='height:23.25pt;border-top:none;\n  border-left:none;width:139pt'>外包费</td>\n  <td class=xl76 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a1[2] . "</td>\n  <td class=xl78 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a2[2] . "</td>\n </tr>\n <tr height=31 style='mso-height-source:userset;height:23.25pt'>\n  <td height=31 class=xl70 width=185 style='height:23.25pt;border-top:none;\n  border-left:none;width:139pt'>人工费（自有）</td>\n  <td class=xl76 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a1[3] . "</td>\n  <td class=xl78 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a2[3] . "</td>\n </tr>\n <tr height=31 style='mso-height-source:userset;height:23.25pt'>\n  <td height=31 class=xl70 width=185 style='height:23.25pt;border-top:none;\n  border-left:none;width:139pt'>人工费（外请）</td>\n  <td class=xl76 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a1[4] . "</td>\n  <td class=xl78 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a2[4] . "</td>\n </tr>\n <tr height=31 style='mso-height-source:userset;height:23.25pt'>\n  <td height=31 class=xl70 width=185 style='height:23.25pt;border-top:none;\n  border-left:none;width:139pt'>外加工</td>\n  <td class=xl76 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a1[5] . "</td>\n  <td class=xl78 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a2[5] . "</td>\n </tr>\n <tr height=31 style='mso-height-source:userset;height:23.25pt'>\n  <td height=31 class=xl70 width=185 style='height:23.25pt;border-top:none;\n  border-left:none;width:139pt'>吊装费</td>\n  <td class=xl76 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a1[6] . "</td>\n  <td class=xl78 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a2[6] . "</td>\n </tr>\n <tr height=31 style='mso-height-source:userset;height:23.25pt'>\n  <td height=31 class=xl70 width=185 style='height:23.25pt;border-top:none;\n  border-left:none;width:139pt'>运费</td>\n  <td class=xl76 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a1[7] . "</td>\n  <td class=xl78 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a2[7] . "</td>\n </tr>\n <tr height=31 style='mso-height-source:userset;height:23.25pt'>\n  <td height=31 class=xl70 width=185 style='height:23.25pt;border-top:none;\n  border-left:none;width:139pt'>租赁费</td>\n  <td class=xl76 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a1[8] . "</td>\n  <td class=xl78 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a2[8] . "</td>\n </tr>\n <tr height=31 style='mso-height-source:userset;height:23.25pt'>\n  <td height=31 class=xl70 width=185 style='height:23.25pt;border-top:none;\n  border-left:none;width:139pt'>电费</td>\n  <td class=xl76 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a1[9] . "</td>\n  <td class=xl78 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a2[9] . "</td>\n </tr>\n <tr height=31 style='mso-height-source:userset;height:23.25pt'>\n  <td height=31 class=xl70 width=185 style='height:23.25pt;border-top:none;\n  border-left:none;width:139pt'>占地费</td>\n  <td class=xl76 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a1[10] . "</td>\n  <td class=xl78 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a2[10] . "</td>\n </tr>\n <tr height=31 style='mso-height-source:userset;height:23.25pt'>\n  <td height=31 class=xl70 width=185 style='height:23.25pt;border-top:none;\n  border-left:none;width:139pt'>审批费</td>\n  <td class=xl76 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a1[11] . "</td>\n  <td class=xl78 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a2[11] . "</td>\n </tr>\n <tr height=31 style='mso-height-source:userset;height:23.25pt'>\n  <td height=31 class=xl70 width=185 style='height:23.25pt;border-top:none;\n  border-left:none;width:139pt'>设计费</td>\n  <td class=xl76 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a1[12] . "</td>\n  <td class=xl78 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a2[12] . "</td>\n </tr>\n <tr height=31 style='mso-height-source:userset;height:23.25pt'>\n  <td height=31 class=xl70 width=185 style='height:23.25pt;border-top:none;\n  border-left:none;width:139pt'>税金</td>\n  <td class=xl76 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a1[13] . "</td>\n  <td class=xl78 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a2[13] . "</td>\n </tr>\n <tr height=31 style='mso-height-source:userset;height:23.25pt'>\n  <td rowspan=4 height=124 class=xl67 width=185 style='height:93.0pt;\n  border-top:none;width:139pt'>间接成本</td>\n  <td class=xl72 width=185 style='border-top:none;border-left:none;width:139pt'\n  ><span style='mso-spacerun:yes'>&nbsp;</span>差旅费<span\n  style='mso-spacerun:yes'>&nbsp;</span></td>\n  <td class=xl76 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a1[14] . "</td>\n  <td class=xl78 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a2[14] . "</td>\n </tr>\n <tr height=31 style='mso-height-source:userset;height:23.25pt'>\n  <td height=31 class=xl72 width=185 style='height:23.25pt;border-top:none;\n  border-left:none;width:139pt' ><span\n  style='mso-spacerun:yes'>&nbsp;</span>业务招待费<span\n  style='mso-spacerun:yes'>&nbsp;</span></td>\n  <td class=xl76 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a1[15] . "</td>\n  <td class=xl78 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a2[15] . "</td>\n </tr>\n <tr height=31 style='mso-height-source:userset;height:23.25pt'>\n  <td height=31 class=xl72 width=185 style='height:23.25pt;border-top:none;\n  border-left:none;width:139pt' ><span\n  style='mso-spacerun:yes'>&nbsp;</span>罚金<span\n  style='mso-spacerun:yes'>&nbsp;</span></td>\n  <td class=xl76 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a1[16] . "</td>\n  <td class=xl78 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a2[16] . "</td>\n </tr>\n <tr height=31 style='mso-height-source:userset;height:23.25pt'>\n  <td height=31 class=xl72 width=185 style='height:23.25pt;border-top:none;\n  border-left:none;width:139pt' ><span\n  style='mso-spacerun:yes'>&nbsp;</span>其他<span\n  style='mso-spacerun:yes'>&nbsp;</span></td>\n  <td class=xl76 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a1[17] . "</td>\n  <td class=xl78 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a2[17] . "</td>\n </tr>\n <tr height=31 style='mso-height-source:userset;height:23.25pt'>\n  <td colspan=2 height=31 class=xl90 width=370 style='height:23.25pt;\n  width:278pt'>合计</td>\n  <td class=xl76 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a1[18] . "</td>\n  <td class=xl78 width=185 style='border-top:none;border-left:none;width:139pt'>" . $a2[18] . "</td>\n </tr>\n <tr height=31 style='mso-height-source:userset;height:23.25pt'>\n  <td height=31 class=xl73 width=185 style='height:23.25pt;border-top:none;\n  width:139pt'>填报人</td>\n  <td class=xl81 width=185 style='border-top:none;border-left:none;width:139pt'>" . project_db($id, '_4_11_3_12') . "</td>\n  <td class=xl74 width=185 style='border-top:none;border-left:none;width:139pt'>审核人</td>\n  <td class=xl82 width=185 style='border-top:none;border-left:none;width:139pt'>" . w_p_v(35, $id, 'name') . "</td>\n </tr>\n <tr height=30 style='mso-height-source:userset;height:22.5pt'>\n  <td height=30 colspan=4 class=xl65 style='height:22.5pt;mso-ignore:colspan'></td>\n </tr>\n <tr height=30 style='mso-height-source:userset;height:22.5pt'>\n  <td height=30 colspan=4 class=xl65 style='height:22.5pt;mso-ignore:colspan'></td>\n </tr>\n <tr height=30 style='mso-height-source:userset;height:22.5pt'>\n  <td height=30 colspan=4 class=xl65 style='height:22.5pt;mso-ignore:colspan'></td>\n </tr>\n <tr height=30 style='mso-height-source:userset;height:22.5pt'>\n  <td height=30 colspan=4 class=xl65 style='height:22.5pt;mso-ignore:colspan'></td>\n </tr>\n <tr height=30 style='mso-height-source:userset;height:22.5pt'>\n  <td height=30 colspan=4 class=xl65 style='height:22.5pt;mso-ignore:colspan'></td>\n </tr>\n <![if supportMisalignedColumns]>\n <tr height=0 style='display:none'>\n  <td width=185 style='width:139pt'></td>\n  <td width=185 style='width:139pt'></td>\n  <td width=185 style='width:139pt'></td>\n  <td width=185 style='width:139pt'></td>\n </tr>\n <![endif]>\n</table>\n\n</body>\n\n</html>\n\n";
    return $htmls;
}

コード例 #7

ファイルを表示

ファイル: 9_shejigongdanjifankui_view.php プロジェクト: haogm123/ydoa

function xls_views($id, $uid, $title)
{
    $htmls .= '<html xmlns:v="urn:schemas-microsoft-com:vml"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=Content-Type content="text/html; charset=utf-8">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 11">
<!--[if gte mso 9]><xml>
 <o:DocumentProperties>
  <o:Created>2006-09-13T11:21:51Z</o:Created>
  <o:LastSaved>2013-05-06T06:21:02Z</o:LastSaved>
  <o:Version>11.9999</o:Version>
 </o:DocumentProperties>
 <o:OfficeDocumentSettings>
  <o:RemovePersonalInformation/>
 </o:OfficeDocumentSettings>
</xml><![endif]-->
<style>
<!--table
	{mso-displayed-decimal-separator:"\\.";
	mso-displayed-thousand-separator:"\\,";}
@page
	{margin:.75in .7in .75in .7in;
	mso-header-margin:.3in;
	mso-footer-margin:.3in;}
tr
	{mso-height-source:auto;
	mso-ruby-visibility:none;}
col
	{mso-width-source:auto;
	mso-ruby-visibility:none;}
br
	{mso-data-placement:same-cell;}
.style0
	{mso-number-format:General;
	text-align:general;
	vertical-align:middle;
	white-space:nowrap;
	mso-rotate:0;
	mso-background-source:auto;
	mso-pattern:auto;
	color:black;
	font-size:11.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	border:none;
	mso-protection:locked visible;
	mso-style-name:常规;
	mso-style-id:0;}
td
	{mso-style-parent:style0;
	padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:black;
	font-size:11.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-number-format:General;
	text-align:general;
	vertical-align:middle;
	border:none;
	mso-background-source:auto;
	mso-pattern:auto;
	mso-protection:locked visible;
	white-space:nowrap;
	mso-rotate:0;}
.xl65
	{mso-style-parent:style0;
	font-size:14.0pt;
	font-weight:700;
	text-align:center;
	white-space:normal;}
.xl66
	{mso-style-parent:style0;
	text-align:center;
	border:.5pt solid windowtext;
	white-space:normal;}
.xl67
	{mso-style-parent:style0;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl68
	{mso-style-parent:style0;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:none;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl69
	{mso-style-parent:style0;
	text-align:center;
	border-top:none;
	border-right:none;
	border-bottom:none;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl70
	{mso-style-parent:style0;
	text-align:center;
	border-top:none;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl71
	{mso-style-parent:style0;
	font-weight:700;
	text-align:center;
	border:.5pt solid windowtext;
	background:silver;
	mso-pattern:auto none;
	white-space:normal;}
.xl72
	{mso-style-parent:style0;
	text-align:left;
	white-space:normal;}
.xl73
	{mso-style-parent:style0;
	text-align:left;
	border:.5pt solid windowtext;
	white-space:normal;}
.xl74
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl75
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	white-space:normal;}
.xl76
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	white-space:normal;}
.xl77
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:none;
	border-left:none;
	white-space:normal;}
.xl78
	{mso-style-parent:style0;
	text-align:left;
	border-top:none;
	border-right:.5pt solid windowtext;
	border-bottom:none;
	border-left:none;
	white-space:normal;}
.xl79
	{mso-style-parent:style0;
	text-align:left;
	border-top:none;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	white-space:normal;}
ruby
	{ruby-align:left;}
rt
	{color:windowtext;
	font-size:9.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-char-type:none;
	display:none;}
-->
</style>
<!--[if gte mso 9]><xml>
 <x:ExcelWorkbook>
  <x:ExcelWorksheets>
   <x:ExcelWorksheet>
    <x:Name>Sheet1</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>559</x:DefaultRowHeight>
     <x:Unsynced/>
     <x:Print>
      <x:ValidPrinterInfo/>
      <x:PaperSizeIndex>9</x:PaperSizeIndex>
      <x:HorizontalResolution>200</x:HorizontalResolution>
      <x:VerticalResolution>200</x:VerticalResolution>
     </x:Print>
     <x:Selected/>
     <x:TopRowVisible>9</x:TopRowVisible>
     <x:Panes>
      <x:Pane>
       <x:Number>3</x:Number>
       <x:ActiveRow>16</x:ActiveRow>
       <x:ActiveCol>1</x:ActiveCol>
       <x:RangeSelection>$B$17:$D$17</x:RangeSelection>
      </x:Pane>
     </x:Panes>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
   <x:ExcelWorksheet>
    <x:Name>Sheet2</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>270</x:DefaultRowHeight>
     <x:Print>
      <x:ValidPrinterInfo/>
      <x:PaperSizeIndex>9</x:PaperSizeIndex>
      <x:HorizontalResolution>200</x:HorizontalResolution>
      <x:VerticalResolution>200</x:VerticalResolution>
     </x:Print>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
   <x:ExcelWorksheet>
    <x:Name>Sheet3</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>270</x:DefaultRowHeight>
     <x:Print>
      <x:ValidPrinterInfo/>
      <x:PaperSizeIndex>9</x:PaperSizeIndex>
      <x:HorizontalResolution>200</x:HorizontalResolution>
      <x:VerticalResolution>200</x:VerticalResolution>
     </x:Print>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
  </x:ExcelWorksheets>
  <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]--><!--[if gte mso 9]><xml>
 <o:shapedefaults v:ext="edit" spidmax="2049"/>
</xml><![endif]-->
</head>

<body link=blue vlink=purple>';
    $htmls .= "<table x:str border=0 cellpadding=0 cellspacing=0 width=710 style='border-collapse:\n collapse;table-layout:fixed;width:532pt'>\n <col width=135 style='mso-width-source:userset;mso-width-alt:4320;width:101pt'>\n <col width=220 style='mso-width-source:userset;mso-width-alt:7040;width:165pt'>\n <col width=135 style='mso-width-source:userset;mso-width-alt:4320;width:101pt'>\n <col width=220 style='mso-width-source:userset;mso-width-alt:7040;width:165pt'>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td colspan=2 height=37 class=xl72 width=355 style='height:27.95pt;\n  width:266pt'>公司：" . project_db($id, '_4_9_3_1') . "</td>\n  <td colspan=2 class=xl72 width=355 style='width:266pt'>No.:" . project_db($id, '_4_9_3_2') . "</td>\n </tr>\n <tr height=66 style='mso-height-source:userset;height:50.1pt'>\n  <td colspan=4 height=66 class=xl65 width=710 style='height:50.1pt;width:532pt'>" . $title . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl66 width=135 style='height:27.95pt;width:101pt'>日<span\n  style='mso-spacerun:yes'>&nbsp;&nbsp;&nbsp; </span>期</td>\n  <td class=xl73 width=220 style='border-left:none;width:165pt'>" . project_db($id, '_4_9_3_3') . "</td>\n  <td class=xl66 width=135 style='border-left:none;width:101pt'>完成日期</td>\n  <td class=xl73 width=220 style='border-left:none;width:165pt'>" . project_db($id, '_4_9_3_4') . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl66 width=135 style='height:27.95pt;border-top:none;\n  width:101pt'>责 任 人</td>\n  <td class=xl73 width=220 style='border-top:none;border-left:none;width:165pt'>" . project_db($id, '_4_9_3_5') . "</td>\n  <td class=xl66 width=135 style='border-top:none;border-left:none;width:101pt'>责任部门</td>\n  <td class=xl73 width=220 style='border-top:none;border-left:none;width:165pt'>" . project_db($id, '_4_9_3_6') . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl66 width=135 style='height:27.95pt;border-top:none;\n  width:101pt'>客户名称</td>\n  <td colspan=3 class=xl74 width=575 style='border-right:.5pt solid black;\n  border-left:none;width:431pt'>" . project_db($id, '_4_9_3_7') . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl66 width=135 style='height:27.95pt;border-top:none;\n  width:101pt'>项目名称</td>\n  <td colspan=3 class=xl74 width=575 style='border-right:.5pt solid black;\n  border-left:none;width:431pt'>" . project_db($id, '_4_9_3_8') . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl66 width=135 style='height:27.95pt;border-top:none;\n  width:101pt'>主要内容</td>\n  <td colspan=3 class=xl74 width=575 style='border-right:.5pt solid black;\n  border-left:none;width:431pt'>" . project_db($id, '_4_9_3_9') . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl66 width=135 style='height:27.95pt;border-top:none;\n  width:101pt'>尺<span style='mso-spacerun:yes'>&nbsp;&nbsp;&nbsp; </span>寸</td>\n  <td class=xl73 width=220 style='border-top:none;border-left:none;width:165pt'>" . project_db($id, '_4_9_3_10') . "</td>\n  <td class=xl66 width=135 style='border-top:none;border-left:none;width:101pt'>位<span\n  style='mso-spacerun:yes'>&nbsp;&nbsp;&nbsp; </span>置</td>\n  <td class=xl73 width=220 style='border-top:none;border-left:none;width:165pt'>" . project_db($id, '_4_9_3_11') . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl66 width=135 style='height:27.95pt;border-top:none;\n  width:101pt'>材<span style='mso-spacerun:yes'>&nbsp;&nbsp;&nbsp; </span>质</td>\n  <td class=xl73 width=220 style='border-top:none;border-left:none;width:165pt'>" . project_db($id, '_4_9_3_12') . "</td>\n  <td class=xl66 width=135 style='border-top:none;border-left:none;width:101pt'>光<span\n  style='mso-spacerun:yes'>&nbsp;&nbsp;&nbsp; </span>源</td>\n  <td class=xl73 width=220 style='border-top:none;border-left:none;width:165pt'>" . project_db($id, '_4_9_3_13') . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl66 width=135 style='height:27.95pt;border-top:none;\n  width:101pt'>提供材料</td>\n  <td colspan=3 class=xl74 width=575 style='border-right:.5pt solid black;\n  border-left:none;width:431pt'>" . project_db($id, '_4_9_3_14') . "</td>\n </tr>\n <tr height=100 style='mso-height-source:userset;height:75.0pt'>\n  <td height=100 class=xl66 width=135 style='height:75.0pt;border-top:none;\n  width:101pt'>设计要求</td>\n  <td colspan=3 class=xl74 width=575 style='border-right:.5pt solid black;\n  border-left:none;width:431pt'>" . project_db($id, '_4_9_3_15') . "</td>\n </tr>\n <tr height=80 style='mso-height-source:userset;height:60.0pt'>\n  <td height=80 class=xl66 width=135 style='height:60.0pt;border-top:none;\n  width:101pt'>要点备注</td>\n  <td colspan=3 class=xl74 width=575 style='border-right:.5pt solid black;\n  border-left:none;width:431pt'>" . project_db($id, '_4_9_3_16') . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl67 width=135 style='height:27.95pt;border-top:none;\n  width:101pt'><span style='mso-spacerun:yes'>&nbsp; </span>设计图打印</td>\n  <td class=xl76 width=220 style='border-top:none;width:165pt'>" . project_db($id, '_4_9_3_17') . "</td>\n  <td class=xl68 width=135 style='border-top:none;border-left:none;width:101pt'>打印纸质要求:</td>\n  <td class=xl77 width=220 style='border-top:none;width:165pt'>复印纸<span\n  style='mso-spacerun:yes'>" . project_db($id, '_4_9_3_18') . "\n  </span>份</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl68 width=135 style='height:27.95pt;border-top:none;\n  width:101pt'>打印纸开要求:</td>\n  <td class=xl77 width=220 style='border-top:none;width:165pt'>" . project_db($id, '_4_9_3_19') . "</td>\n  <td class=xl69 width=135 style='border-left:none;width:101pt'>　</td>\n  <td class=xl78 width=220 style='width:165pt'>打印纸<span\n  style='mso-spacerun:yes'>" . project_db($id, '_4_9_3_20') . "\n  </span>份</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl69 width=135 style='height:27.95pt;width:101pt'>　</td>\n  <td class=xl78 width=220 style='width:165pt'>　</td>\n  <td class=xl69 width=135 style='border-left:none;width:101pt'>　</td>\n  <td class=xl78 width=220 style='width:165pt'>照片纸<span\n  style='mso-spacerun:yes'>" . project_db($id, '_4_9_3_21') . "\n  </span>份</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl70 width=135 style='height:27.95pt;width:101pt'><span\n  style='mso-spacerun:yes'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>其他:</td>\n  <td class=xl79 width=220 style='width:165pt'>" . project_db($id, '_4_9_3_22') . "</td>\n  <td class=xl70 width=135 style='border-left:none;width:101pt'>　</td>\n  <td class=xl79 width=220 style='width:165pt'>特种纸<span\n  style='mso-spacerun:yes'>" . project_db($id, '_4_9_3_23') . "\n  </span>份</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl66 width=135 style='height:27.95pt;border-top:none;\n  width:101pt'>部门负责人审批</td>\n  <td colspan=3 class=xl73 width=575 style='border-left:none;width:431pt'>" . w_p_v(32, $id, 'name') . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl66 width=135 style='height:27.95pt;border-top:none;\n  width:101pt'>设计负责人接收</td>\n  <td colspan=3 class=xl73 width=575 style='border-left:none;width:431pt'>" . w_p_v(33, $id, 'name') . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td colspan=4 height=37 class=xl71 width=710 style='height:27.95pt;\n  width:532pt'>设计反馈</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl66 width=135 style='height:27.95pt;border-top:none;\n  width:101pt'>任务分配设计人员</td>\n  <td colspan=3 class=xl73 width=575 style='border-left:none;width:431pt'>" . project_db($id, '_4_9_4_t1') . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl66 width=135 style='height:27.95pt;border-top:none;\n  width:101pt'>方案</td>\n  <td colspan=3 class=xl73 width=575 style='border-left:none;width:431pt'>" . project_db($id, '_4_9_4_t2') . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl66 width=135 style='height:27.95pt;border-top:none;\n  width:101pt'>效果图</td>\n  <td colspan=3 class=xl73 width=575 style='border-left:none;width:431pt'>" . project_db($id, '_4_9_4_t3') . "</td>\n </tr>\n <![if supportMisalignedColumns]>\n <tr height=0 style='display:none'>\n  <td width=135 style='width:101pt'></td>\n  <td width=220 style='width:165pt'></td>\n  <td width=135 style='width:101pt'></td>\n  <td width=220 style='width:165pt'></td>\n </tr>\n <![endif]>\n</table>\n\n</body>\n\n</html>\n\n";
    return $htmls;
}

コード例 #8

ファイルを表示

ファイル: 15_angyanshou_view.php プロジェクト: haogm123/ydoa

function xls_views($id, $uid, $title)
{
    $htmls .= '<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=Content-Type content="text/html; charset=utf-8">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 11">
<!--[if gte mso 9]><xml>
 <o:DocumentProperties>
  <o:Created>2006-09-13T11:21:51Z</o:Created>
  <o:LastSaved>2013-05-06T09:07:33Z</o:LastSaved>
  <o:Version>11.9999</o:Version>
 </o:DocumentProperties>
 <o:OfficeDocumentSettings>
  <o:RemovePersonalInformation/>
 </o:OfficeDocumentSettings>
</xml><![endif]-->
<style>
<!--table
	{mso-displayed-decimal-separator:"\\.";
	mso-displayed-thousand-separator:"\\,";}
@page
	{margin:.75in .7in .75in .7in;
	mso-header-margin:.3in;
	mso-footer-margin:.3in;}
.font9
	{color:black;
	font-size:11.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;}
.font10
	{color:black;
	font-size:12.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:"Times New Roman", serif;
	mso-font-charset:0;}
.font11
	{color:black;
	font-size:12.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;}
tr
	{mso-height-source:auto;
	mso-ruby-visibility:none;}
col
	{mso-width-source:auto;
	mso-ruby-visibility:none;}
br
	{mso-data-placement:same-cell;}
.style0
	{mso-number-format:General;
	text-align:general;
	vertical-align:middle;
	white-space:nowrap;
	mso-rotate:0;
	mso-background-source:auto;
	mso-pattern:auto;
	color:black;
	font-size:11.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	border:none;
	mso-protection:locked visible;
	mso-style-name:常规;
	mso-style-id:0;}
td
	{mso-style-parent:style0;
	padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:black;
	font-size:11.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-number-format:General;
	text-align:general;
	vertical-align:middle;
	border:none;
	mso-background-source:auto;
	mso-pattern:auto;
	mso-protection:locked visible;
	white-space:nowrap;
	mso-rotate:0;}
.xl65
	{mso-style-parent:style0;
	font-family:"Times New Roman", serif;
	mso-font-charset:0;
	text-align:center;}
.xl66
	{mso-style-parent:style0;
	text-align:center;}
.xl67
	{mso-style-parent:style0;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:1.0pt solid windowtext;
	white-space:normal;}
.xl68
	{mso-style-parent:style0;
	text-align:center;
	border-top:1.0pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:1.0pt solid windowtext;
	white-space:normal;}
.xl69
	{mso-style-parent:style0;
	font-family:"Times New Roman", serif;
	mso-font-charset:0;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:1.0pt solid windowtext;
	white-space:normal;}
.xl70
	{mso-style-parent:style0;
	font-family:"Times New Roman", serif;
	mso-font-charset:0;
	text-align:center;
	border:.5pt solid windowtext;
	white-space:normal;}
.xl71
	{mso-style-parent:style0;
	font-size:12.0pt;
	text-align:center;
	border:.5pt solid windowtext;
	white-space:normal;}
.xl72
	{mso-style-parent:style0;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:1.0pt solid windowtext;
	border-left:1.0pt solid windowtext;
	white-space:normal;}
.xl73
	{mso-style-parent:style0;
	font-size:12.0pt;
	font-family:"Times New Roman", serif;
	mso-font-charset:0;
	text-align:left;
	border:.5pt solid windowtext;
	white-space:normal;}
.xl74
	{mso-style-parent:style0;
	font-size:12.0pt;
	font-family:"Times New Roman", serif;
	mso-font-charset:0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:1.0pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl75
	{mso-style-parent:style0;
	font-size:12.0pt;
	text-align:left;
	border:.5pt solid windowtext;
	white-space:normal;}
.xl76
	{mso-style-parent:style0;
	font-size:12.0pt;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:1.0pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl77
	{mso-style-parent:style0;
	font-size:18.0pt;
	font-weight:700;
	text-align:center;
	white-space:normal;}
.xl78
	{mso-style-parent:style0;
	font-size:18.0pt;
	font-weight:700;
	font-family:"Times New Roman", serif;
	mso-font-charset:0;
	text-align:center;
	white-space:normal;}
.xl79
	{mso-style-parent:style0;
	font-size:12.0pt;
	font-family:"Times New Roman", serif;
	mso-font-charset:0;
	text-align:left;
	border-top:1.0pt solid windowtext;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl80
	{mso-style-parent:style0;
	font-size:12.0pt;
	font-family:"Times New Roman", serif;
	mso-font-charset:0;
	text-align:left;
	border-top:1.0pt solid windowtext;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	white-space:normal;}
.xl81
	{mso-style-parent:style0;
	font-size:12.0pt;
	font-family:"Times New Roman", serif;
	mso-font-charset:0;
	text-align:left;
	border-top:1.0pt solid windowtext;
	border-right:1.0pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	white-space:normal;}
.xl82
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:1.0pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl83
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:1.0pt solid windowtext;
	border-left:none;
	white-space:normal;}
.xl84
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:1.0pt solid windowtext;
	border-bottom:1.0pt solid windowtext;
	border-left:none;
	white-space:normal;}
.xl85
	{mso-style-parent:style0;
	font-size:12.0pt;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl86
	{mso-style-parent:style0;
	font-size:12.0pt;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	white-space:normal;}
.xl87
	{mso-style-parent:style0;
	font-size:12.0pt;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:1.0pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	white-space:normal;}
ruby
	{ruby-align:left;}
rt
	{color:windowtext;
	font-size:9.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-char-type:none;
	display:none;}
-->
</style>
<!--[if gte mso 9]><xml>
 <x:ExcelWorkbook>
  <x:ExcelWorksheets>
   <x:ExcelWorksheet>
    <x:Name>Sheet1</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>270</x:DefaultRowHeight>
     <x:Print>
      <x:ValidPrinterInfo/>
      <x:PaperSizeIndex>9</x:PaperSizeIndex>
      <x:HorizontalResolution>200</x:HorizontalResolution>
      <x:VerticalResolution>200</x:VerticalResolution>
     </x:Print>
     <x:Selected/>
     <x:TopRowVisible>6</x:TopRowVisible>
     <x:Panes>
      <x:Pane>
       <x:Number>3</x:Number>
       <x:ActiveRow>11</x:ActiveRow>
       <x:ActiveCol>2</x:ActiveCol>
      </x:Pane>
     </x:Panes>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
   <x:ExcelWorksheet>
    <x:Name>Sheet2</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>270</x:DefaultRowHeight>
     <x:Print>
      <x:ValidPrinterInfo/>
      <x:PaperSizeIndex>9</x:PaperSizeIndex>
      <x:HorizontalResolution>200</x:HorizontalResolution>
      <x:VerticalResolution>200</x:VerticalResolution>
     </x:Print>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
   <x:ExcelWorksheet>
    <x:Name>Sheet3</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>270</x:DefaultRowHeight>
     <x:Print>
      <x:ValidPrinterInfo/>
      <x:PaperSizeIndex>9</x:PaperSizeIndex>
      <x:HorizontalResolution>200</x:HorizontalResolution>
      <x:VerticalResolution>200</x:VerticalResolution>
     </x:Print>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
  </x:ExcelWorksheets>
  <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=xl66>';
    $htmls .= "<table x:str border=0 cellpadding=0 cellspacing=0 width=696 style='border-collapse:\n collapse;table-layout:fixed;width:524pt'>\n <col class=xl66 width=174 span=4 style='mso-width-source:userset;mso-width-alt:\n 5568;width:131pt'>\n <tr class=xl65 height=64 style='mso-height-source:userset;height:48.0pt'>\n  <td colspan=4 height=64 class=xl77 width=696 style='height:48.0pt;width:524pt'>" . $title . "</td>\n </tr>\n <tr class=xl65 height=44 style='mso-height-source:userset;height:33.0pt'>\n  <td height=44 class=xl68 width=174 style='height:33.0pt;width:131pt'>项目名称</td>\n  <td colspan=3 class=xl79 width=522 style='border-right:1.0pt solid black;\n  border-left:none;width:393pt'>" . project_db($id, '_4_15_3_1') . "</td>\n </tr>\n <tr class=xl65 height=44 style='mso-height-source:userset;height:33.0pt'>\n  <td height=44 class=xl69 width=174 style='height:33.0pt;border-top:none;\n  width:131pt'><font class='font9'>合同编号</font></td>\n  <td class=xl73 width=174 style='border-top:none;border-left:none;width:131pt'>" . project_db($id, '_4_15_3_2') . "</td>\n  <td class=xl70 width=174 style='border-top:none;border-left:none;width:131pt'><font\n  class='font9'>工单号</font></td>\n  <td class=xl74 width=174 style='border-top:none;border-left:none;width:131pt'>" . project_db($id, '_4_15_3_3') . "</td>\n </tr>\n <tr height=179 style='mso-height-source:userset;height:134.25pt'>\n  <td height=179 class=xl67 width=174 style='height:134.25pt;border-top:none;\n  width:131pt'>制作安装工艺及技术要求<span\n  style='mso-spacerun:yes'><br>\n  </span>（甲方需求）</td>\n  <td colspan=3 class=xl75 width=522 style='border-right:1.0pt solid black;\n  border-left:none;width:393pt'>" . project_db($id, '_4_15_3_4') . "</td>\n </tr>\n <tr height=44 style='mso-height-source:userset;height:33.0pt'>\n  <td height=44 class=xl67 width=174 style='height:33.0pt;border-top:none;\n  width:131pt'>技术图纸</td>\n  <td colspan=3 class=xl73 width=522 style='border-right:1.0pt solid black;\n  border-left:none;width:393pt'>" . project_db($id, '_4_15_3_5') . "</td>\n </tr>\n <tr height=179 style='mso-height-source:userset;height:134.25pt'>\n  <td height=179 class=xl67 width=174 style='height:134.25pt;border-top:none;\n  width:131pt'>制作（安装）完成情况</td>\n  <td colspan=3 class=xl75 width=522 style='border-right:1.0pt solid black;\n  border-left:none;width:393pt'>" . project_db($id, '_4_15_3_6') . "</td>\n </tr>\n <tr height=44 style='mso-height-source:userset;height:33.0pt'>\n  <td height=44 class=xl67 width=174 style='height:33.0pt;border-top:none;\n  width:131pt'>制作（安装）完成<span style='mso-spacerun:yes'><br>\n  </span>时间区间</td>\n  <td colspan=3 class=xl85 width=522 style='border-right:1.0pt solid black;\n  border-left:none;width:393pt'>" . project_db($id, '_4_15_3_7') . "</td>\n </tr>\n <tr height=44 style='mso-height-source:userset;height:33.0pt'>\n  <td height=44 class=xl67 width=174 style='height:33.0pt;border-top:none;\n  width:131pt'>是否符合合同要求制作（安装）时间区间</td>\n  <td colspan=3 class=xl85 width=522 style='border-right:1.0pt solid black;\n  border-left:none;width:393pt'>" . project_db($id, '_4_15_3_8') . "</td>\n </tr>\n <tr height=44 style='mso-height-source:userset;height:33.0pt'>\n  <td height=44 class=xl67 width=174 style='height:33.0pt;border-top:none;\n  width:131pt'>完成效果</td>\n  <td colspan=3 class=xl75 width=522 style='border-right:1.0pt solid black;\n  border-left:none;width:393pt'>" . project_db($id, '_4_15_3_9') . "</td>\n </tr>\n <tr height=44 style='mso-height-source:userset;height:33.0pt'>\n  <td height=44 class=xl67 width=174 style='height:33.0pt;border-top:none;\n  width:131pt'>现场安装人员</td>\n  <td colspan=3 class=xl75 width=522 style='border-right:1.0pt solid black;\n  border-left:none;width:393pt'>" . project_db($id, '_4_15_3_10') . "</td>\n </tr>\n <tr height=44 style='mso-height-source:userset;height:33.0pt'>\n  <td height=44 class=xl67 width=174 style='height:33.0pt;border-top:none;\n  width:131pt'>现场负责人</td>\n  <td colspan=3 class=xl75 width=522 style='border-right:1.0pt solid black;\n  border-left:none;width:393pt'>" . project_db($id, '_4_15_3_11') . "</td>\n </tr>\n <tr height=44 style='mso-height-source:userset;height:33.0pt'>\n  <td height=44 class=xl67 width=174 style='height:33.0pt;border-top:none;\n  width:131pt'>填报人</td>\n  <td class=xl75 width=174 style='border-top:none;border-left:none;width:131pt'>" . project_db($id, '_4_15_3_12') . "</td>\n  <td class=xl71 width=174 style='border-top:none;border-left:none;width:131pt'>验收人</td>\n  <td class=xl76 width=174 style='border-top:none;border-left:none;width:131pt'>" . w_p_v(41, $id, 'name') . "</td>\n </tr>\n <tr height=44 style='mso-height-source:userset;height:33.0pt'>\n  <td height=44 class=xl72 width=174 style='height:33.0pt;border-top:none;\n  width:131pt'>审批人</td>\n  <td colspan=3 class=xl82 width=522 style='border-right:1.0pt solid black;\n  border-left:none;width:393pt'>" . w_p_v(46, $id, 'name') . "(意见:" . w_p_v(46, $id, 'lnstructions') . ")</td>\n </tr>\n <![if supportMisalignedColumns]>\n <tr height=0 style='display:none'>\n  <td width=174 style='width:131pt'></td>\n  <td width=174 style='width:131pt'></td>\n  <td width=174 style='width:131pt'></td>\n  <td width=174 style='width:131pt'></td>\n </tr>\n <![endif]>\n</table>\n\n</body>\n\n</html>\n\n";
    return $htmls;
}

コード例 #9

ファイルを表示

ファイル: 8_zhizuogongdan_view.php プロジェクト: haogm123/ydoa

function xls_views($id, $uid, $title)
{
    $htmls .= '<html xmlns:v="urn:schemas-microsoft-com:vml"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=Content-Type content="text/html; charset=utf-8">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 11">
<!--[if gte mso 9]><xml>
 <o:DocumentProperties>
  <o:Created>2006-09-13T11:21:51Z</o:Created>
  <o:LastSaved>2013-05-06T03:38:00Z</o:LastSaved>
  <o:Version>11.9999</o:Version>
 </o:DocumentProperties>
 <o:OfficeDocumentSettings>
  <o:RemovePersonalInformation/>
 </o:OfficeDocumentSettings>
</xml><![endif]-->
<style>
<!--table
	{mso-displayed-decimal-separator:"\\.";
	mso-displayed-thousand-separator:"\\,";}
@page
	{margin:.75in .24in .75in .24in;
	mso-header-margin:.3in;
	mso-footer-margin:.3in;}
tr
	{mso-height-source:auto;
	mso-ruby-visibility:none;}
col
	{mso-width-source:auto;
	mso-ruby-visibility:none;}
br
	{mso-data-placement:same-cell;}
.style0
	{mso-number-format:General;
	text-align:general;
	vertical-align:middle;
	white-space:nowrap;
	mso-rotate:0;
	mso-background-source:auto;
	mso-pattern:auto;
	color:black;
	font-size:11.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	border:none;
	mso-protection:locked visible;
	mso-style-name:常规;
	mso-style-id:0;}
td
	{mso-style-parent:style0;
	padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:black;
	font-size:11.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-number-format:General;
	text-align:general;
	vertical-align:middle;
	border:none;
	mso-background-source:auto;
	mso-pattern:auto;
	mso-protection:locked visible;
	white-space:nowrap;
	mso-rotate:0;}
.xl65
	{mso-style-parent:style0;
	text-align:left;
	white-space:normal;}
.xl66
	{mso-style-parent:style0;
	font-size:14.0pt;
	font-weight:700;
	text-align:center;
	white-space:normal;}
.xl67
	{mso-style-parent:style0;
	text-align:center;
	border:.5pt solid windowtext;
	white-space:normal;}
.xl68
	{mso-style-parent:style0;
	border:.5pt solid windowtext;
	white-space:normal;}
.xl69
	{mso-style-parent:style0;
	font-weight:700;
	text-align:left;
	border:.5pt solid windowtext;
	white-space:normal;}
.xl70
	{mso-style-parent:style0;
	text-align:center;
	white-space:normal;}
.xl71
	{mso-style-parent:style0;
	text-align:left;
	border:.5pt solid windowtext;
	white-space:normal;}
.xl72
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl73
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	white-space:normal;}
.xl74
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	white-space:normal;}
.xl75
	{mso-style-parent:style0;
	font-size:10.0pt;
	text-align:left;
	border:.5pt solid windowtext;
	white-space:normal;}
.xl76
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl77
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	white-space:normal;}
.xl78
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	white-space:normal;}
ruby
	{ruby-align:left;}
rt
	{color:windowtext;
	font-size:9.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-char-type:none;
	display:none;}
-->
</style>
<!--[if gte mso 9]><xml>
 <x:ExcelWorkbook>
  <x:ExcelWorksheets>
   <x:ExcelWorksheet>
    <x:Name>Sheet1</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>402</x:DefaultRowHeight>
     <x:Unsynced/>
     <x:Print>
      <x:ValidPrinterInfo/>
      <x:PaperSizeIndex>9</x:PaperSizeIndex>
      <x:HorizontalResolution>200</x:HorizontalResolution>
      <x:VerticalResolution>200</x:VerticalResolution>
     </x:Print>
     <x:Selected/>
     <x:TopRowVisible>9</x:TopRowVisible>
     <x:Panes>
      <x:Pane>
       <x:Number>3</x:Number>
       <x:ActiveRow>11</x:ActiveRow>
       <x:ActiveCol>1</x:ActiveCol>
       <x:RangeSelection>$B$12:$D$12</x:RangeSelection>
      </x:Pane>
     </x:Panes>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
   <x:ExcelWorksheet>
    <x:Name>Sheet2</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>270</x:DefaultRowHeight>
     <x:Print>
      <x:ValidPrinterInfo/>
      <x:PaperSizeIndex>9</x:PaperSizeIndex>
      <x:HorizontalResolution>200</x:HorizontalResolution>
      <x:VerticalResolution>200</x:VerticalResolution>
     </x:Print>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
   <x:ExcelWorksheet>
    <x:Name>Sheet3</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>270</x:DefaultRowHeight>
     <x:Print>
      <x:ValidPrinterInfo/>
      <x:PaperSizeIndex>9</x:PaperSizeIndex>
      <x:HorizontalResolution>200</x:HorizontalResolution>
      <x:VerticalResolution>200</x:VerticalResolution>
     </x:Print>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
  </x:ExcelWorksheets>
  <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]--><!--[if gte mso 9]><xml>
 <o:shapedefaults v:ext="edit" spidmax="2049"/>
</xml><![endif]-->
</head>

<body link=blue vlink=purple>';
    $htmls .= "<table x:str border=0 cellpadding=0 cellspacing=0 width=810 style='border-collapse:\n collapse;table-layout:fixed;width:608pt'>\n <col width=157 style='mso-width-source:userset;mso-width-alt:5024;width:118pt'>\n <col width=248 style='mso-width-source:userset;mso-width-alt:7936;width:186pt'>\n <col width=157 style='mso-width-source:userset;mso-width-alt:5024;width:118pt'>\n <col width=248 style='mso-width-source:userset;mso-width-alt:7936;width:186pt'>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td colspan=2 height=37 class=xl65 width=405 style='height:27.95pt;\n  width:304pt'>公司：" . project_db($id, '_4_8_3_1') . "</td>\n  <td class=xl70 width=157 style='width:118pt'>No.:</td>\n  <td class=xl65 width=248 style='width:186pt'>" . project_db($id, '_4_8_3_2') . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td colspan=4 height=37 class=xl66 width=810 style='height:27.95pt;\n  width:608pt'>" . $title . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl67 width=157 style='height:27.95pt;width:118pt'>日期</td>\n  <td class=xl71 width=248 style='border-left:none;width:186pt'>" . project_db($id, '_4_8_3_3') . "</td>\n  <td class=xl67 width=157 style='border-left:none;width:118pt'>经办业务员</td>\n  <td class=xl71 width=248 style='border-left:none;width:186pt'>" . project_db($id, '_4_8_3_4') . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl67 width=157 style='height:27.95pt;border-top:none;\n  width:118pt'>客户名称</td>\n  <td class=xl71 width=248 style='border-top:none;border-left:none;width:186pt'>" . project_db($id, '_4_8_3_5') . "</td>\n  <td class=xl67 width=157 style='border-top:none;border-left:none;width:118pt'>地址</td>\n  <td class=xl71 width=248 style='border-top:none;border-left:none;width:186pt'>" . project_db($id, '_4_8_3_6') . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl67 width=157 style='height:27.95pt;border-top:none;\n  width:118pt'>电话</td>\n  <td class=xl71 width=248 style='border-top:none;border-left:none;width:186pt'>" . project_db($id, '_4_8_3_7') . "</td>\n  <td class=xl67 width=157 style='border-top:none;border-left:none;width:118pt'>合同号</td>\n  <td class=xl71 width=248 style='border-top:none;border-left:none;width:186pt'>" . project_db($id, '_4_8_3_8') . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td colspan=4 height=37 class=xl72 width=810 style='border-right:.5pt solid black;\n  height:27.95pt;width:608pt'>客户是否已认定方案：" . project_db($id, '_4_8_3_9') . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td colspan=4 height=37 class=xl69 width=810 style='height:27.95pt;\n  width:608pt'>施工项目具体内容说明</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl67 width=157 style='height:27.95pt;border-top:none;\n  width:118pt'>制作项目名称</td>\n  <td class=xl71 width=248 style='border-top:none;border-left:none;width:186pt'>" . project_db($id, '_4_8_3_10') . "</td>\n  <td class=xl67 width=157 style='border-top:none;border-left:none;width:118pt'>工期要求</td>\n  <td class=xl71 width=248 style='border-top:none;border-left:none;width:186pt'>" . project_db($id, '_4_8_3_11') . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl67 width=157 style='height:27.95pt;border-top:none;\n  width:118pt'>具体说明</td>\n  <td colspan=3 class=xl72 width=653 style='border-right:.5pt solid black;\n  border-left:none;width:490pt'>" . project_db($id, '_4_8_3_12') . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl67 width=157 style='height:27.95pt;border-top:none;\n  width:118pt'>规格尺寸</td>\n  <td class=xl71 width=248 style='border-top:none;border-left:none;width:186pt'>" . project_db($id, '_4_8_3_13') . "</td>\n  <td class=xl67 width=157 style='border-top:none;border-left:none;width:118pt'>施工地点</td>\n  <td class=xl68 width=248 style='border-top:none;border-left:none;width:186pt'>" . project_db($id, '_4_8_3_14') . "</td>\n </tr>\n <tr height=110 style='mso-height-source:userset;height:82.5pt'>\n  <td height=110 class=xl67 width=157 style='height:82.5pt;border-top:none;\n  width:118pt'>安装位置</td>\n  <td class=xl71 width=248 style='border-top:none;border-left:none;width:186pt'>" . project_db($id, '_4_8_3_15') . "</td>\n  <td class=xl67 width=157 style='border-top:none;border-left:none;width:118pt'>附件</td>\n  <td class=xl75 width=248 style='border-top:none;border-left:none;width:186pt'\n >效果图<span\n  style='mso-spacerun:yes'>" . project_db($id, '_4_8_3_16') . "</span><br>\n    <br>\n    结构图<span style='mso-spacerun:yes'>" . project_db($id, '_4_8_3_17') . "</span></td>\n </tr>\n <tr height=133 style='mso-height-source:userset;height:99.75pt'>\n  <td height=133 class=xl67 width=157 style='height:99.75pt;border-top:none;\n  width:118pt'>其他详细说明</td>\n  <td colspan=3 class=xl72 width=653 style='border-right:.5pt solid black;\n  border-left:none;width:490pt'>" . project_db($id, '_4_8_3_18') . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl67 width=157 style='height:27.95pt;border-top:none;\n  width:118pt'>现场电源联系人</td>\n  <td class=xl71 width=248 style='border-top:none;border-left:none;width:186pt'>" . project_db($id, '_4_8_3_19') . "</td>\n  <td class=xl67 width=157 style='border-top:none;border-left:none;width:118pt'>电话</td>\n  <td class=xl71 width=248 style='border-top:none;border-left:none;width:186pt'>" . project_db($id, '_4_8_3_20') . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl67 width=157 style='height:27.95pt;border-top:none;\n  width:118pt'>现场业务接洽人</td>\n  <td class=xl71 width=248 style='border-top:none;border-left:none;width:186pt'>" . project_db($id, '_4_8_3_21') . "</td>\n  <td class=xl67 width=157 style='border-top:none;border-left:none;width:118pt'>电话</td>\n  <td class=xl71 width=248 style='border-top:none;border-left:none;width:186pt'>" . project_db($id, '_4_8_3_22') . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl67 width=157 style='height:27.95pt;border-top:none;\n  width:118pt'>现场勘查人</td>\n  <td class=xl71 width=248 style='border-top:none;border-left:none;width:186pt'>" . project_db($id, '_4_8_3_23') . "</td>\n  <td class=xl67 width=157 style='border-top:none;border-left:none;width:118pt'>电话</td>\n  <td class=xl71 width=248 style='border-top:none;border-left:none;width:186pt'>" . project_db($id, '_4_8_3_24') . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl67 width=157 style='height:27.95pt;border-top:none;\n  width:118pt'>部门负责人审批</td>\n  <td colspan=3 class=xl76 width=653 style='border-right:.5pt solid black;\n  border-left:none;width:490pt'>" . w_p_v(16, $id, 'name') . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl67 width=157 style='height:27.95pt;border-top:none;\n  width:118pt'>工程制作负责人接收</td>\n  <td colspan=3 class=xl76 width=653 style='border-right:.5pt solid black;\n  border-left:none;width:490pt'>" . w_p_v(17, $id, 'name') . "</td>\n </tr>\n <![if supportMisalignedColumns]>\n <tr height=0 style='display:none'>\n  <td width=157 style='width:118pt'></td>\n  <td width=248 style='width:186pt'></td>\n  <td width=157 style='width:118pt'></td>\n  <td width=248 style='width:186pt'></td>\n </tr>\n <![endif]>\n</table>\n\n</body>\n\n</html>\n\n";
    return $htmls;
}

コード例 #10

ファイルを表示

ファイル: 7_yunyinggongdanjifankui_view.php プロジェクト: haogm123/ydoa

function xls_views($id, $uid, $title)
{
    $htmls .= '<html xmlns:v="urn:schemas-microsoft-com:vml"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=Content-Type content="text/html; charset=utf-8">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 11">
<!--[if gte mso 9]><xml>
 <o:DocumentProperties>
  <o:Created>2006-09-13T11:21:51Z</o:Created>
  <o:LastSaved>2013-05-06T04:37:31Z</o:LastSaved>
  <o:Version>11.9999</o:Version>
 </o:DocumentProperties>
 <o:OfficeDocumentSettings>
  <o:RemovePersonalInformation/>
 </o:OfficeDocumentSettings>
</xml><![endif]-->
<style>
<!--table
	{mso-displayed-decimal-separator:"\\.";
	mso-displayed-thousand-separator:"\\,";}
@page
	{margin:.75in .7in .75in .7in;
	mso-header-margin:.3in;
	mso-footer-margin:.3in;}
tr
	{mso-height-source:auto;
	mso-ruby-visibility:none;}
col
	{mso-width-source:auto;
	mso-ruby-visibility:none;}
br
	{mso-data-placement:same-cell;}
.style0
	{mso-number-format:General;
	text-align:general;
	vertical-align:middle;
	white-space:nowrap;
	mso-rotate:0;
	mso-background-source:auto;
	mso-pattern:auto;
	color:black;
	font-size:11.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	border:none;
	mso-protection:locked visible;
	mso-style-name:常规;
	mso-style-id:0;}
td
	{mso-style-parent:style0;
	padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:black;
	font-size:11.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-number-format:General;
	text-align:general;
	vertical-align:middle;
	border:none;
	mso-background-source:auto;
	mso-pattern:auto;
	mso-protection:locked visible;
	white-space:nowrap;
	mso-rotate:0;}
.xl65
	{mso-style-parent:style0;
	text-align:center;}
.xl66
	{mso-style-parent:style0;
	text-align:center;
	border:.5pt solid windowtext;
	white-space:normal;}
.xl67
	{mso-style-parent:style0;
	text-align:left;
	border:.5pt solid windowtext;
	white-space:normal;}
.xl68
	{mso-style-parent:style0;
	font-size:14.0pt;
	font-weight:700;
	text-align:center;
	white-space:normal;}
.xl69
	{mso-style-parent:style0;
	text-align:center;
	white-space:normal;}
.xl70
	{mso-style-parent:style0;
	font-weight:700;
	text-align:center;
	border:.5pt solid windowtext;
	background:silver;
	mso-pattern:auto none;
	white-space:normal;}
.xl71
	{mso-style-parent:style0;
	text-align:left;
	white-space:normal;}
.xl72
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl73
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	white-space:normal;}
.xl74
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	white-space:normal;}
.xl75
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl76
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	white-space:normal;}
.xl77
	{mso-style-parent:style0;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	white-space:normal;}
ruby
	{ruby-align:left;}
rt
	{color:windowtext;
	font-size:9.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-char-type:none;
	display:none;}
-->
</style>
<!--[if gte mso 9]><xml>
 <x:ExcelWorkbook>
  <x:ExcelWorksheets>
   <x:ExcelWorksheet>
    <x:Name>Sheet1</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>559</x:DefaultRowHeight>
     <x:Unsynced/>
     <x:Print>
      <x:ValidPrinterInfo/>
      <x:PaperSizeIndex>9</x:PaperSizeIndex>
      <x:HorizontalResolution>200</x:HorizontalResolution>
      <x:VerticalResolution>200</x:VerticalResolution>
     </x:Print>
     <x:Selected/>
     <x:TopRowVisible>8</x:TopRowVisible>
     <x:Panes>
      <x:Pane>
       <x:Number>3</x:Number>
       <x:ActiveRow>15</x:ActiveRow>
       <x:ActiveCol>4</x:ActiveCol>
      </x:Pane>
     </x:Panes>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
   <x:ExcelWorksheet>
    <x:Name>Sheet2</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>270</x:DefaultRowHeight>
     <x:Print>
      <x:ValidPrinterInfo/>
      <x:PaperSizeIndex>9</x:PaperSizeIndex>
      <x:HorizontalResolution>200</x:HorizontalResolution>
      <x:VerticalResolution>200</x:VerticalResolution>
     </x:Print>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
   <x:ExcelWorksheet>
    <x:Name>Sheet3</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>270</x:DefaultRowHeight>
     <x:Print>
      <x:ValidPrinterInfo/>
      <x:PaperSizeIndex>9</x:PaperSizeIndex>
      <x:HorizontalResolution>200</x:HorizontalResolution>
      <x:VerticalResolution>200</x:VerticalResolution>
     </x:Print>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
  </x:ExcelWorksheets>
  <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]--><!--[if gte mso 9]><xml>
 <o:shapedefaults v:ext="edit" spidmax="2049"/>
</xml><![endif]-->
</head>

<body link=blue vlink=purple>';
    $htmls .= "<table x:str border=0 cellpadding=0 cellspacing=0 width=756 style='border-collapse:\n collapse;table-layout:fixed;width:568pt'>\n <col class=xl65 width=133 style='mso-width-source:userset;mso-width-alt:4256;\n width:100pt'>\n <col width=245 style='mso-width-source:userset;mso-width-alt:7840;width:184pt'>\n <col width=133 style='mso-width-source:userset;mso-width-alt:4256;width:100pt'>\n <col width=245 style='mso-width-source:userset;mso-width-alt:7840;width:184pt'>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td colspan=2 height=37 class=xl71 width=378 style='height:27.95pt;\n  width:284pt'>公司：" . project_db($id, '_4_7_3_1') . "</td>\n  <td colspan=2 class=xl71 width=378 style='width:284pt'>No.:" . project_db($id, '_4_7_3_2') . "</td>\n </tr>\n <tr height=66 style='mso-height-source:userset;height:50.1pt'>\n  <td colspan=4 height=66 class=xl68 width=756 style='height:50.1pt;width:568pt'>" . $title . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl66 width=133 style='height:27.95pt;width:100pt'>填表日期</td>\n  <td class=xl67 width=245 style='border-left:none;width:184pt'>" . project_db($id, '_4_7_3_3') . "</td>\n  <td class=xl66 width=133 style='border-left:none;width:100pt'>完成日期</td>\n  <td class=xl67 width=245 style='border-left:none;width:184pt'>" . project_db($id, '_4_7_3_4') . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl66 width=133 style='height:27.95pt;border-top:none;\n  width:100pt'>责任人</td>\n  <td class=xl67 width=245 style='border-top:none;border-left:none;width:184pt'>" . project_db($id, '_4_7_3_5') . "</td>\n  <td class=xl69 width=133 style='width:100pt'>责任部门</td>\n  <td class=xl67 width=245 style='border-top:none;width:184pt'>" . project_db($id, '_4_7_3_6') . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl66 width=133 style='height:27.95pt;border-top:none;\n  width:100pt'>客户名称</td>\n  <td class=xl67 width=245 style='border-top:none;border-left:none;width:184pt'>" . project_db($id, '_4_7_3_7') . "</td>\n  <td class=xl66 width=133 style='border-left:none;width:100pt'>项目名称地点</td>\n  <td class=xl67 width=245 style='border-top:none;border-left:none;width:184pt'>" . project_db($id, '_4_7_3_8') . "</td>\n </tr>\n <tr height=88 style='mso-height-source:userset;height:66.0pt'>\n  <td height=88 class=xl66 width=133 style='height:66.0pt;border-top:none;\n  width:100pt'>项目内容材质尺寸</td>\n  <td colspan=3 class=xl72 width=623 style='border-right:.5pt solid black;\n  border-left:none;width:468pt'>" . project_db($id, '_4_7_3_9') . "</td>\n </tr>\n <tr height=88 style='mso-height-source:userset;height:66.0pt'>\n  <td height=88 class=xl66 width=133 style='height:66.0pt;border-top:none;\n  width:100pt'>提供材料</td>\n  <td colspan=3 class=xl72 width=623 style='border-right:.5pt solid black;\n  border-left:none;width:468pt'>现场照片:" . project_db($id, '_4_7_3_10') . "<br>\n    效果图 :" . project_db($id, '_4_7_3_11') . "<br>\n    三视图（三围尺寸）:" . project_db($id, '_4_7_3_12') . "</td>\n </tr>\n <tr height=88 style='mso-height-source:userset;height:66.0pt'>\n  <td height=88 class=xl66 width=133 style='height:66.0pt;border-top:none;\n  width:100pt'>责任部门<br>拟定价格<br>及要求</td>\n  <td colspan=3 class=xl67 width=623 style='border-left:none;width:468pt'>" . project_db($id, '_4_7_3_13') . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl66 width=133 style='height:27.95pt;border-top:none;\n  width:100pt'>部门负责人意见</td>\n  <td colspan=3 class=xl67 width=623 style='border-left:none;width:468pt'>" . w_p_v(19, $id, 'name') . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl66 width=133 style='height:27.95pt;border-top:none;\n  width:100pt'>运营负责人接收</td>\n  <td colspan=3 class=xl67 width=623 style='border-left:none;width:468pt'>" . w_p_v(20, $id, 'name') . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td colspan=4 height=37 class=xl70 width=756 style='height:27.95pt;\n  width:568pt'>运营反馈</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl66 width=133 style='height:27.95pt;border-top:none;\n  width:100pt'>任务分配运营人员</td>\n  <td colspan=3 class=xl67 width=623 style='border-left:none;width:468pt'>" . project_db($id, '_4_7_4_t1') . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl66 width=133 style='height:27.95pt;border-top:none;\n  width:100pt'>工艺</td>\n  <td colspan=3 class=xl67 width=623 style='border-left:none;width:468pt'>" . project_db($id, '_4_7_4_t2') . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl66 width=133 style='height:27.95pt;border-top:none;\n  width:100pt'>结构图纸</td>\n  <td colspan=3 class=xl67 width=623 style='border-left:none;width:468pt'>" . project_db($id, '_4_7_4_t3') . "</td>\n </tr>\n <tr height=37 style='mso-height-source:userset;height:27.95pt'>\n  <td height=37 class=xl66 width=133 style='height:27.95pt;border-top:none;\n  width:100pt'>材料清单</td>\n  <td colspan=3 class=xl75 width=623 style='border-right:.5pt solid black;\n  border-left:none;width:468pt'>" . project_db($id, '_4_7_4_t4') . "</td>\n </tr>\n <![if supportMisalignedColumns]>\n <tr height=0 style='display:none'>\n  <td width=133 style='width:100pt'></td>\n  <td width=245 style='width:184pt'></td>\n  <td width=133 style='width:100pt'></td>\n  <td width=245 style='width:184pt'></td>\n </tr>\n <![endif]>\n</table>\n\n</body>\n\n</html>\n\n\n";
    return $htmls;
}