📄 insert.php
字号:
<?php
include_once( "../auth1.php" );
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "../utility.php" );
echo "\r\n<html>\r\n<head>\r\n<title></title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n";
$tempfile = $ID_TABLEFILED."_PROPOSER";
$$tempfile = $_REQUEST['ID_USERNAME'];
$connection = openconnection( );
$query = "select TABLE_NAME from IK_TABLE where TABLE_ID={$TABLE_ID}";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$TABLE_NAME = $ROW['TABLE_NAME'];
}
$FLAG = false;
$FIELD_NAME = "";
$FIELD_VALUE = "";
$NAME_STR = "";
$VALUE_STR = "'";
$FIELD_NAME_STR_ARRAY = explode( ",", $FIELD_NAME_STR );
$FIELD_NAME_STR_NUM = sizeof( $FIELD_NAME_STR_ARRAY );
$I = 0;
for ( ; $I < $FIELD_NAME_STR_NUM; ++$I )
{
$FIELD_NAME = $FIELD_NAME_STR_ARRAY[$I];
$NAME_STR .= $FIELD_NAME.",";
$FIELD_VALUE = $$FIELD_NAME_STR_ARRAY[$I];
$query = "select * from IK_FIELD where FIELD_NAME='{$FIELD_NAME}' and TABLE_ID={$TABLE_ID}";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$FIELD_DESC = $ROW['FIELD_DESC'];
$FIELD_TYPE = $ROW['FIELD_TYPE'];
$FIELD_AUTOVALUE = $ROW['FIELD_AUTOVALUE'];
$FIELD_INTERFACE_TYPE = $ROW['FIELD_INTERFACE_TYPE'];
}
if ( $FIELD_INTERFACE_TYPE == 5 )
{
if ( $FIELD_VALUE != "" )
{
$FIELD_VALUE = 1;
}
else
{
$FIELD_VALUE = 0;
}
}
if ( $FIELD_TYPE == "D" && $FIELD_AUTOVALUE != "" )
{
$FIELD_TYPE = $FIELD_AUTOVALUE;
}
if ( !type_check( $FIELD_VALUE, $FIELD_TYPE ) )
{
if ( $FIELD_TYPE == "C" )
{
$TYPE_STR = "字符";
}
else if ( $FIELD_TYPE == "N" )
{
$TYPE_STR = "数字";
}
else if ( $FIELD_TYPE == "D" )
{
$TYPE_STR = "日期";
}
else if ( $FIELD_TYPE == "DT" )
{
$TYPE_STR = "日期时间";
}
else if ( $FIELD_TYPE == "T" )
{
$TYPE_STR = "文本";
}
$MESSAGE .= "<font color=#000000>".$FIELD_DESC."</font>字段应为<font color=#000000>".$TYPE_STR."</font>类型！<br>";
$FLAG = true;
}
$VALUE_STR .= $FIELD_VALUE."','";
}
if ( $FLAG )
{
message( "", $MESSAGE );
button_back( );
}
else
{
$NAME_STR = substr( $NAME_STR, 0, strlen( $NAME_STR ) - 1 );
$VALUE_STR = substr( $VALUE_STR, 0, strlen( $VALUE_STR ) - 2 );
$query = "insert into {$TABLE_NAME}({$NAME_STR}) values ({$VALUE_STR})";
exequery( $connection, $query );
$query = "SELECT * from IK_APP where APP_ID={$APP_ID}";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$APP_RETURN = $ROW['APP_RETURN'];
}
function get_carname( $n )
{
switch ( $n )
{
case 0 :
$carname = "轿车";
break;
case 1 :
$carname = "面包车";
break;
case 2 :
$carname = "越野车";
break;
case 3 :
$carname = "吉普车";
break;
case 4 :
$carname = "巴士";
break;
case 5 :
$carname = "工具车";
break;
default :
$carname = "轿车";
break;
}
return $carname;
}
function get_repaire( $n )
{
switch ( $n )
{
case 0 :
$carname = "维修";
break;
case 1 :
$carname = "加油";
break;
case 2 :
$carname = "洗车";
break;
case 3 :
$carname = "年检";
break;
case 4 :
$carname = "其它";
break;
default :
$carname = "维修";
break;
}
return $carname;
}
$t_name_lower = strtolower( $TABLE_NAME );
if ( $t_name_lower == "meeting" || !( strpos( $t_name_lower, "vehicle" ) === false ) )
{
if ( !( strpos( $t_name_lower, "vehicle" ) === false ) )
{
$priv_code = "77";
}
if ( $t_name_lower == "meeting" )
{
$priv_code = "40";
}
$sql = " \r\n\t\t\t\tSELECT u.USER_ID FROM user AS u,user_priv as p \r\n\t\t\t\t\tWHERE u.USER_PRIV=p.USER_PRIV \r\n\t\t\t\t\t AND FUNC_ID_STR LIKE '%,".$priv_code.",%'\r\n\t\t\t ";
$rs = exequery( $connection, $sql );
$from_id = $_SESSION['LOGIN_USER_ID'];
$send_time = date( "Y-m-d H:i:s", time( ) );
if ( $t_name_lower == "vehicle" )
{
$sms_content = "有新的车辆增加了\n 车牌号:".$_POST['V_NUM']."\n 车型:".get_carname( $_POST['V_TYPE'] )."\n价格:".$_POST['V_PRICE']."\n 购置日期:".$_POST['V_DATE']."\n 驾驶员:".$_POST['V_DRIVER'];
$sms_type = 10;
}
if ( $t_name_lower == "vehicle_maintenance" )
{
$sql_cd = "\r\n\t\t\t\t\t\t\t SELECT V_NUM FROM vehicle \r\n\t\t\t\t\t\t\t\t WHERE V_ID=".$_POST['V_ID'];
$rs_cd = exequery( $connection, $sql_cd );
$row_cd = mysql_fetch_array( $rs_cd );
$car_code = $row_cd['V_NUM'];
$sms_content = "车辆维护\n 车牌号:".$car_code."\n 维护类型:".get_repaire( $_POST['VM_TYPE'] )."\n 维护原因:".$_POST['VM_REASON']."\n 经办人:".$_POST['VM_PERSON']."\n 维护费用:".$_POST['VM_FEE'];
$sms_type = 11;
}
if ( $t_name_lower == "vehicle_usage" )
{
$sql_cd = "\r\n\t\t\t\t\t\t\t SELECT V_NUM FROM vehicle \r\n\t\t\t\t\t\t\t\t WHERE V_ID=".$_POST['V_ID'];
$rs_cd = exequery( $connection, $sql_cd );
$row_cd = mysql_fetch_array( $rs_cd );
$car_code = $row_cd['V_NUM'];
$sql_us = "\r\n\t\t\t\t\t SELECT USER_NAME FROM user WHERE USER_ID='".$_POST['VU_USER']."'";
$rs_us = exequery( $connection, $sql_us );
$row_us = mysql_fetch_array( $rs_us );
$car_user = $row_us['USER_NAME'];
$sms_content = "申请用车\n 车牌号:".$car_code."\n 申请人:".$_POST['VU_PROPOSER']."\n 用车人:".$car_user."\n 事由:".$_POST['VU_REASON']."\n 申请时间:".$_POST['VU_REQUEST_DATE'];
$sms_type = 12;
$to_id = $car_user;
$sql_i = "\r\n\t\t\t\t\tINSERT INTO sms \r\n\t\t\t\t\t\t(FROM_ID,TO_ID,SMS_TYPE,CONTENT,SEND_TIME,REMIND_FLAG)\r\n\t\t\t\t\t\tVALUES\r\n\t\t\t\t\t\t('".$from_id."','".$to_id."','".$sms_type."','".$sms_content."','{$send_time}','1')\r\n\t\t\t\t\t";
exequery( $connection, $sql_i );
}
if ( $t_name_lower == "meeting" )
{
$sms_content = "申请会议\n 申请人:".$_POST['M_PROPOSER']."\n 名称:".$_POST['M_NAME']."\n 主题:".$_POST['M_TOPIC'];
$sms_type = 13;
}
while ( $row = mysql_fetch_array( $rs ) )
{
$to_id = $row['USER_ID'];
$sql_i = "\r\n\t\t\t\t\tINSERT INTO sms \r\n\t\t\t\t\t\t(FROM_ID,TO_ID,SMS_TYPE,CONTENT,SEND_TIME,REMIND_FLAG)\r\n\t\t\t\t\t\tVALUES\r\n\t\t\t\t\t\t('".$from_id."','".$to_id."','".$sms_type."','".$sms_content."','{$send_time}','1')\r\n\t\t\t\t\t";
exequery( $connection, $sql_i );
}
}
header( "location: {$APP_RETURN}" );
}
echo "\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -