/**
* return all organization data
*/
public function get()
{
$id = request()->segment(2);
$orgData = OrgData::where('organization_id', $id)->first()->toArray();
$orgData['reporting_org'] = Organization::find($id)->reporting_org;
return $orgData;
}
/**
* write brief description
* @param $organization_id
* @return model
*/
public function getOrganizationTotalBudgetData($organization_id)
{
return $this->org->where('organization_id', $organization_id)->first()->total_budget;
}
/**
* write brief description
* @param $organization_id
* @return model
*/
public function getRecipientCountryBudgetData($organization_id)
{
return $this->org->where('organization_id', $organization_id)->first()->recipient_country_budget;
}
/**
* write brief description
* @param $organization_id
* @return model
*/
public function getDocumentLinkData($organization_id)
{
return $this->org->where('organization_id', $organization_id)->first()->document_link;
}
/**
* @param $organization_id
* @return mixed
*/
protected function getOrganizationData($organization_id)
{
return $this->orgData->where('organization_id', $organization_id)->first();
}
/**
* write brief description
* @param $organization_id
* @return model
*/
public function getOrganizationNameData($organization_id)
{
return $this->orgData->where('organization_id', $organization_id)->first()->name;
}
/**
* @param $organization_id
*/
public function resetStatus($organization_id)
{
$this->orgData->where('organization_id', $organization_id)->update(['status' => 0]);
}
/**
* Details of the organization to be exported to the csv
* @return array
*/
public function getAllOrganizationInfo()
{
$organizations = Organization::all();
$organizationDetails = [];
$organizations->each(function ($organization) use(&$organizationDetails) {
$organizationId = $organization->id;
$organizationDetails[$organizationId]['name'] = $organization->name;
$organizationDetails[$organizationId]['admin_email'] = $this->getEmailOfOrganizationAdmin($organizationId);
$activities = $this->getActivitiesData($organizationId);
$organizationDetails[$organizationId]['noOfActivities'] = $activities ? $activities[0]->noofactivities : ' ';
$organizationDetails[$organizationId]['activityLastUpdatedAt'] = $activities ? $activities[0]->updated_at : ' ';
$organizationDetails[$organizationId]['noOfActivitiesPublished'] = $this->getNoOfActivitiesPublished($organizationId)[0]->noofpublishedactivities;
$organizationDetails[$organizationId]['organizationDataPublished'] = $this->statusOfOrganizationDataPublished($organizationId)[0]->organizationdatapublished;
$organizationUpdatedAt = OrganizationData::where('organization_id', $organizationId)->select('updated_at')->first();
$organizationDetails[$organizationId]['organizationLastUpdatedAt'] = $organizationUpdatedAt ? $organizationUpdatedAt->updated_at : ' ';
});
return $organizationDetails;
}
/**
* get total expenditure organization data
* @param $orgId
* @return model
*/
public function getOrganizationTotalExpenditureData($orgId)
{
return $this->org->where('organization_id', $orgId)->first()->total_expenditure;
}
