通达OA公共代码php常用检测函数www.zycaihui.com(USER_ID,''".$REMARK."'')";$cursor=exequery($connection,$query);$REMARK="";while($ROW=mysql_fetch_array($cursor)){$USER_ID=$ROW[''USER_ID''];$USER_NAME=$ROW[''USER_NAME''];$DEPT_ID=$ROW[''DEPT_ID''];$query="SELECTDEPT_NAMEfromDEPARTMENTwhereDEPT_ID=''".$DEPT_ID."''";$cursor1=exequery($connection,$query);if($ROW=mysql_fetch_array($cursor1)){$DEPT_NAME=$ROW[''DEPT_NAME''];}$REMARK.="[".$DEPT_NAME."]{$USER_NAME},USER_ID={$USER_ID}
";}if($result===FALSE){message("错误",itask_last_error());button_back();exit();}}}$REMARK=str_replace("''","\\''",$REMARK);$REMARK=str_replace("\\\\''","\\''",$REMARK);$query="insertintoSYS_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="INSERTINTO`SYS_CODE`(`CODE_NO`,`CODE_NAME`,`CODE_ORDER`,`PARENT_NO`,`CODE_FLAG`)VALUES(''".$TYPE."'',''未知类型'',''99'',''SYS_LOG'',''1'');";exequery($connection,$query1);}return$query;}functionaffair_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-dH:i:s",time());$query="SELECTfromAFFAIRwhereUSER_ID=''".$LOGIN_USER_ID."''andBEGIN_TIME<=''{$CUR_TIME}''and(LAST_REMIND<''{$CUR_DATE}''orLAST_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;}elseif($TYPE=="3"&&date("w",time())==$REMIND_DATE){$FLAG=1;}elseif($TYPE=="4"&&date("j",time())==$REMIND_DATE){$FLAG=1;}elseif($TYPE=="5"){$REMIND_ARR=explode("-",$REMIND_DATE);$REMIND_DATE_MON=$REMIND_ARR[0];$REMIND_DATE_DAY=$REMIND_ARR[1];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="updateAFFAIRsetLAST_REMIND=''".$CUR_DATE."''whereAFF_ID=''{$AFF_ID}''";exequery($connection,$query);}}}functionget_code_name($CODE_NO,$PARENT_NO){if($CODE_NO==""||$PARENT_NO==""){return"";}global$connection;$query="SELECTCODE_NAMEfromSYS_CODEwherePARENT_NO=''".$PARENT_NO."''andfind_in_set(CODE_NO,''{$CODE_NO}'')";$cursor=exequery($connection,$query);while($ROW=mysql_fetch_array($cursor)){$CODE_NAME.=$ROW[''CODE_NAME'']."，";}returnsubstr($CODE_NAME,0,-2);}functioncode_list($PARENT_NO,$SELECTED="",$TYPE="D",$FIELD_NAME=""){if($PARENT_NO==""){return;}global$connection;$query="selectCODE_NO,CODE_NAMEfromSYS_CODEwherePARENT_NO=''".$PARENT_NO."''orderbyCODE_ORDER";$cursor=exequery($connection,$query);while($ROW=www.sm136.com($cursor)){$CODE_NO=$ROW[''CODE_NO''];$CODE_NAME=$ROW[''CODE_NAME''];if($TYPE=="D"){$OPTION_STR.="".$CODE_NAME."\n";}elseif($TYPE=="R"){$OPTION_STR.="".$CODE_NAME."\n";}elseif($TYPE=="C"){$OPTION_STR.="".$CODE_NAME."\n";}}return$OPTION_STR;}functionget_code_array($PARENT_NO,$REVERSE=FALSE){$CODE_ARRAY=array();if($PARENT_NO==""){return$CODE_ARRAY;}global$connection;$query="selectCODE_NO,CODE_NAMEfromSYS_CODEwherePARENT_NO=''".$PARENT_NO."''orderbyCODE_ORDER";$cursor=exequery($connection,$query);while($ROW=mysql_fetch_array($cursor)){$CODE_NO=$ROW[''CODE_NO''];$CODE_NAME=$ROW[''CODE_NAME''];if(!$REVERSE){$CODE_ARRAY[$CODE_NO]=$CODE_NAME;}else{$CODE_ARRAY[$CODE_NAME]=$CODE_NO;}}return$CODE_ARRAY;}functionsms_type_url($SMS_TYPE,$CONTENT){switch($SMS_TYPE){case"0":$URL="/general/sms/receive/";return$URL;case"1":$URL="/general/notify/show/";return$URL;case"2":$URL="/general/email/inbox/?BOX_ID=0";return$URL;case"3":$URL="/general/netmeeting/";return$URL;case"4":$URL="/general/salary/report/";return$URL;case"5":$URL="/general/calendar/";return$URL;case"6":if(strstr($CONTENT,"提交")&&strstr($CONTENT,"申请")&&strstr($CONTENT,"请批示")){$URL="/general/attendance/manage/";return$URL;}$URL="/general/attendance/personal/";return$URL;case"7":$URL="/general/workflow/list";return$URL;case"8":$URL="/general/meeting/manage/";return$URL;case"9":if(strstr($CONTENT,"提交")){if(strstr($CONTENT,"申请")){}}if(strstr($CONTENT,"请批示")||strstr($CONTENT,"部门领导")&&strstr($CONTENT,"批准了")){$URL="/general/vehicle/checkup/";return$URL;}if(strstr($CONTENT,"部门审批")){$URL="/general/vehicle/dept_manage/";return$URL;}$URL="/general/vehicle/";return$URL;case"10":$URL="/general/mobile_sms/";return$URL;case"11":$URL="/general/vote/show/";return$URL;case"12":$URL="/general/work_plan/show/";return$URL;case"13":$URL="/general/diary/";return$URL;case"14":$URL="/general/news/show/";return$URL;case"15":$URL="/general/score/submit/";return$URL;case"16":$URL="/general/file_folder/index1.php";return$URL;case"17":$URL="/general/netdisk";return$URL;case"18":$URL="/general/bbs";return$URL;case"20":$URL="/general/file_folder?FILE_SORT=2&SORT_ID=0";return$URL;case"30":$URL="/general/training/manage/show";return$URL;case"31":if(strstr($CONTENT,"批准了")||strstr($CONTENT,"未批准")||strstr($CONTENT,"撤销了")){$URL="/general/training/train/apply/";return$URL;}$URL="/general/training/manage/apply_manage/";return$URL;case"32":$URL="/general/training/train/survey/";return$URL;case"33":$URL="/general/training/train/information/";return$URL;case"34":$URL="/general/training/train/assessment/";return$URL;case"35":$URL="/general/hrms/manage/";}return$URL;}functionavatar_size($AVATAR){global$ROOT_PATH;global$connection;global$AVATAR_WIDTH;global$AVATAR_HEIGHT;$FILENAME=$ROOT_PATH."www.edu800.cn/".$AVATAR.".gif";if(!$AVATAR_WIDTH&&!$AVATAR_HEIGHT){$query="SELECTAVATAR_WIDTH,AVATAR_HEIGHTfromINTERFACE";$cursor=exequery($connection,$query);if($ROW=mysql_fetch_array($cursor)){$AVATAR_WIDTH=$ROW[''AVATAR_WIDTH''];$AVATAR_HEIGHT=$ROW[''AVATAR_HEIGHT''];}}$IMG_ATTR=@getimagesize($FILENAME);if($AVATAR_WIDTH<$IMG_ATTR[0]){$IMG_ATTR[0]=$AVATAR_WIDTH;}if($AVATAR_HEIGHT<$IMG_ATTR[1]){$IMG_ATTR[1]=$AVATAR_HEIGHT;}if($IMG_ATTR[0]<15){$IMG_ATTR[0]=15;}if($IMG_ATTR[1]<15){$IMG_ATTR[1]=15;}return"width=\"".$IMG_ATTR[''0'']."\"height=\"{$IMG_ATTR[''1'']}\"";}functionformat_cvs($STR){$STR=str_replace("\"","",$STR);$STR=str_replace("\n","",$STR);$STR=str_replace("\r","",$STR);$STR=str_replace("''","\\''",$STR);if(strpos($STR,",")===FALSE){return$STR;}$STR="\"".$STR."\"";return$STR;}functionkeyed_str($TXT,$ENCRYPT_KEY){$ENCRYPT_KEY=md5($ENCRYPT_KEY);$CTR=0;$TMP="";$I=0;for(;$I使用内部短信提醒??";}$query="selectfromSMS2_PRIV";$cursor=exequery($connection,$query);if($ROW=mysql_fetch_array($cursor)){$TYPE_PRIV=$ROW[''TYPE_PRIV''];$SMS2_REMIND_PRIV=$ROW[''SMS2_REMIND_PRIV''];}if(find_id($TYPE_PRIV,$SMS_TYPE)&&find_id($SMS2_REMIND_PRIV,$LOGIN_USER_ID)){echo"使用手机短信提醒";}}functionsms_select_remind($SMS_TYPE,$SMS_CHECKED=""){return"手动选择被提醒人员\r\n提醒全部有权限人员
\r\n\r\n\r\n\r\n添加\r\n清空";}functionsms2_select_remind($SMS_TYPE,$SMS_CHECKED=""){global$connection;global$LOGIN_USER_ID;$query="selectfromSMS2_PRIV";$cursor=exequery($connection,$query);if($ROW=mysql_fetch_array($cursor)){$TYPE_PRIV=$ROW[''TYPE_PRIV''];$SMS2_REMIND_PRIV=$ROW[''SMS2_REMIND_PRIV''];}if(find_id($TYPE_PRIV,$SMS_TYPE)&&find_id($SMS2_REMIND_PRIV,$LOGIN_USER_ID)){return"手动选择被提醒人员\r\n提醒全部有权限人员
\r\n\r\n\r\n\r\n添加\r\n清空";}}functionpage_bar($current_start_item,$total_items,$page_size=10,$var_name="start",$script_href=NULL,$direct_print=FALSE){if($current_start_item<0||$total_items<$current_start_item){$current_start_item=0;}if($script_href==NULL){$script_href=$_SERVER[''PHP_SELF''];}if($_SERVER[''QUERY_STRING'']!=""){$script_href.="?".$_SERVER[''QUERY_STRING''];}$script_href=preg_replace("/^(.+)(\\?|&)TOTAL_ITEMS=[^&]+&?(.)\$/i","\$1\$2\$3",$script_href);$script_href=preg_replace("/^(.+)(\\?|&)PAGE_SIZE=[^&]+&?(.)\$/i","\$1\$2\$3",$script_href);$script_href=preg_replace("/^(.+)(\\?|&)".$var_name."=[^&]+&?(.)\$/i","\$1\$2\$3",$script_href);if(substr($script_href,-1)=="&"||substr($script_href,-1)=="?"){$script_href=substr($script_href,0,-1);}$hyphen=strstr($script_href,"?")===FALSE?"?":"&";$num_pages=ceil($total_items/$page_size);$cur_page=floor($current_start_item/$page_size)+1;$result_str.="";$result_str.="\n第".$cur_page."/".$num_pages."页";if($cur_page<=1){$result_str.="\r\n";}else{$result_str.="\r\n";}if($num_pages<=$cur_page){$result_str.="\r\n";}else{$result_str.="\r\n";}$result_str.="转到第页";if($direct_print){echo$result_str;}return$result_str;}functionget_page_size($MODULE,$DEFAULT_SIZE=10){$PARA_ARRAY=get_sys_para("PAGE_BAR_SIZE");$PAGE_SIZE_ARRAY=unserialize($PARA_ARRAY[''PAGE_BAR_SIZE'']);$PAGE_SIZE=intval($PAGE_SIZE_ARRAY[$MODULE]);$PAGE_SIZE=0<$PAGE_SIZE?$PAGE_SIZE:$DEFAULT_SIZE;return$PAGE_SIZE;}functionsend_mail($FROM,$TO,$SUBJECT,$BODY,$SMTP_SERVER,$SMTP_USER,$SMTP_PASS,$SMTP_AUTH=TRUE,$FROM_NAME="通达科技",$REPLY_TO="",$CC="",$BCC="",$ATTACHMENT="",$IS_HTML=TRUE,$SMTP_PORT=25,$SMTPSecure=""){global$ATTACH_PATH2;include_once("inc/phpmailer/www.visa158.com");include_once("inc/utility_file.php");$mail=newPHPMailer();$mail->SetLanguage("zh");$mail->IsSMTP();$mail->Host=$SMTP_SERVER;$mail->Port=$SMTP_PORT;$mail->SMTPAuth=$SMTP_AUTH;$mail->SMTPSecure=$SMTPSecure;$mail->Username=$SMTP_USER;$mail->Password=$SMTP_PASS;$mail->From=$FROM;$mail->FromName=$FROM_NAME;$mail->AddReplyTo($FROM,$FROM_NAME);$mail->WordWrap=50;$mail->IsHTML($IS_HTML);$mail->Subject=$SUBJECT;$mail->Body=$BODY;$mail->AltBody=strip_tags($BODY);$TOK=strtok($TO,",");while($TOK!=""){$mail->AddAddress($TOK);$TOK=strtok(",");}$TOK=strtok($CC,",");while($TOK!=""){$mail->AddCC($TOK);$TOK=strtok(",");}$TOK=strtok($BCC,",");while($TOK!=""){$mail->AddBCC($TOK);$TOK=strtok(",");}$TOK=strtok($ATTACHMENT,"");while($TOK!=""){$FILENAME=substr($TOK,strrpos($TOK,"/")+1);if(strtolower(substr($TOK,0,strlen($ATTACH_PATH2)+strlen(attach_sub_dir())))==strtolower($ATTACH_PATH2).attach_sub_dir()){$FILENAME=substr($FILENAME,strpos($FILENAME,".")+1);}$mail->AddAttachment($TOK,$FILENAME);$TOK=strtok("");}if($mail->Send()){returnTRUE;}return$mail->ErrorInfo;}functionsend_email($LOGIN_USER_ID,$FORM_EMAIL,$TO_EMAIL_STR,$EMAIL_CONTENT,$MAIL_TITLE){global$connection;global$LOGIN_USER_NAME;$query="SELECTfromWEBMAILwhereEMAIL=''".$FORM_EMAIL."''andUSER_ID=''{$LOGIN_USER_ID}''";$cursor=exequery($connection,$query);if($ROW=mysql_fetch_array($cursor)){$POP_SERVER=$ROW[''POP_SERVER''];$SMTP_SERVER=$ROW[''SMTP_SERVER''];$LOGIN_TYPE=$ROW[''LOGIN_TYPE''];$SMTP_PASS=$ROW[''SMTP_PASS''];$SMTP_PORT=$ROW[''SMTP_PORT''];$SMTP_SSL=$ROW[''SMTP_SSL'']=="1"?"ssl":"";$EMAIL_PASS=$ROW[''EMAIL_PASS''];$EMAIL_PASS=decrypt_str($EMAIL_PASS,"webmail");}returnsend_mail($FORM_EMAIL,$TO_EMAIL_STR,$MAIL_TITLE,$EMAIL_CONTENT,$SMTP_SERVER,$FORM_EMAIL,$EMAIL_PASS,TRUE,$LOGIN_USER_NAME,"","","","",TRUE,$SMTP_PORT,$SMTP_SSL);}functionunescape($str){$str=rawurldecode($str);preg_match_all("/(?:%u.{4})|&#x.{4};|&#\\d+;|.+/U",$str,$r);$ar=$r[0];foreach($aras$k=>$v){if(substr($v,0,2)=="%u"){$ar[$k]=iconv("UCS-2",ini_get("default_charset"),pack("H4",substr($v,-4)));}elseif(substr($v,0,3)=="&#x"){$ar[$k]=iconv("UCS-2",ini_get("default_charset"),pack("H4",substr($v,3,-1)));}elseif(substr($v,0,2)=="&#"){$ar[$k]=iconv("UCS-2",ini_get("default_charset"),pack("n",substr($v,2,-1)));}}returnstr_replace("\\\\","\\",join("",$ar));}functionflow_sort_tree($SORT_ID,$SORT_CHOOSE){include_once("inc/utility_org.php");global$connection;global$DEEP_COUNT;global$LOGIN_USER_PRIV;global$LOGIN_DEPT_ID;global$LOGIN_USER_PRIV_OTHER;$query="SELECTfromFLOW_SORTwhereSORT_PARENT=".$SORT_ID."orderbySORT_NO";$cursor=exequery($connection,$query);$OPTION_TEXT="";$DEEP_COUNT1=$DEEP_COUNT;$DEEP_COUNT.="│";$COUNT=0;while($ROW=mysql_fetch_array($cursor)){++$COUNT;$SORT_ID=$ROW[''SORT_ID''];$SORT_NAME=$ROW[''SORT_NAME''];$SORT_PARENT=$ROW[''SORT_PARENT''];$HAVE_CHILD=$ROW[''HAVE_CHILD''];$DEPT_ID=$ROW[''DEPT_ID''];if($LOGIN_USER_PRIV!=1&&!find_id($LOGIN_USER_PRIV_OTHER,1)||$DEPT_ID!=$LOGIN_DEPT_ID&&$DEPT_ID!=0&&!is_dept_parent($LOGIN_DEPT_ID,$DEPT_ID)){}else{$SORT_NAME=htmlspecialchars($SORT_NAME);if($COUNT==mysql_num_rows($cursor)){$DEEP_COUNT=substr($DEEP_COUNT,0,-2)."";}if($HAVE_CHILD==1){$OPTION_TEXT_CHILD=flow_sort_tree($SORT_ID,$SORT_CHOOSE);}$OPTION_TEXT.="".$DEEP_COUNT1."└".$SORT_NAME."\n";}else{$OPTION_TEXT.="value=".$SORT_ID.">".$DEEP_COUNT1."├".$SORT_NAME."\n";}if(!($HAVE_CHILD!=0)&&!($OPTION_TEXT_CHILD!="")){$OPTION_TEXT.=$OPTION_TEXT_CHILD;}}}$DEEP_COUNT=$DEEP_COUNT1;return$OPTION_TEXT;}functioncheck_priv($PRIV_STR){global$LOGIN_DEPT_ID;global$LOGIN_USER_PRIV;global$LOGIN_USER_ID;$PRIV_ARRAY=explode("|",$PRIV_STR);if($PRIV_ARRAY[0]=="ALL_DEPT"||find_id($PRIV_ARRAY[0],$LOGIN_DEPT_ID)||find_id($PRIV_ARRAY[1],$LOGIN_USER_PRIV)||find_id($PRIV_ARRAY[2],$LOGIN_USER_ID)){returnTRUE;}returnFALSE;}functionCSV2Array($content,$title=array(),$delimiter=",",$enclosure="\"",$optional=1){$content=trim($content);$content=str_replace("\r","",$content);$csv_array=array();$expr_line="/\\n(?=(?:[^".$enclosure."]".$enclosure."[^".$enclosure."]".$enclosure.")(?![^".$enclosure."]".$enclosure."))/";$expr_field="/".$delimiter."(?=(?:[^".$enclosure."]".$enclosure."[^".$enclosure."]".$enclosure.")(?![^".$enclosure."]".$enclosure."))/";$lines=preg_split($expr_line,trim($content));foreach($linesas$line){$fields=preg_split($expr_field,trim($line));$csv_array[]=preg_replace(array("/\"(.)\"\$/s","/\"\"/s"),array("\$1","\""),$fields);}if(!is_array($title)&&count($title)==0||count($csv_array)==0){return$csv_array;}$field_map=array();while(list($key,$value)=each(&$title)){if(($index=array_search($key,$csv_array[0]))!==FALSE){$field_map[$value]=$index;}}$lines=array();$i=1;for(;$i3";case"RIGHT":return"4";case"UP":return"5";case"DOWN":return"6";default:}else{switch(strtoupper($DIRECTION)){case"LEFT":return"";case"RIGHT":return"";case"UP":return"";case"DOWN":return"";}}}}functionnetMatch($network,$ip){$network=trim($network);$ip=trim($ip);$d=strpos($network,"-");if($d===FALSE){$ip_arr=explode("/",$network);if(!preg_match("@\\d\\.\\d\\.\\d\\.\\d@",$ip_arr[0],$matches)){$ip_arr[0].=".0";}$network_long=ip2long($ip_arr[0]);$x=ip2long($ip_arr[1]);$mask=long2ip($x)==$ip_arr[1]?$x:-1<<32-$ip_arr[1];$ip_long=ip2long($ip);[exceptionoccured]================================Exceptioncode[C0000005]Compiler[003B5E50]Executor[003B6358]OpArray[00A5FD78]FileClassFunctionStack[00145DE8]Step[7]Offset[60]LastOffset[94]60IS_EQUAL[-]0[0]$Tmp_0-$Tmp_1-$Tmp_2================================?>
|
|
