📄 do.php
字号:
<?php
include_once( "inc/auth.php" );
ob_end_clean( );
$f = $_REQUEST['f'];
$userid = $_SESSION['LOGIN_USER_ID'];
switch ( $f )
{
case "create" :
$BLOCK_TYPE = $_REQUEST['blocktype'];
switch ( $BLOCK_TYPE )
{
case -1 :
$BLOCK_TITLE = "新闻中心";
break;
case -2 :
$BLOCK_TITLE = "公告中心";
break;
case 3 :
$BLOCK_TITLE = "待办流程";
break;
case 27 :
$BLOCK_TITLE = "今日常务";
break;
case 13 :
$BLOCK_TITLE = "最近短信";
break;
case 12 :
$BLOCK_TITLE = "最近邮件";
break;
case 37 :
$BLOCK_TITLE = "今日会议";
break;
case 40 :
$BLOCK_TITLE = "待批会议";
break;
case 260 :
$BLOCK_TITLE = "RSS资讯";
break;
case 45 :
$BLOCK_TITLE = "最新客户";
break;
case 46 :
$BLOCK_TITLE = "最新产品";
break;
case 231 :
$BLOCK_TITLE = "车辆维护";
break;
case 250 :
$BLOCK_TITLE = "投票调查";
break;
case -3 :
$BLOCK_TITLE = "快捷运行";
break;
case 30 :
$BLOCK_TITLE = "最近计划";
break;
case 111 :
$BLOCK_TITLE = "我的协作";
break;
case 7 :
$BLOCK_TITLE = "个人文档";
break;
case 8 :
$BLOCK_TITLE = "公共文档";
break;
case 16 :
$BLOCK_TITLE = "人事工作";
break;
case -4 :
$BLOCK_TITLE = "天气预报";
}
$BLOCK_IMG = "box.gif";
$BLOCK_TPL = "gray";
$BLOCK_LAYOUT = $_REQUEST['blocklayout'];
$BLOCK_ROW = 5;
$SUBJECT_LENGTH = 25;
$IS_SHOW_DATE = 1;
$IS_SHOW_CREATOR = 1;
$BLOCK_EFFECT = 1;
$COMMON_ID = 0;
$COMMON_STR = "上海";
$BLOCK_ORDER = 0;
$query = "INSERT INTO `index_block` (`USER_ID` ,`BLOCK_TYPE` ,`BLOCK_TITLE` ,`BLOCK_ROW` ,`SUBJECT_LENGTH` ,`IS_SHOW_DATE` ,`BLOCK_TPL` ,`IS_SHOW_CREATOR` ,`BLOCK_EFFECT` ,`COMMON_ID`,`COMMON_STR` ,`BLOCK_IMG` ,`BLOCK_LAYOUT` ,`BLOCK_ORDER` )VALUES ('{$userid} ', '{$BLOCK_TYPE}', '{$BLOCK_TITLE}', '{$BLOCK_ROW}', '{$SUBJECT_LENGTH}', '{$IS_SHOW_DATE}', '{$BLOCK_TPL}', '{$IS_SHOW_CREATOR}', '{$BLOCK_EFFECT}', '{$COMMON_ID}','{$COMMON_STR}', '{$BLOCK_IMG}' , '{$BLOCK_LAYOUT}', '{$BLOCK_ORDER}')";
$rs = exequery( $connection, $query );
$blockid = mysql_insert_id( );
echo $blockid;
break;
case "readblock" :
$blockid = $_REQUEST['blockid'];
$sql = "SELECT * FROM index_block WHERE BLOCK_ID=".$blockid;
$rs = exequery( $connection, $sql );
$row = mysql_fetch_array( $rs );
$array_xml[0]['blockid'] = $row['BLOCK_ID'];
$array_xml[0]['blockimg'] = $row['BLOCK_IMG'];
$array_xml[0]['blocktpl'] = $row['BLOCK_TPL'];
$array_xml[0]['blocktitle'] = $row['BLOCK_TITLE'];
header( "Expires: Mon, 26 Jul 1997 05:00:00 GMT" );
header( "Cache-Control: no-cache, must-revalidate" );
header( "Pragma: no-cache" );
header( "Content-Type: text/xml" );
echo "<channel>";
while ( list( $key, $var ) = each( $array_xml ) )
{
if ( $var['blockid'] != "" )
{
echo "<item>";
echo "<blockid>".$var['blockid']."</blockid>";
echo "<blockimg>".$var['blockimg']."</blockimg>";
echo "<blocktpl>".$var['blocktpl']."</blocktpl>";
echo "<blocktitle>".iconv( "GB2312", "UTF-8", $var['blocktitle'] )."</blocktitle>";
echo "</item>";
}
}
echo "</channel>";
exit( );
case "delete" :
$sql = "DELETE FROM index_block WHERE BLOCK_ID=".$_REQUEST['blockid'];
exequery( $connection, $sql );
echo "1";
exit( );
case "savetpl" :
$BLOCK_TPL = $_REQUEST['blocktpl'];
$sql = "UPDATE index_block SET BLOCK_TPL='".$BLOCK_TPL."' WHERE BLOCK_ID=".$_REQUEST['blockid'];
exequery( $connection, $sql );
echo "1";
exit( );
case "saveicon" :
$BLOCK_IMG = $_REQUEST['blockimg'];
$sql = "UPDATE index_block SET BLOCK_IMG='".$blockimg."' WHERE BLOCK_ID=".$_REQUEST['blockid'];
exequery( $connection, $sql );
echo $sql;
exit( );
case "update" :
$blockid = $_REQUEST['blockid'];
$blocktype = $_REQUEST['blocktype'];
$blocktitle = iconv( "UTF-8", "GB2312", $_REQUEST['blocktitle'] );
$blockrow = $_REQUEST['blockrow'];
$subjectlength = $_REQUEST['subjectlength'];
$isshowdate = $_REQUEST['isshowdate'];
$blocktpl = $_REQUEST['blocktpl'];
$isshowcreator = $_REQUEST['isshowcreator'];
$blockeffect = $_REQUEST['blockeffect'];
$commonid = $_REQUEST['commonid'];
$commonstr = iconv( "UTF-8", "GB2312", $_REQUEST['commonstr'] );
$query = " \r\n\t\t\t\tUPDATE index_block \r\n\t\t\t\t\tSET BLOCK_TITLE = '{$blocktitle}',\r\n\t\t\t\t\tSUBJECT_LENGTH = '{$subjectlength}',\r\n\t\t\t\t\tIS_SHOW_DATE = '{$isshowdate}',\r\n\t\t\t\t\tBLOCK_ROW = '{$blockrow}',\r\n\t\t\t\t\tBLOCK_TPL = '{$blocktpl}',\r\n\t\t\t\t\tIS_SHOW_CREATOR = '{$isshowcreator}',\r\n\t\t\t\t\tBLOCK_EFFECT = '{$blockeffect}',\r\n\t\t\t\t\tCOMMON_ID = '{$commonid}',\r\n\t\t\t\t\tCOMMON_STR = '{$commonstr}' \r\n\t\t\t\tWHERE BLOCK_ID ={$blockid} ";
exequery( $connection, $query );
break;
exit( );
case "order" :
$position_str = $_REQUEST['str'];
$position_str = preg_replace( "/drag_/", "", $position_str );
$position_str = preg_replace( "/col_/", "", $position_str );
$position_str = preg_replace( "/,;/", ";", $position_str );
$position_str = substr( $position_str, 0, -1 );
$array_col = explode( ";", $position_str );
$i = 0;
for ( ; $i < count( $array_col ); ++$i )
{
$array_all = explode( ":", $array_col[$i] );
$blocklayout = $array_all[0];
$array_block = explode( ",", $array_all[1] );
$j = 0;
for ( ; $j < count( $array_block ); ++$j )
{
$blockid = $array_block[$j];
$blockorder = $j + 1;
$query = "UPDATE `index_block` SET `BLOCK_LAYOUT` = '{$blocklayout}',`BLOCK_ORDER` = '{$blockorder}' WHERE `BLOCK_ID`={$blockid} ";
exequery( $connection, $query );
continue;
continue;
break;
exit( );
}
}
case "changelayout" :
$layouttype = $_REQUEST['layouttype'];
$query = "SELECT LAYOUT_TYPE FROM index_layout WHERE USER_ID='".$userid."'";
$rs = exequery( $connection, $query );
$row = mysql_fetch_array( $rs );
$layouttype_old = $row['LAYOUT_TYPE'];
$sql = "SELECT MAX(BLOCK_ORDER) AS cnt FROM index_block WHERE USER_ID='".$userid."' AND BLOCK_LAYOUT=1";
$rs = exequery( $connection, $sql );
$row = mysql_fetch_array( $rs );
$maxorder = $row['cnt'] + 1;
$sql = "UPDATE index_layout SET LAYOUT_TYPE=".$layouttype." WHERE USER_ID='".$userid."'";
echo $sql;
exequery( $connection, $sql );
if ( $layouttype == 1 )
{
$sql = "\r\n\t\t\t\t\tUPDATE index_block SET BLOCK_LAYOUT=1,BLOCK_ORDER=".$maxorder." \r\n\t\t\t\t\t\tWHERE (BLOCK_LAYOUT=2 || BLOCK_LAYOUT=3) AND USER_ID='".$userid."'\r\n\t\t\t\t\t";
}
if ( $layouttype == 2 )
{
$sql = "\r\n\t\t\t\t\tUPDATE index_block SET BLOCK_LAYOUT=1,BLOCK_ORDER=".$maxorder." \r\n\t\t\t\t\t\tWHERE (BLOCK_LAYOUT=3) AND USER_ID='".$userid."'\r\n\t\t\t\t\t";
}
exequery( $connection, $sql );
break;
case "changewidth" :
$layout1 = $_REQUEST['layout1'];
$layout2 = $_REQUEST['layout2'];
$layout3 = $_REQUEST['layout3'];
$query = "UPDATE `index_layout` SET LAYOUT_1={$layout1},LAYOUT_2={$layout2},LAYOUT_3={$layout3} WHERE USER_ID='".$userid."' ";
$rc = exequery( $connection, $query );
}
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -