界面控制 */ //包含配置文件 require_once("./initdb.php"); /** *@目的：留言入口表单显示 *@参数： $ArrInterFace => 界面控制；$DB => 数据库操作类实例,$Table=>数据表配置数组,$mailtype=>信件类型 *@返回： */ function InputForm($DB) { global $ArrInterFace,$Table,$mailtype,$todepid,$tousrid; ?> ' width='' align='center'> '>"; } ?> '>'>'>'>'>'>'>'>'>'>'>'>'>

信息提交
发送信箱：	"; selectrelative($DB, "todepid", "tousrid", $todepid, $tousrid, '140'); echo "
电子邮件：	*
您的姓名：	*
性别年龄：	性别：年龄：
证件号码：
从事职业：
联系地址：
联系电话：	*
信件属性：	信件类型：反映类型：信件等级：
相关附件：
信件主题：	*
公开该信：
信件内容：

界面控制；$DB => 数据库操作类实例,$fdattach =>附件,$Foldname =>附件文件夹 *@返回： */ function InsertData($DB) { global $HTTP_POST_VARS,$Table,$ArrInterFace,$fdattach,$Foldname,$fdattach_name,$todepid,$tousrid; while ( list($key, $value) = each($HTTP_POST_VARS) ) { $$key = $value; } //邮件重复检查 $SqlExist = "SELECT id FROM ".$Table['guestbook_info']." WHERE fdname='".$fdname."' AND fdtitle='".$fdtitle."'"; $ResExist = $DB->sql_query($SqlExist); $NumExist = $DB->sql_numrows($ResExist); if($NumExist>0) { ?> "none")&&($fdattach <> "")) { $attachsize = GetFileSizeOnly($fdattach); $maxsize = (intval($ArrInterFace['maxattach'])>0) ? intval($ArrInterFace['maxattach']) : 1024; if( $attachsize > ($maxsize*1024) ) { ?> sql_query($SqlChk); if(!$DB->sql_fetchrow($ResChk)) { if(copy($fdattach,"./".$Foldname."/".$filename)) { $filename = $filename; } else { $filename = ""; } }//end if(!$DB->sql_fetchrow($ResChk)) $DB->sql_freeresult(); }//end if($fdattach['error'] == 0) $fddate = date("Y-m-d H:i:s"); //信件编号 $idcode = getidcode($DB); srand((double)microtime()*1000000); //$randval = rand(); $randval = mt_rand(100000,999999); //if($fdishidden =="0") //{ $secret = $randval; //} //else //{ // $secret = "0"; // } //增加了发送到对应的部门的功能 $SqlInsert = "INSERT INTO ".$Table['guestbook_info']." ( idcode ,secret ,fdemail,fdname,fdsex,fdaddress,fdtel,fdtitle,fdishidden,fdischeck,fdcontent,fddate,fdage,fdvocationid,fdtypeid,fdforwhatid,fduserid,fdattach,fddegreeid,fdisaudit,department) VALUES ('".$idcode."','".$secret."','".$fdemail."','".$fdname."','".$fdsex."','".$fdaddress."','".$fdtel."','".$fdtitle."','".$fdishidden."','0','".$fdcontent."','".$fddate."',".intval($fdage).",".intval($fdvocationid).",".intval($fdtypeid).",".intval($fdforwhatid).",'".$fduserid."','".$filename."',".intval($fddegreeid).",'0',".$todepid.")"; if(CFG_DBTYPE=="oracle") { $SqlInsert = "INSERT INTO ".$Table['guestbook_info']." (id,fdemail,fdname,fdsex,fdaddress,fdtel,fdtitle,fdishidden,fdischeck,fdcontent,fddate,fdage,fdvocationid,fdtypeid,fdforwhatid,fduserid,fdattach,fddegreeid,fdisaudit) VALUES (".$Table['guestbook_info']."_id.NEXTVAL,'".$fdemail."','".$fdname."','".$fdsex."','".$fdaddress."','".$fdtel."','".$fdtitle."','".$fdishidden."','0','".$fdcontent."','".$fddate."',".intval($fdage).",".intval($fdvocationid).",".intval($fdtypeid).",".intval($fdforwhatid).",'".$fduserid."','".$filename."',".intval($fddegreeid).",".intval($ArrInterFace['isaudit']).")"; } $DB->sql_query($SqlInsert); $DB->sql_freeresult(); //是否自动回执 if(intval($ArrInterFace['isautorep'])==1) { //还要发邮件 //if($fdemail&&CFG_OSTYPE=="linux") if($fdemail) { sendrepmail($fdemail,$fdname,""); } ?> sql_query($SqlId); $RowId = $DB->sql_fetchrow($ResId); $returnid = $RowId['id']; if( intval($returnid)>0 ) { if ( $ArrInterFace['islistsub'] ) { $shareid = $todepid; $sharetype = 0; if ( intval($tousrid) ){ $shareid = $tousrid; $sharetype = 1; } $SqlInsert = "INSERT INTO ".$Table['guestbook_share']." (infoid,shareid,sharetype) VALUES (".intval($returnid).",".$shareid.",".$sharetype.")"; if(CFG_DBTYPE=="oracle") { $SqlInsert = "INSERT INTO ".$Table['guestbook_share']." (id,infoid,shareid,sharetype) VALUES (".$Table['guestbook_share']."_id.NEXTVAL,".intval($returnid).",".$shareid.",".$sharetype.")"; } $DB->sql_query($SqlInsert); $DB->sql_freeresult(); } ?> sql_query($SqlCodeId); $RowId = $DB->sql_fetchrow($ResId); $len = strlen((string)$RowId[0]); $datacode = ""; if($len<4) { for($i=0;$i<4-$len;$i++) { $datacode .= "0"; } $datacode = $datacode.(string)($RowId[0]+1); } $returncodeid =(string)$fddate1.(string)$datacode; return $returncodeid; } //部门人员列表 function userlist($DB) { global $Table,$ArrInterFace; $sql = "SELECT * FROM ".$Table['guestbook_department']." ORDER BY orderid DESC,id"; $result = $DB->sql_query($sql); // 列数 $td = 5; echo ""; echo ""; $i = 0; $td_width = $ArrInterFace['tablewidth']/$td; //平均分配列宽 while( $row = $DB->sql_fetchrow($result) ) { if ( $i%$td==0 ){ $bgcolor = ($i%$td) ? "girdbgcolor1" : "girdbgcolor"; echo ""; } $i++; /* //查找用户和职务 $sql1 = "SELECT a.id,a.fdlogin,b.name FROM ".$Table['guestbook_user']." a,".$Table['guestbook_post']." b WHERE a.departmentid=".intval($row['id'])." AND a.postid=b.id ORDER BY a.id"; $result1 = $DB->sql_query($sql1); $memberlist = ""; while( $row1 = $DB->sql_fetchrow($result1) ){ $memberlist .= ""; } if ( $memberlist ){ $memberlist = "

信箱列表
".$row1['name']."	".$row1['fdlogin']."

".$memberlist."

"; } */ echo "".$row['name']."
$memberlist"; if ( $i%$td==0 ) echo ""; } if ( $i%$td!=0 ) { for($m=0;$m<($td-$i%$td);$m++) echo " "; echo ""; } echo ""; } //包含头文件 require_once("./templates/head.htm"); //包含菜单文件 require_once("./templates/menu.htm"); switch ($func) { case "InputForm": InputForm($DB); //留言输入表单 break; case "Insert": InsertData($DB); //留言添加入库 break; default: if ( $ArrInterFace['islistsub'] ) userlist($DB); else InputForm($DB); //留言输入表单 } //包含尾文件 require_once("./templates/foot.htm"); ?>