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