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);