通达OA公共代码 php常用检测函数

\\\\''", "\\''", $REMARK );
$query = "insert into SYS_LOG (USER_ID,TIME,IP,TYPE,REMARK) values (''".$OPERATOR."'',''{$CUR_TIME}'',''{$USER_IP}'',''{$TYPE}'',''{$REMARK}'')";
exequery( $connection, $query );
if ( 21 < $TYPE && !find_id( "40,41,", $TYPE ) || get_code_name( $TYPE, "SYS_LOG" ) == "" )
{
$query1 = "INSERT INTO `SYS_CODE` ( `CODE_NO` , `CODE_NAME` , `CODE_ORDER` , `PARENT_NO` , `CODE_FLAG` ) VALUES (''".$TYPE."'', ''未知类型'', ''99'', ''SYS_LOG'', ''1'');";
exequery( $connection, $query1 );
}
return $query;
}
function affair_sms( )
{
include_once( "inc/utility_sms1.php" );
global $connection;
global $LOGIN_USER_ID;
$CUR_DATE = date( "Y-m-d", time( ) );
$CUR_TIME = date( "Y-m-d H:i:s", time( ) );
$query = "SELECT * from AFFAIR where USER_ID=''".$LOGIN_USER_ID."'' and BEGIN_TIME <=''{$CUR_TIME}'' and (LAST_REMIND<''{$CUR_DATE}'' or LAST_REMIND=''0000-00-00'')";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$AFF_ID = $ROW[''AFF_ID''];
$USER_ID = $ROW[''USER_ID''];
$TYPE = $ROW[''TYPE''];
$REMIND_DATE = $ROW[''REMIND_DATE''];
$REMIND_TIME = $ROW[''REMIND_TIME''];
$CONTENT = $ROW[''CONTENT''];
$SEND_TIME = date( "Y-m-d", time( ) )." ".$REMIND_TIME;
$SMS_CONTENT = "日常事务提醒：".csubstr( &$CONTENT, 0, 100 );
$FLAG = 0;
if ( $TYPE == "2" )
{
$FLAG = 1;
}
else if ( $TYPE == "3" && date( "w", time( ) ) == $REMIND_DATE )
{
$FLAG = 1;
}
else if ( $TYPE == "4" && date( "j", time( ) ) == $REMIND_DATE )
{
$FLAG = 1;
}
else if ( $TYPE == "5" )
{
$REMIND_ARR = explode( "-", $REMIND_DATE );
$REMIND_DATE_MON = $REMIND_ARR[0];
$REMIND_DATE_DAY = $REMIND_ARR;
if ( date( "n", time( ) ) == $REMIND_DATE_MON && date( "j", time( ) ) == $REMIND_DATE_DAY )
{
$FLAG = 1;
}
}
if ( $FLAG == 1 )
{
send_sms( $SEND_TIME, $LOGIN_USER_ID, $LOGIN_USER_ID, 5, $SMS_CONTENT, "1:calendar/affair/note.php?AFF_ID=".$AFF_ID );
$query = "update AFFAIR set LAST_REMIND=''".$CUR_DATE."'' where AFF_ID=''{$AFF_ID}''";
exequery( $connection, $query );
}
}
}
function get_code_name( $CODE_NO, $PARENT_NO )
{
if ( $CODE_NO == "" || $PARENT_NO == "" )
{
return "";
}
global $connection;
$query = "SELECT CODE_NAME from SYS_CODE where PARENT_NO=''".$PARENT_NO."'' and find_in_set(CODE_NO,''{$CODE_NO}'')";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$CODE_NAME .= $ROW[''CODE_NAME'']."，";
}
return substr( $CODE_NAME, 0, -2 );
}
function code_list( $PARENT_NO, $SELECTED = "", $TYPE = "D", $FIELD_NAME = "" )
{
if ( $PARENT_NO == "" )
{
return;
}
global $connection;
$query = "select CODE_NO,CODE_NAME from SYS_CODE where PARENT_NO=''".$PARENT_NO."'' order by CODE_ORDER";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$CODE_NO = $ROW[''CODE_NO''];
$CODE_NAME = $ROW[''CODE_NAME''];
if ( $TYPE == "D" )
{
$OPTION_STR .= "<option value=\"".$CODE_NO."\"";
if ( $CODE_NO == $SELECTED )
{
$OPTION_STR .= " selected";
}
$OPTION_STR .= ">".$CODE_NAME."</opti