public static function delServiceFiles($service_id, $filename, $type)
{
$service_info = db_factory::get_one(sprintf("select * from %switkey_service where service_id='%d' ", TABLEPRE, intval($service_id)));
$filelist = array();
if ($type == 'pic') {
if ($service_info['pic']) {
$filelist = explode(',', $service_info['pic']);
}
} else {
if ($service_info['file_path']) {
$filelist = explode(',', $service_info['file_path']);
}
}
if ($filelist) {
CommonClass::delFileBySavename($filename);
$newlist = array();
foreach ($filelist as $k => $v) {
if ($filename != $v) {
$newlist[] = $v;
}
}
}
$filepath = '';
if ($newlist) {
$filepath = implode(',', $newlist);
}
if ($type == 'pic') {
$sql = "UPDATE `" . TABLEPRE . "witkey_service` SET `pic`='{$filepath}' WHERE (`service_id`='{$service_id}')";
} else {
$sql = "UPDATE `" . TABLEPRE . "witkey_service` SET `file_path`='{$filepath}' WHERE (`service_id`='{$service_id}')";
}
return db_factory::execute($sql);
}
