Backend Development
PHP Tutorial
Tongda OA2015 version workflow plug-in and list control data analysis
Tongda OA2015 version workflow plug-in and list control data analysis
Data analysis of Tongda OA workflow plug-in and list control:
The reference code is as follows:
<?
include_once("inc/auth.inc.php");
include_once("inc/utility_org.php" );
$HTML_PAGE_TITLE = _("工作流插件测试");
include_once("inc/header.inc.php");
/*
* author: 孙忠海
* 15645091570
* QQ:1027167227
*/
//$FLOW_ID=341;
//$RUN_ID=69222;
//$sql="select * from flow_data_".$FLOW_ID." where run_id=".$RUN_ID;
//$cur_sql=exequery(TD::conn(),$sql);
?>
<body class="bodycolor" style="font-size:12px" topmargin="5">
<?
echo $_SESSION["LOGIN_USER_ID"]."<br>";
$query="select * from x_hr_code where parent_no='gangweizhiwu' order by code_no asc";
$cursor=exequery(TD::conn(),$query);
while($row=mysql_fetch_array($cursor)){
echo $row["CODE_NAME"].",";
}
echo "<hr>";
$query="select * from x_hr_code where parent_no='gangweidengji' order by code_no asc";
$cursor=exequery(TD::conn(),$query);
while($row=mysql_fetch_array($cursor)){
echo $row["CODE_NAME"].",";
}
echo "<hr>";
$query="select * from x_hr_code where parent_no='gangji' order by code_no asc";
$cursor=exequery(TD::conn(),$query);
while($row=mysql_fetch_array($cursor)){
echo $row["CODE_NAME"].",";
}
echo "<hr>";
$query2="select data_57 from flow_data_316 where run_id=44436 limit 1";
$cursor2=exequery(TD::conn(),$query2);
while($row2=mysql_fetch_array($cursor2)){
$mingxi=$row2['data_57'];
}
echo $mingxi."<br>";
$mingxi=str_replace("\r",",",$mingxi);//\r是回车 占用两个字符，数据表data_3中存储的是回车，而不是空格，将回车替换为“，”逗号；
echo $mingxi."<br>";
$mingxi=substr($mingxi,0,-2);//去掉最后的两个字符，包括逗号
echo $mingxi."<br>";
$arr=explode(",",$mingxi);//使用，逗号拆分，将列表中的每条记录分开`
print_r($arr);//
echo "<br>";
$count=count($arr);//有多少条记录
echo $count."<br>";
for($i=0;$i<$count;$i++){
$update_str="";
$bianhao="";
$ganweizhiwu="";
$gangweidengji="";
$gangji="";
$arr[$i]=substr($arr[$i],0,-1);//去掉最后一个字符`substr($arr[$i],-1)就可以或得到这个点
echo $arr[$i]."<br>";
$arr[$i]=explode(""`,$arr[$i]);//拆分成二维数组
print_r($arr[$i]);
$bianhao=$arr[$i][1];
$gangweizhiwu=GET_CODE_NO($arr[$i][4],"gangweizhiwu");//岗位名称
$gangweidengji=GET_CODE_NO($arr[$i][5],"gangweidengji");//岗位等级
$gangji=GET_CODE_NO($arr[$i][6],"gangji");//岗级
echo "<br>";
echo $bianhao."----".$gangweizhiwu."----".$gangweidengji."-----".$gangji."---";
echo "<hr>";
if($gangweizhiwu!=""){
$update_str=" gangweizhiwu=".$gangweizhiwu.",";
}
if($gangweidengji!=""){
$update_str.=" gangweidengji=".$gangweidengji.",";
}
if($gangji!=""){
$update_str.=" gangji=".$gangji.",";
}
if($bianhao!=""){
$update_str.=" STAFF_NO=".$bianhao." ";
$query3="update x_hr_staff_info set ".$update_str." where STAFF_NO=".$bianhao." " ;
echo $query3."<br>";
exequery(TD::conn(),$query3);
}
}
function GET_CODE_NO( $CODE_NAME, $PARENT_NO )
{
if ( $CODE_NAME == "" || $PARENT_NO == "" )
{
return "";
}
$query = "SELECT CODE_NO from X_HR_CODE where PARENT_NO='".$PARENT_NO."' and CODE_NAME='$CODE_NAME'";
$cursor = exequery( TD::conn( ), $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$CODE_NO = $ROW['CODE_NO'];
}
return $CODE_NO;
}
?>
</body></html>The above introduces the data analysis of Tongda OA2015 version of workflow plug-in and list control, including the content. I hope you are interested in PHP tutorials. Friends help.
Related articles:
PHP workflow custom form solution
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
PyCharm Beginner's Guide: Comprehensive understanding of plug-in installation!
Feb 25, 2024 pm 11:57 PM
PyCharm is a powerful and popular Python integrated development environment (IDE) that provides a wealth of functions and tools so that developers can write code more efficiently. The plug-in mechanism of PyCharm is a powerful tool for extending its functions. By installing different plug-ins, various functions and customized features can be added to PyCharm. Therefore, it is crucial for newbies to PyCharm to understand and be proficient in installing plug-ins. This article will give you a detailed introduction to the complete installation of PyCharm plug-in.
![Error loading plugin in Illustrator [Fixed]](https://img.php.cn/upload/article/000/465/014/170831522770626.jpg?x-oss-process=image/resize,m_fill,h_207,w_330)
Error loading plugin in Illustrator [Fixed]
Feb 19, 2024 pm 12:00 PM
When launching Adobe Illustrator, does a message about an error loading the plug-in pop up? Some Illustrator users have encountered this error when opening the application. The message is followed by a list of problematic plugins. This error message indicates that there is a problem with the installed plug-in, but it may also be caused by other reasons such as a damaged Visual C++ DLL file or a damaged preference file. If you encounter this error, we will guide you in this article to fix the problem, so continue reading below. Error loading plug-in in Illustrator If you receive an "Error loading plug-in" error message when trying to launch Adobe Illustrator, you can use the following: As an administrator
Share three solutions to why Edge browser does not support this plug-in
Mar 13, 2024 pm 04:34 PM
When users use the Edge browser, they may add some plug-ins to meet more of their needs. But when adding a plug-in, it shows that this plug-in is not supported. How to solve this problem? Today, the editor will share with you three solutions. Come and try it. Method 1: Try using another browser. Method 2: The Flash Player on the browser may be out of date or missing, causing the plug-in to be unsupported. You can download the latest version from the official website. Method 3: Press the "Ctrl+Shift+Delete" keys at the same time. Click "Clear Data" and reopen the browser.
What is the Chrome plug-in extension installation directory?
Mar 08, 2024 am 08:55 AM
What is the Chrome plug-in extension installation directory? Under normal circumstances, the default installation directory of Chrome plug-in extensions is as follows: 1. The default installation directory location of chrome plug-ins in windowsxp: C:\DocumentsandSettings\username\LocalSettings\ApplicationData\Google\Chrome\UserData\Default\Extensions2. chrome in windows7 The default installation directory location of the plug-in: C:\Users\username\AppData\Local\Google\Chrome\User
How to use a WordPress plugin to implement instant location functionality
Sep 05, 2023 pm 04:51 PM
How to use WordPress plug-ins to achieve instant location functionality With the popularity of mobile devices, more and more websites are beginning to provide geolocation-based services. In WordPress websites, we can use plug-ins to implement instant positioning functions and provide visitors with services related to their geographical location. 1. Choose the right plug-in. There are many plug-ins that provide geolocation services in the WordPress plug-in library to choose from. Depending on the needs and requirements, choosing the right plug-in is the key to achieving instant positioning functionality. Here are a few
How to add WeChat mini program functionality to WordPress plug-in
Sep 06, 2023 am 09:03 AM
How to Add WeChat Mini Program Functions to WordPress Plugins With the popularity and popularity of WeChat mini programs, more and more websites and applications are beginning to consider integrating them with WeChat mini programs. For websites that use WordPress as their content management system, adding the WeChat applet function can provide users with a more convenient access experience and more functional choices. This article will introduce how to add WeChat mini program functionality to WordPress plug-in. Step 1: Register a WeChat mini program account. First, you need to open the WeChat app
Does PyCharm Community Edition support enough plugins?
Feb 20, 2024 pm 04:42 PM
Does PyCharm Community Edition support enough plugins? Need specific code examples As the Python language becomes more and more widely used in the field of software development, PyCharm, as a professional Python integrated development environment (IDE), is favored by developers. PyCharm is divided into two versions: professional version and community version. The community version is provided for free, but its plug-in support is limited compared to the professional version. So the question is, does PyCharm Community Edition support enough plug-ins? This article will use specific code examples to
How to add online ordering functionality to WordPress plugin
Sep 05, 2023 pm 03:42 PM
How to Add Online Ordering Function to WordPress Plugin In today’s digital era, many restaurants and coffee shops have chosen to move the ordering process online to meet the needs of customers. WordPress is a widely used content management system (CMS), and many businesses are using WordPress to build their websites. This article will introduce how to add online ordering functionality to WordPress plug-in and provide corresponding code examples. Step 1: Choose the Right Plugin First, we need to create a custom plugin in WordPress
