function deleteFile($tablename, $primarykey_index, $element, $fujian)
{
$fujianValue = returntablefield($tablename, $primarykey_index, $element, $fujian);
$fujianValueArray = explode('||', $fujianValue);
delete_attach($fujianValueArray[1], $fujianValueArray[0]);
}
function delete_array_newai($element, $fields)
{
global $right_etc, $html_etc, $common_html;
global $_POST, $_GET, $db;
global $primarykey_index;
global $delete_attribute, $delete_attribute;
global $columns, $tablename;
DoReferer();
$_GET[$primarykey_index] = $element;
$return_sql_line = return_sql_line($fields);
if (isset($delete_attribute) && $delete_attribute != '') {
//$delete_attribute_array=explode(':',$delete_attribute);
//$index_temp=$delete_attribute_array[0];print $index_temp;
//$fieldvalue=gettablefield($tablename,$primarykey_index,$columns[$index_temp],$element);print $fieldvalue;
//if($fieldvalue)
// $SQL=$return_sql_line['delete_sql'];
//else
$SQL = $return_sql_line['update_fixed_field_sql'];
} else {
$SQL = $return_sql_line['delete_sql'];
}
//print $SQL;exit;
//如果有附件，删除附件
for ($i = 0; $i < sizeof($fields['null']); $i++) {
if ($fields['null'][$i]['inputfilter'] == 'tdoafile') {
$fujianValue = returntablefield($tablename, $primarykey_index, $element, $fields['name'][$i]);
$fujianValueArray = explode('||', $fujianValue);
require_once 'lib/utility_file.php';
delete_attach($fujianValueArray[1], $fujianValueArray[0]);
}
if ($fields['null'][$i]['inputfilter'] == 'picturefile') {
$fujianValue = returntablefield($tablename, $primarykey_index, $element, $fields['name'][$i]);
require_once 'lib/utility_file.php';
delete_single_attach($fujianValue);
}
}
//得到要删除的表的记录的值;
$sql = "select * from {$tablename} where {$primarykey_index}='{$element}'";
$rs = $db->Execute($sql);
$rs_a = $rs->GetArray();
$KEYS = @array_keys($rs_a[0]);
$SQLTEXT = '';
for ($i = 0; $i < sizeof($KEYS); $i++) {
$KEY = $KEYS[$i];
$SQLTEXT .= "{$KEY}:" . $rs_a[0][$KEY] . " ";
}
//print_R();
global $db, $html_etc, $tablename;
$排除记录日志的页面 = array("/general/EDU/Interface/EDU/system_log_newai.php", "/general/EDU/Interface/CRM/system_log_newai.php", "/general/EDU/Interface/JIAOYUJU/system_log_newai.php");
if (!in_array($_SERVER['SCRIPT_NAME'], $排除记录日志的页面)) {
system_log_input("删除" . $html_etc[$tablename][$tablename], $SQLTEXT . " <BR>" . $SQL);
}
$result = $db->Execute($SQL);
if ($result->EOF) {
return false;
} else {
return true;
}
}
if ($_GET['actionDeleteFile'] == "DeleteFile") {
global $db;
$删除附件字段 = $_GET['DeleteField'];
$primarykey_index_value = $_GET[$primarykey_index];
$sql = "select {$删除附件字段} from {$tablename} where {$primarykey_index}='{$primarykey_index_value}'";
$rs = $db->Execute($sql);
$删除附件字段值 = $rs->fields[$删除附件字段];
$删除附件字段数组 = explode('||', $删除附件字段值);
$ATTACHMENT_ID_OLD = $删除附件字段数组[1];
$ATTACHMENT_NAME_OLD = $删除附件字段数组[0];
//print_R($_GET);exit;
$ATTACHMENT_ID = $_GET['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $_GET['ATTACHMENT_NAME'];
if ($ATTACHMENT_NAME != "") {
require_once 'lib/utility_file.php';
delete_attach($ATTACHMENT_ID, $ATTACHMENT_NAME);
$ATTACHMENT_ID_ARRAY = explode(",", $ATTACHMENT_ID_OLD);
$ATTACHMENT_NAME_ARRAY = explode("*", $ATTACHMENT_NAME_OLD);
$ARRAY_COUNT = sizeof($ATTACHMENT_ID_ARRAY);
for ($I = 0; $I < $ARRAY_COUNT; $I++) {
if ($ATTACHMENT_ID_ARRAY[$I] != $ATTACHMENT_ID && $ATTACHMENT_ID_ARRAY[$I] != "") {
$ATTACHMENT_ID1 .= $ATTACHMENT_ID_ARRAY[$I] . ",";
$ATTACHMENT_NAME1 .= $ATTACHMENT_NAME_ARRAY[$I] . "*";
}
}
$ATTACHMENT_ID = $ATTACHMENT_ID1;
$ATTACHMENT_NAME = $ATTACHMENT_NAME1;
$删除附件字段值 = $ATTACHMENT_NAME . "||" . $ATTACHMENT_ID;
$sql = "update {$tablename} set {$删除附件字段}='{$删除附件字段值}' where {$primarykey_index}='{$primarykey_index_value}'";
$db->Execute($sql);
//print_R($ATTACHMENT_ID_ARRAY);
