PageRenderTime 693ms CodeModel.GetById 20ms RepoModel.GetById 1ms app.codeStats 0ms

/circulation_all.php

https://github.com/yichaowang/Library-Circulation-Table
PHP | 291 lines | 270 code | 19 blank | 2 comment | 45 complexity | 4caae147997f58831b6f898c6aa6cb08 MD5 | raw file
    

  1. <?php

    2. 

  2. 

    3. 

  3. 	include ('checkdate.php');

    4. 

  4. 	

    5. 

  5. 	$type = $_REQUEST['type'];		//类型：借阅、续借、归还

    6. 

  6. 	$stat = $_REQUEST['stat'];		//月报、年报

    7. 

  7. 	$year = $_REQUEST['year'];

    8. 

  8. 	$month = $_REQUEST['month'];

    9. 

  9. 	

    10. 

  10. 	$cur_row = 0;

    11. 

  11. 	

    12. 

  12. 	if (empty ($type)) $type = 1;

    13. 

  13. 	if (empty ($stat)) $stat = 1;

    14. 

  14. 	if (empty ($year)) $year = '0000';

    15. 

  15. 	if (empty ($month))

    16. 

  16. 		$month = strftime ('%m') - 1;

    17. 

  17. 	if ($month == 0) {

    18. 

  18. 		$month = 12;

    19. 

  19. 	}

    20. 

  20. 	if (strlen ($month) == 1)

    21. 

  21. 		$month = '0' . $month;

    22. 

  22. 

    23. 

  23. 	if ($stat == 2)

    24. 

  24. 		$month = '01';

    25. 

  25. 

    26. 

  26. 	include ('db-utf8.php');

    27. 

  27. 	

    28. 

  28. 	

    29. 

  29. 	if ($stat == 1)

    30. 

  30. 		$condition = $db->qstr("${year}${month}%");

    31. 

  31. 	else

    32. 

  32. 		$condition = $db->qstr("${year}%");

    33. 

  33. 		

    34. 

  34. 	$sql = "select * from circulation where type = $type and [日期] like $condition order by [日期]";

    35. 

  35. 	

    36. 

  36. 	$rs = $db->Execute ($sql);

    37. 

  37. 	

    38. 

  38. 	if ($rs === false) {

    39. 

  39. 		print $db->ErrorMsg();

    40. 

  40. 		die ("can't execute sql: " . $sql);

    41. 

  41. 	}

    42. 

  42. 

    43. 

  43. ?>

    44. 

  44. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"

    45. 

  45.  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

    46. 

  46. <html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/lib.dwt" codeOutsideHTMLIsLocked="false" -->

    47. 

  47. <head>

    48. 

  48. <!-- InstanceBeginEditable name="doctitle" -->

    49. 

  49. <meta http-equiv="Content-Type" content="text/html; charset=gb2312" />

    50. 

  50. <title>北京大学图书馆社会学系分馆 - 流通信息 - 全校流通</title>

    51. 

  51. <!-- InstanceEndEditable -->

    52. 

  52. <link rel="stylesheet" href="2col_leftNav.css" type="text/css" />

    53. 

  53. <link rel="shortcut icon" type="image/ico" href="favicon.ico" />

    54. 

  54. <!--[if lt IE 7.]>

    55. 

  55. <script defer type="text/javascript" src="pngfix.js"></script>

    56. 

  56. <![endif]-->

    57. 

  57. </head>

    58. 

  58. <body>

    59. 

  59. <div id="masthead">

    60. 

  60.   <div id="sitehead"><img src="images/site_title.gif" alt="" /><h1 id="siteName">北京大学图书馆社会学分馆</h1></div>

    61. 

  61.   <div id="globalNav"> <a href="index.php">分馆简介</a> |<a href="#"></a> <a href="newbooks.php">新书通报</a> |<a href="#"></a> <a href="recommend.php">读者推荐</a> |<a href="#"></a> <a href="thesis.php">学位论文</a> |<a href="#"></a> <a href="reference.php">教学参考</a> |<a href="#"></a> <a href="archievement.php">科研成果</a> |<a href="#"></a> <a href="quotation.php">引文文献</a> |<a href="#"></a> <a href="allbook.php">馆藏书目</a> |<a href="#"></a> <a href="resource.php">电子资源</a> |<a href="#"></a> <a href="http://162.105.138.200/uhtbin/cgisirsi/0/0/0/49" target="_blank">书目检索</a> |<a href="#"></a> <a href="circulation.php">流通信息</a> </div>

    62. 

  62. </div>

    63. 

  63. <!-- end masthead -->

    64. 

  64. <!-- InstanceBeginEditable name="EditRegionMain" -->

    65. 

  65. <div id="content">

    66. 

  66.   <div class="feature">

    67. 

  67.     <h2 align="left">

    68. 

  68.       <?php

    69. 

  69. 		if ($stat == 1) {

    70. 

  70. 			if ($year == '0000' || $month > 12)

    71. 

  71. 				echo '请选择日期，然后开始';

    72. 

  72. 			else

    73. 

  73. 				switch ($type) {

    74. 

  74. 					case 0: echo '请选择日期，然后开始';

    75. 

  75. 					case 1:	echo "${year}年${month}月流通量统计 - 借阅"; break;

    76. 

  76. 					case 3: echo "${year}年${month}月流通量统计 - 续借"; break;

    77. 

  77. 					case 2: echo "${year}年${month}月流通量统计 - 归还"; break;

    78. 

  78. 				}

    79. 

  79. 		} else {

    80. 

  80. 			if ($year == '0000')

    81. 

  81. 				echo '请选择日期，然后开始';

    82. 

  82. 			else

    83. 

  83. 				switch ($type) {

    84. 

  84. 					case 1:	echo "${year}年流通量统计 - 借阅"; break;

    85. 

  85. 					case 3: echo "${year}年流通量统计 - 续借"; break;

    86. 

  86. 					case 2: echo "${year}年流通量统计 - 归还"; break;

    87. 

  87. 				}

    88. 

  88. 		}

    89. 

  89. 	?>

    90. 

  90.     </h2>

    91. 

  91.   </div>

    92. 

  92.   <div class="story">

    93. 

  93.     <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" enctype="application/x-www-form-urlencoded" name="fm_thesis" id="fm_thesis">

    94. 

  94.       <table width="67%"  border="0" align="center">

    95. 

  95.         <tr>

    96. 

  96.           <td width="18%" align="center">选择时间</td>

    97. 

  97.           <td width="25%"><input name="year" type="text" value="<?php

    98. 

  98. 				if( empty($year) || $year == '0000') {

    99. 

  99. 					if ($month == '12')

    100. 

  100. 						echo strftime ('%Y') - 1;

    101. 

  101. 					else

    102. 

  102. 						echo strftime ('%Y');

    103. 

  103. 				}

    104. 

  104. 				else

    105. 

  105. 					echo $year;

    106. 

  106. 			?>" size="8" maxlength="4" />

    107. 

  107.             年 </td>

    108. 

  108.           <td width="27%"><?php if ($stat == 1) { ?>

    109. 

  109.             <select name="month">

    110. 

  110.               <option value="01" <?php if($month == '01') echo 'selected="selected"';?>>一月</option>

    111. 

  111.               <option value="02" <?php if($month == '02') echo 'selected="selected"';?>>二月</option>

    112. 

  112.               <option value="03" <?php if($month == '03') echo 'selected="selected"';?>>三月</option>

    113. 

  113.               <option value="04" <?php if($month == '04') echo 'selected="selected"';?>>四月</option>

    114. 

  114.               <option value="05" <?php if($month == '05') echo 'selected="selected"';?>>五月</option>

    115. 

  115.               <option value="06" <?php if($month == '06') echo 'selected="selected"';?>>六月</option>

    116. 

  116.               <option value="07" <?php if($month == '07') echo 'selected="selected"';?>>七月</option>

    117. 

  117.               <option value="08" <?php if($month == '08') echo 'selected="selected"';?>>八月</option>

    118. 

  118.               <option value="09" <?php if($month == '09') echo 'selected="selected"';?>>九月</option>

    119. 

  119.               <option value="10" <?php if($month == '10') echo 'selected="selected"';?>>十月</option>

    120. 

  120.               <option value="11" <?php if($month == '11') echo 'selected="selected"';?>>十一月</option>

    121. 

  121.               <option value="12" <?php if($month == '12') echo 'selected="selected"';?>>十二月</option>

    122. 

  122.             </select>

    123. 

  123.             <?php } ?></td>

    124. 

  124.           <td width="10%"><input name="type" type="hidden" value="<?php echo $type; ?>" />

    125. 

  125.             <input type="hidden" name="stat" value="<?php echo $stat; ?>" /></td>

    126. 

  126.           <td width="20%"><input type="submit" value="提交" /></td>

    127. 

  127.         </tr>

    128. 

  128.       </table>

    129. 

  129.     </form>

    130. 

  130.     <table width="100%"  border="0" cellspacing="1">

    131. 

  131.       <tr bgcolor="#EBEBEB">

    132. 

  132.         <?php

    133. 

  133. 	if ($rs->EOF) echo '	    <td>&nbsp;</td>';

    134. 

  134. 	

    135. 

  135. 	$fieldcnt = $rs->FieldCount();

    136. 

  136. 	$array_total_cnt = array_fill (0, $fieldcnt - 3, 0);		// 总数统计数组

    137. 

  137. 	$array_month_cnt = array_fill (0, $fieldcnt - 3, 0);		// 年报统计数组

    138. 

  138. 

    139. 

  139. 	for ($i = 2; !$rs->EOF && $i < $fieldcnt; $i++ ) {

    140. 

  140. 		$field = $rs->FetchField ($i);

    141. 

  141. 		echo '        <th scope="col">', $field->name, '</th>', "\n";	// 显示表头

    142. 

  142. 	}

    143. 

  143. 	if (!$rs->EOF) echo '        <th scope="col">合计</th>', "\n";

    144. 

  144. ?>

    145. 

  145.       </tr>

    146. 

  146.       <?php

    147. 

  147. 	for ($cur_row = 1; !$rs->EOF; $cur_row++, $rs->MoveNext() ) {

    148. 

  148. 		// 年报需要每个月累加统计

    149. 

  149. 		if ($stat == 2) {

    150. 

  150. 			$lastdates = $dates;

    151. 

  151. 			$dates = substr($rs->fields[2], 4, 2);

    152. 

  152. 			if ($dates != $month) {	// 下个月，需要输出数据

    153. 

  153. 				if ($month %2 == 0)

    154. 

  154. 					echo '      <tr bgcolor="#F9F9F9">', "\n";

    155. 

  155. 				else	

    156. 

  156. 					echo "      <tr>\n";

    157. 

  157. 

    158. 

  158. 				for ($i = 2; $i < $fieldcnt; $i++ ) {

    159. 

  159. 					if ($i == 2)										// 日期突出显示

    160. 

  160. 						echo '        <td align="center" bgcolor="#F9FFF9">', $year . $lastdates, '</td>', "\n";

    161. 

  161. 					else {

    162. 

  162. 						echo '        <td align="center">', $array_month_cnt[$i - 2], '</td>', "\n";

    163. 

  163. 					}

    164. 

  164. 				}

    165. 

  165. 				echo '        <td align="right" bgcolor="#FFEEDD">', array_sum ($array_month_cnt), '</td>', "\n";

    166. 

  166. 				echo "      </tr>\n";

    167. 

  167. 				$month = $dates;

    168. 

  168. 				$array_month_cnt = array_fill (0, $fieldcnt - 3, 0);		// 年报统计数组

    169. 

  169. 			}

    170. 

  170. 		}

    171. 

  171. 

    172. 

  172. 		$array_sub_cnt = array_fill (0, $fieldcnt - 3, 0);			// 每条记录统计

    173. 

  173. 		// 月报

    174. 

  174. 		if ($stat == 1) {

    175. 

  175. 			$color = '';

    176. 

  176. 			if ($cur_row % 2 == 0)

    177. 

  177. 				$color = '#F9F9F9';

    178. 

  178. 			if ( $stat == 1 && is_weekend($rs->fields[2]))

    179. 

  179. 				$color = '#EEEEFF';

    180. 

  180. 			

    181. 

  181. 			if (strlen($color))

    182. 

  182. 				echo '      <tr bgcolor="', $color, '">';					// 周末突出显示

    183. 

  183. 			else	

    184. 

  184. 				echo '      <tr>';

    185. 

  185. 		}

    186. 

  186. 		

    187. 

  187. 		for ($i = 2; $i < $fieldcnt; $i++ ) {

    188. 

  188. 			$value = $rs->fields[$i];

    189. 

  189. 			if (empty ($value)) $value = 0;

    190. 

  190. 			if ($stat == 1)

    191. 

  191. 				if ($i == 2)										// 日期突出显示

    192. 

  192. 					echo '        <td align="center" bgcolor="#F9FFF9">', $value, '</td>', "\n";

    193. 

  193. 				else

    194. 

  194. 					echo '        <td align="center">', $value, '</td>', "\n";

    195. 

  195. 			

    196. 

  196. 			if ($i != 2) {

    197. 

  197. 				$array_sub_cnt[$i - 2] = $value;

    198. 

  198. 				$array_month_cnt[$i - 2] += $value;

    199. 

  199. 				$array_total_cnt[$i - 2] += $value;

    200. 

  200. 			}

    201. 

  201. 		}

    202. 

  202. 		

    203. 

  203. 		if ($stat == 1) {

    204. 

  204. 			echo '        <td align="right" bgcolor="#FFEEDD">', array_sum ($array_sub_cnt), '</td>', "\n";

    205. 

  205. 			echo "      </tr>\n";

    206. 

  206. 		}

    207. 

  207. 	} // end of for

    208. 

  208. 	if ($rs->RecordCount() > 0) {

    209. 

  209. 		if ($stat == 2) {		// 输出最后一次统计的结果

    210. 

  210. 			if ($month %2 == 0)

    211. 

  211. 				echo '      <tr bgcolor="#F9F9F9">', "\n";

    212. 

  212. 			else	

    213. 

  213. 				echo "      <tr>\n";

    214. 

  214. 	

    215. 

  215. 			for ($i = 2; $i < $fieldcnt; $i++ ) {

    216. 

  216. 				if ($i == 2)										// 日期突出显示

    217. 

  217. 					echo '        <td align="center" bgcolor="#F9FFF9">', $year . $dates, '</td>', "\n";

    218. 

  218. 				else {

    219. 

  219. 					echo '        <td align="center">', $array_month_cnt[$i - 2], '</td>', "\n";

    220. 

  220. 				}

    221. 

  221. 			}

    222. 

  222. 			echo '        <td align="right" bgcolor="#FFEEDD">', array_sum ($array_month_cnt), '</td>', "\n";

    223. 

  223. 			echo "      </tr>\n";

    224. 

  224. 		}

    225. 

  225. 

    226. 

  226. 		echo '		<tr bgcolor="#EBEBEB">';

    227. 

  227. 		echo '			<td align="center">总计</td>', "\n";

    228. 

  228. 			for ($i = 1; $i < count ($array_total_cnt); $i++)

    229. 

  229. 				echo '			<td align="center" bgcolor="#FFEEEE">', "$array_total_cnt[$i]</td>\n";

    230. 

  230. 		// 最后的总计

    231. 

  231. 		echo '			<td align="right" bgcolor="#FFDDBB">', array_sum ($array_total_cnt), "</td>\n";

    232. 

  232. 		echo "		</tr>\n";

    233. 

  233. 	}

    234. 

  234. ?>

    235. 

  235.     </table>

    236. 

  236.     <h3>&nbsp;</h3>

    237. 

  237.   </div>

    238. 

  238. </div>

    239. 

  239. <!--end content -->

    240. 

  240. <div id="navBar">

    241. 

  241.   <div id="sectionLinks">

    242. 

  242.     <h3>流通统计</h3>

    243. 

  243.     <ul>

    244. 

  244.       <li><a href="circulation.php?<?php echo "year=$year&amp;month=$month&amp;stat=$stat"; ?>&amp;type=1">本馆流通</a></li>

    245. 

  245.       <li><a href="circulation_isa.php?<?php echo "year=$year"; ?>">借出与复印</a></li>

    246. 

  246.       <li><a href="circulation_all.php?<?php echo "year=$year&amp;month=$month&amp;stat=$stat"; ?>&amp;type=1">全校流通</a></li>

    247. 

  247.       <li>&nbsp;</li>

    248. 

  248.     </ul>

    249. 

  249.     <h3>流通类型</h3>

    250. 

  250.     <ul>

    251. 

  251.       <li><a href="<?php echo $_SERVER['PHP_SELF'], "?year=$year&amp;month=$month&amp;stat=$stat"; ?>&amp;type=1">借阅统计</a></li>

    252. 

  252.       <li><a href="<?php echo $_SERVER['PHP_SELF'], "?year=$year&amp;month=$month&amp;stat=$stat"; ?>&amp;type=3">续借统计</a></li>

    253. 

  253.       <li><a href="<?php echo $_SERVER['PHP_SELF'], "?year=$year&amp;month=$month&amp;stat=$stat"; ?>&amp;type=2">还书统计</a></li>

    254. 

  254.     </ul>

    255. 

  255.   </div>

    256. 

  256.   <div class="relatedLinks">

    257. 

  257.     <h3>&nbsp;</h3>

    258. 

  258.     <h3>统计类型</h3>

    259. 

  259.     <ul>

    260. 

  260.       <li><a href="<?php echo $_SERVER['PHP_SELF'], "?year=$year&amp;month=$month&amp;type=$type"; ?>&amp;stat=1">月报</a></li>

    261. 

  261.       <li><a href="<?php echo $_SERVER['PHP_SELF'], "?year=$year&amp;type=$type"; ?>&amp;stat=2">年报</a></li>

    262. 

  262.     </ul>

    263. 

  263.     <h3>&nbsp;</h3>

    264. 

  264.     <h3>使用须知</h3>

    265. 

  265.     <ul>

    266. 

  266.       <li> &quot;流通信息&quot;栏目显示的数据报表是根据北京大学图书馆流通部每日运行Sirsi系统报表而统计的。其中有几家分馆不实行读者借还的方式进行服务, 故尚无流通数据显示。另外, 由于各分馆网络编目工作尚未结束，部分图书仍使用手工借阅，因此，这里仅反映各分馆机器借还的情况，不反映全部书刊流通情况。数据仅供各分馆工作参考。 </li>

    267. 

  267.     </ul>

    268. 

  268.   </div>

    269. 

  269.   <div id="advert">

    270. 

  270.     <div align="center">

    271. 

  271.       <p><img src="images/43.png" width="128" height="128" alt="" /></p>

    272. 

  272.     </div>

    273. 

  273.   </div>

    274. 

  274.   <div id="headlines">

    275. 

  275.     <p align="center"><img src="graph.php?text=Powered%20by%20LS" width="120" height="80" alt="Powered by DS" /> </p>

    276. 

  276.   </div>

    277. 

  277. </div>

    278. 

  278. <!-- InstanceEndEditable -->

    279. 

  279. <div id="siteInfo"><a href="index.php">关于我们</a> | <a href="sitemap.htm">站点地图</a> | <a href="rules.htm">使用规则</a> | <a href="contact.htm">联系我们</a> | &copy; 2006-2009

    280. 

  280.  北京大学图书馆社会学分馆

    281. 

  281. </div>

    282. 

  282. <div id="w3cert">

    283. 

  283.   <a href="http://jigsaw.w3.org/css-validator/check/referer" target="_blank"><img src="images/valid-css-blue.png" alt="Valid CSS 2.0!" width="88" height="31" border="0" /></a>

    284. 

  284.   <a href="http://validator.w3.org/check/referer" target="_blank"><img src="images/valid-xhtml10-blue.png" alt="Valid XHTML 1.0!" width="88" height="31" border="0" /></a>

    285. 

  285. </div>

    286. 

  286. </body>

    287. 

  287. <!-- InstanceEnd --></html>

    288. 

  288. <?php

    289. 

  289. 	$rs->Close();

    290. 

  290. 	$db->Close();

    291. 

  291. ?>

    292. 

  292.