/**
* Unregister file: delete record from table and remove file
*/
function unregister_for_recid2($recid, $needDelete)
{
if ($needDelete) {
// find all files associated with this record
$query = "select dtl_UploadedFileID from recDetails where dtl_RecID=" . $recid;
$res = mysql_query($query);
while ($row = mysql_fetch_array($res)) {
deleteUploadedFiles($row[0]);
}
}
//remove from database
mysql_query('SET foreign_key_checks = 0');
mysql_query('delete from recUploadedFiles where ulf_ID in (select dtl_UploadedFileID from recDetails where dtl_RecID="' . $recid . '")');
mysql_query('SET foreign_key_checks = 1');
if (mysql_error()) {
return mysql_error();
} else {
return null;
}
}
if (@$_REQUEST['data']) {
$data = json_decode(urldecode(@$_REQUEST['data']), true);
} else {
$rv['error'] = "Data not defined! Wrong request.";
print json_format($rv);
return;
}
//1. to remove from recUploadedFiles and delete file
$files = $data['orphaned'];
$ids = array();
foreach ($files as $file) {
$ulf_ID = $file[0];
$isfound = $file[1];
//if true - find and delete file if in db root or uploaded files
if ($isfound == 1) {
deleteUploadedFiles($ulf_ID);
}
$ids[] = $ulf_ID;
}
if (count($ids) > 0) {
mysql_query('delete from recUploadedFiles where ulf_ID in (' . implode(',', $ids) . ')');
if (mysql_error()) {
$rv['error'] = "Cannot delete entries from recUploadedFiles. mySQL error: " . mysql_error();
print json_format($rv);
return;
}
}
//2. to remove from recUploadedFiles, recDetails
$file_ids = $data['notfound'];
if (count($file_ids) > 0) {
mysql_query('delete from recDetails where dtl_UploadedFileID in (' . implode(',', $file_ids) . ')');