include 'inc/inc_version.php'; include_lcm('inc_auth'); include_lcm('inc_filters'); include_lcm('inc_impex'); include_lcm('inc_xml'); if ($GLOBALS['author_session']['status'] != 'admin') { lcm_panic("You don't have permission to export!"); } $item = clean_input($_REQUEST['item']); if (!empty($_REQUEST['id'])) { $id = intval($_REQUEST['id']); } $data = array(); switch ($item) { case 'case': load_case($id, $data, _LOAD_ALL); break; case 'followup': $data = load_followup($id, $data, _LOAD_ALL); break; case 'client': $data = load_client($id, $data, _LOAD_ALL); break; case 'org': $data = load_org($id, $data, _LOAD_ALL); break; default: lcm_panic("Incorrect export item type!"); exit; } // Send proper headers to browser
function load_org($id, &$org_data, $scope = 0) { // Load organization data $result = lcm_query("SELECT * FROM lcm_org WHERE id_org={$id}"); $org_data['organization']["ID{$id}"] = lcm_fetch_assoc($result); // Load the associated items - cases, clients, attachnments if ($scope & _LOAD_CASE) { $result = lcm_query("SELECT * FROM lcm_case_client_org WHERE id_org={$id}"); while ($row = lcm_fetch_assoc($result)) { $org_data['relation']['case-client-org']['ID' . join('-', $row)] = $row; load_case($row['id_case'], $org_data, $scope & (_LOAD_ATTACHMENT | _LOAD_CONTACTS)); } } if ($scope & _LOAD_CLIENT) { $result = lcm_query("SELECT * FROM lcm_client_org WHERE id_org={$id} AND id_client>0"); while ($row = lcm_fetch_assoc($result)) { $org_data['relation']['client-org']['ID' . join('-', $row)] = $row; load_client($row['id_client'], $org_data, $scope & (_LOAD_ATTACHMENT | _LOAD_CONTACTS)); } } if ($scope & _LOAD_ATTACHMENT) { $result = lcm_query("SELECT * FROM lcm_org_attachment WHERE id_org={$id}"); while ($row = lcm_fetch_assoc($result)) { $row['content'] = base64_encode($row['content']); $org_data['organization']["ID{$id}"]['attachment']['ID' . $row['id_attachment']] = $row; } } if ($scope & _LOAD_CONTACTS) { $result = lcm_query("\tSELECT * FROM lcm_contact WHERE type_person='org' AND id_of_person={$id}"); while ($row = lcm_fetch_assoc($result)) { $org_data['organization']["ID{$id}"]['contact']['ID' . $row['id_contact']] = $row; load_kw($row['type_contact'], $org_data, _LOAD_ALL); } } }