企业在线工作日志管理系统论文.doc

河北大学工商学院 学年论文 题目： 企业在线工作日志管理系统 代码清单学 部 信息科学与工程学部 班 级 2010级网络工程1班 专 业 电气信息二类 学 号 2010482160 姓 名 李晓虹 指导教师 罗文杰 2012年 06月 06日目录Admin 部分.4Head部分.4Chart 部分项目表格.7用户表格.8Index部分.10Announcement部分通告添加.23通告删除.27通稿编辑.29通告查看.33通告详情.39Log部分日志添加.41日志删除.49日志编辑.51完成日志.59日志查看.60Project部分项目添加.62项目删除.69项目编辑.71项目查看.78项目详情.87Task部分任务详情.107任务添加.149任务编辑.161任务计划.176任务日历.190任务用户编辑.196任务删除.201User部分用户查看.202用户编辑.211修改用户密码.216用户添加.222用户删除.229用户登录.231查看用户详情.232用户登陆错误.253Session部分.254成功页面.257admin部分： ,   a href=default_user_edit.php?UID=    a href=Head部分：（标头）?phpif (!function_exists(GetSQLValueString) function GetSQLValueString($theValue, $theType, $theDefinedValue = , $theNotDefinedValue = ) if (PHP_VERSION a href=index.php class=logourl title=  ,   a href=default_user_edit.php?UID=        a href= if(location.href.toLowerCase().indexOf(index.php)-1)document.getElementById(headerlink).getElementsByTagName(A)1.className=nav_select;else if(location.href.toLowerCase().indexOf(default_project.php)-1)document.getElementById(headerlink).getElementsByTagName(A)2.className=nav_select;else if(location.href.toLowerCase().indexOf(default_user.php)-1)document.getElementById(headerlink).getElementsByTagName(A)3.className=nav_select;else if(location.href.toLowerCase().indexOf(default_announcement.php)-1)document.getElementById(headerlink).getElementsByTagName(A)4.className=nav_select; 0) / Show if recordset not empty ? : a href=announcement_view.php?recordID=      ( ) a href=index.php class=logourl title= chart 部分：项目表格：set_style(font-size:12px; font-weight:bold;); $pie = new pie(); $pie-set_alpha(0.6); $pie-set_start_angle( 32 ); $pie-add_animation( new pie_fade() ); $pie-set_tooltip( #val# .$multilingual_project_hour ); $pie-set_colours( array(#99C754,#54C7C5,#999999,#996699,#009900,#77C600,#ff7400, #FF0000,#4096ee,#c79810) ); $projectid = $_GETrecordID;mysql_select_db($database_tankdb, $tankdb);$query_Recordset_sumtotal = sprintf(SELECT sum(csa_tb_manhour) as sum_hour FROM tk_task_byday WHERE csa_tb_backup3 = .$projectid.);$Recordset_sumtotal = mysql_query($query_Recordset_sumtotal, $tankdb) or die(mysql_error();$row_Recordset_sumtotal = mysql_fetch_assoc($Recordset_sumtotal);$t=$row_Recordset_sumtotalsum_hour; $sql=sprintf(SELECT * , sum(csa_tb_manhour) as summ1 FROM tk_task_byday inner join tk_task_tpye on tk_task_byday.csa_tb_backup4=tk_task_tpye.idWHERE csa_tb_backup3 = .$projectid. GROUP BY csa_tb_backup4 ORDER BY summ1 DESC); $query = mysql_query($sql, $tankdb) or die(mysql_error();while($row=mysql_fetch_assoc($query) $total=$rowsumm1; if(!empty($t) $v=round($total/$t,2)*100; else $v=0; $dis=array(name=$rowtask_tpye,total=$rowsumm1,v=$v); $len_dis=count($dis); for($i=0;$iset_values($dis_value); $chart = new open_flash_chart(); $chart-set_title( $title ); $chart-add_element( $pie ); $chart-x_axis = null; $chart-bg_colour = ( #FFFFFF ); echo $chart-toPrettyString(); ?用户表格：set_style(font-size:12px; font-weight:bold;); $pie = new pie(); $pie-set_alpha(0.6); $pie-set_start_angle( 32 ); $pie-add_animation( new pie_fade() ); $pie-set_tooltip( #val# .$multilingual_project_hour ); $pie-set_colours( array(#99C754,#54C7C5,#999999,#996699,#009900,#77C600,#ff7400, #FF0000,#4096ee,#c79810) ); $projectid = $_GETrecordID;mysql_select_db($database_tankdb, $tankdb);$query_Recordset_sumtotal = sprintf(SELECT sum(csa_tb_manhour) as sum_hour FROM tk_task_byday WHERE csa_tb_backup2 = $projectid);$Recordset_sumtotal = mysql_query($query_Recordset_sumtotal, $tankdb) or die(mysql_error();$row_Recordset_sumtotal = mysql_fetch_assoc($Recordset_sumtotal);$t=$row_Recordset_sumtotalsum_hour; $sql=sprintf(SELECT * , sum(csa_tb_manhour) as summ1 FROM tk_task_byday inner join tk_task_tpye on tk_task_byday.csa_tb_backup4=tk_task_tpye.idWHERE csa_tb_backup2 = $projectid GROUP BY csa_tb_backup4 ORDER BY summ1 DESC); $query = mysql_query($sql, $tankdb) or die(mysql_error();while($row=mysql_fetch_assoc($query) $total=$rowsumm1; if(!empty($t) $v=round($total/$t,2)*100; else $v=0; $dis=array(name=$rowtask_tpye,total=$rowsumm1,v=$v); $len_dis=count($dis); for($i=0;$iset_values($dis_value); $chart = new open_flash_chart(); $chart-set_title( $title ); $chart-add_element( $pie ); $chart-x_axis = null; $chart-bg_colour = ( #FFFFFF ); echo $chart-toPrettyString(); ?index 部分：（索引）：?php/$url_back = http:/.$_SERVER HTTP_HOST.$_SERVERPHP_SELF;/$_SESSIONurlback = $url_back;if (!function_exists(GetSQLValueString) function GetSQLValueString($theValue, $theType, $theDefinedValue = , $theNotDefinedValue = ) if (PHP_VERSION WSS - !- function TuneHeight() var frm = document.getElementById(frame_content); var subWeb = document.frames ? document.framesmain_frame.document : frm.contentDocument; if(frm != null & subWeb != null) frm.height = subWeb.body.scrollHeight; function clickTxt(obj)if(obj.innerHTML = )obj.innerHTML=elseobj.innerHTML=/- $(function()$(.btn).click(function()$(.hideTr).toggle();););function searchtask() document.myform.action= default_task.php ; document.myform.target= main_frame; document.myform.submit(); return true; function exportexcel() document.myform.action= excel.php ; document.myform.target= main_frame; document.myform.submit(); return false; option value= 0) mysql_data_seek($Recordset_project, 0); $row_Recordset_project = mysql_fetch_assoc($Recordset_project); ? option value=