public static function getInvestorsForControlPanel() { $investors = Investors::getAllInvestors(); $investorsModified = []; foreach ($investors as $investor) { $lastCallDate = self::getLastCall($investor['id']); $investor['lastCallDate'] = $lastCallDate; $lastCallDate = $lastCallDate ? date_create($lastCallDate) : null; $dominantDate = strtotime($investor['dominantDate']) ? date_create($investor['dominantDate']) : null; $frequency = $investor['communicationFrequency']; $investor['nextCallDate'] = self::calcNextCall($frequency, $dominantDate, $lastCallDate); $investor['nextCallDisplay'] = isset($investor['nextCallDate']) ? date_format($investor['nextCallDate'], 'Y-m-d') : null; array_push($investorsModified, $investor); } usort($investorsModified, function ($a1, $a2) { $v1 = $a1['nextCallDate'] ? date_timestamp_get($a1['nextCallDate']) : null; $v2 = $a2['nextCallDate'] ? date_timestamp_get($a2['nextCallDate']) : null; return $v1 - $v2; // $v2 - $v1 to reverse direction }); return $investorsModified; }
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(); $response->json(Result::success('', $result)); });