public static function getAssetContacts($assetID)
{
global $db;
$contacts = $db->select('assetContacts', ['[><]contacts' => ["contact" => "id"], '[><]assets' => ["asset" => "id"]], ['contacts.id'], ['assets.id' => $assetID]);
$toReturn = [];
foreach ($contacts as $contact) {
array_push($toReturn, Contacts::getContact($contact['id']));
}
// Adding investors contacts
$assetInvestors = Investors::getAssetInvestors($assetID);
foreach ($assetInvestors as $investor) {
$investorContacts = Contacts::getInvestorContacts($investor['id']);
$toReturn = array_merge($toReturn, $investorContacts);
}
return array_unique($toReturn, SORT_REGULAR);
}
public static function getAllInvestors()
{
global $db;
$investors = $db->select('investors', '*');
$ans = [];
foreach ($investors as $investor) {
$contacts = Contacts::getInvestorContacts($investor['id']);
if (count($contacts)) {
$firstContact = $contacts[0];
$investor['investorContact'] = $firstContact['fullName'];
$investor['contactPhone'] = $firstContact['mobilePhone'];
}
array_push($ans, $investor);
}
return $ans;
}
$investorResult = Investors::deleteInvestor($id);
InvestmentProfiles::deleteInvestorProfiles($id);
Notes::deleteInvestorNotes($id);
Assets::deleteInvestorAssets($id);
Logs::deleteInvestorLogs($id);
Contacts::deleteInvestorContacts($id);
if ($investorResult > 0) {
$response->json(Result::success('Investor Deleted.'));
} else {
$response->json(Result::error('Investor not Deleted'));
}
});
$this->respond(['GET', 'POST'], '/get/[i:id]', function ($request, $response, $service, $app) {
$id = $request->param('id');
$investorData = Investors::getInvestor($id);
$investorContacts = Contacts::getInvestorContacts($id);
$investorAssets = Assets::getInvestorAssets($id);
$investorProfiles = InvestmentProfiles::getInvestorProfiles($id);
$investorBuyLogs = Logs::getInvestorLogs($id);
$investorSellLogs = Logs::getInvestorAssetsLogs($id);
$investorConversations = Conversations::getInvestorConversations($id);
$investorNotes = Notes::getInvestorNotes($id);
$result = array("investorData" => $investorData, "investorContacts" => $investorContacts, "investorAssets" => $investorAssets, "investorProfiles" => $investorProfiles, "investorBuyLogs" => $investorBuyLogs, "investorSellLogs" => $investorSellLogs, "investorConversations" => $investorConversations, "investorNotes" => $investorNotes);
if ($investorData) {
$response->json(Result::success('', $result));
} else {
$response->json(Result::error('Investor not found'));
}
});
$this->respond(['GET', 'POST'], '/get/all', function ($request, $response, $service, $app) {
$result = Investors::getAllInvestors();
