/**
* set activity identifier
*/
public function setIdentifier()
{
$reportingOrg = $this->organizationModel->find($this->orgId)->reporting_org;
$reportingOrgIdentifier = $reportingOrg[0]['reporting_organization_identifier'];
$activityIdentifier = $this->activity['activity_identifier'];
$this->activityData['identifier'] = ["activity_identifier" => $activityIdentifier, 'iati_identifier_text' => sprintf('%s-%s', $reportingOrgIdentifier, $activityIdentifier)];
}
/**
* 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;
}
/**
* Update published status for the changed files.
* @param $changes
* @param $organizationId
*/
public function updateStatus($changes, $organizationId)
{
$this->organizationModel = $this->organization->findOrFail($organizationId);
foreach ($changes['changes'] as $filename => $change) {
$row = $this->activityPublished->query()->where('filename', '=', $filename)->where('organization_id', '=', $organizationId)->first();
$row->published_to_register = 1;
$row->save();
}
}
public function run()
{
DB::table('users_organizations')->truncate();
$groups = [['data' => ['organization_id' => '1', 'user_id' => '1'], 'organization' => ['name' => 'Gradinita cu Program Prelungit Draga Mea']], ['data' => ['organization_id' => '2', 'user_id' => '2'], 'organization' => ['name' => 'Gradinita cu Program Prelungit Dumbrava Minunata']], ['data' => ['organization_id' => '3', 'user_id' => '3'], 'organization' => ['name' => 'Gradinita cu Program Prelungit Nr. 1']], ['data' => ['organization_id' => '4', 'user_id' => '1'], 'organization' => ['name' => 'Gradinita cu Program Prelungit Nr. 5']], ['data' => ['organization_id' => '5', 'user_id' => '4'], 'organization' => ['name' => 'Gradinita cu Program Prelungit Nr.6']], ['data' => ['organization_id' => '6', 'user_id' => '5'], 'organization' => ['name' => 'Gradinita cu Program Prelungit Nr.7']], ['data' => ['organization_id' => '7', 'user_id' => '6'], 'organization' => ['name' => 'Gradinita cu Program Prelungit Nr. 9']], ['data' => ['organization_id' => '8', 'user_id' => '7'], 'organization' => ['name' => 'Gradinita cu Program Prelungit Nr. 10']], ['data' => ['organization_id' => '9', 'user_id' => '1'], 'organization' => ['name' => 'Gradinita cu Program Prelungit Nr. 11']], ['data' => ['organization_id' => '10', 'user_id' => '8'], 'organization' => ['name' => 'Gradinita cu Program Prelungit Nr. 13']], ['data' => ['organization_id' => '11', 'user_id' => '8'], 'organization' => ['name' => 'Gradinita cu Program Prelungit Voinicelul']], ['data' => ['organization_id' => '12', 'user_id' => '6'], 'organization' => ['name' => 'Gradinita cu Program Prelungit Nr. 33']], ['data' => ['organization_id' => '13', 'user_id' => '4'], 'organization' => ['name' => 'Gradinita cu Program Prelungit 14 Mai']], ['data' => ['organization_id' => '14', 'user_id' => '9'], 'organization' => ['name' => 'Scoala Gimnaziala Grigore Moisil']], ['data' => ['organization_id' => '15', 'user_id' => '10'], 'organization' => ['name' => 'Scoala Gimnaziala C-tin Brancoveanu']], ['data' => ['organization_id' => '16', 'user_id' => '11'], 'organization' => ['name' => 'Scoala Gimnaziala Balcescu Petofi']], ['data' => ['organization_id' => '17', 'user_id' => '12'], 'organization' => ['name' => 'Scoala Gimnaziala Mircea Eliade']], ['data' => ['organization_id' => '18', 'user_id' => '13'], 'organization' => ['name' => 'Scoala Gimnaziala Octavian Goga']], ['data' => ['organization_id' => '19', 'user_id' => '14'], 'organization' => ['name' => 'Scoala Gimnaziala Nr.10']], ['data' => ['organization_id' => '20', 'user_id' => '11'], 'organization' => ['name' => 'Scoala Gimnaziala Ion Creanga']], ['data' => ['organization_id' => '21', 'user_id' => '15'], 'organization' => ['name' => 'Scoala Gimnaziala Avram Iancu']], ['data' => ['organization_id' => '22', 'user_id' => '16'], 'organization' => ['name' => 'Scoala Gimnaziala Lucian Blaga']], ['data' => ['organization_id' => '23', 'user_id' => '17'], 'organization' => ['name' => 'Scoala Gimnaziala Vasile Lucaciu']], ['data' => ['organization_id' => '24', 'user_id' => '18'], 'organization' => ['name' => 'Colegiul National Mihai Eminescu']], ['data' => ['organization_id' => '25', 'user_id' => '19'], 'organization' => ['name' => 'Colegiul National Ioan Slavici']], ['data' => ['organization_id' => '26', 'user_id' => '20'], 'organization' => ['name' => 'Colegiul National D-na Stanca']], ['data' => ['organization_id' => '27', 'user_id' => '21'], 'organization' => ['name' => 'Colegiul National Kolcsey Ferenc']], ['data' => ['organization_id' => '28', 'user_id' => '22'], 'organization' => ['name' => 'Liceul Teologic Ortodox Nicolae Steinhardt']], ['data' => ['organization_id' => '29', 'user_id' => '23'], 'organization' => ['name' => 'Liceul de Arte Aurel Popp']], ['data' => ['organization_id' => '30', 'user_id' => '24'], 'organization' => ['name' => 'Liceul Teoretic German Johann Ettinger']], ['data' => ['organization_id' => '31', 'user_id' => '25'], 'organization' => ['name' => 'Liceul cu Program Sportiv']], ['data' => ['organization_id' => '32', 'user_id' => '21'], 'organization' => ['name' => 'Liceul Reformat']], ['data' => ['organization_id' => '33', 'user_id' => '26'], 'organization' => ['name' => 'Colegiul Tehnic de Transporturi Si Telecomunicatii Ion I. C. Bratianu']], ['data' => ['organization_id' => '34', 'user_id' => '27'], 'organization' => ['name' => 'Colegiul Economic Gheorghe DragoS']], ['data' => ['organization_id' => '35', 'user_id' => '28'], 'organization' => ['name' => 'Liceul Tehnologic C-tin Brancusi']], ['data' => ['organization_id' => '36', 'user_id' => '29'], 'organization' => ['name' => 'Liceul Tehnologic Industrie Alimentara George Emil Palade']], ['data' => ['organization_id' => '37', 'user_id' => '30'], 'organization' => ['name' => 'Colegiul Tehnic Traian Vuia']], ['data' => ['organization_id' => '38', 'user_id' => '31'], 'organization' => ['name' => 'Colegiul Tehnic Elisa Zamfirescu']], ['data' => ['organization_id' => '39', 'user_id' => '32'], 'organization' => ['name' => 'Liceul Teologic Romano Catolic Ham Janos']], ['data' => ['organization_id' => '40', 'user_id' => '33'], 'organization' => ['name' => 'Centrul Judetean de excelenta']], ['data' => ['organization_id' => '41', 'user_id' => '34'], 'organization' => ['name' => 'Scoala Postliceala']]];
foreach ($groups as $grop) {
$organization = Organization::create($grop['organization']);
$data = $grop['data'];
DB::table('users_organizations')->insert($data);
}
}
public function checkUserIdentifier(Request $request)
{
$userIdentifier = $request->get('userIdentifier');
if ($this->organization->where('user_identifier', $userIdentifier)->count() == 0) {
$response = ['status' => 'success', 'message' => 'The organization user identifier is available.'];
} else {
$response = ['status' => 'danger', 'message' => 'The organization user identifier has already been taken.'];
}
return $response;
}
/**
* return activity data with results and transactions
* @param int $id
*/
private function getActivityData($id)
{
$activityData = Activity::find($id);
if ($activityData) {
$activityData = $activityData->toArray();
$reportingOrg = Organization::find($activityData['organization_id'])->reporting_org;
$results = ActivityResult::where('activity_id', $id)->get()->toArray();
$transactions = Transaction::where('activity_id', $id)->get()->toArray();
$documentLinks = ActivityDocumentLink::where('activity_id', $id)->get()->toArray();
$activityData['results'] = $results;
$activityData['transactions'] = $transactions;
$activityData['document_link'] = $documentLinks;
$activityData['reporting_organization'] = $reportingOrg;
}
return $activityData;
}
/**
* add or update organization by superadmin
* @param null $orgId
* @param array $orgDetails
* @return mixed|void
*/
public function saveOrganization(array $orgDetails, $orgId = null)
{
try {
$this->database->beginTransaction();
$orgData = $this->makeOrganizationData($orgDetails);
$organization = $this->organization->firstOrNew(['id' => $orgId]);
$organization->fill($orgData)->save();
$adminData = $this->makeAdminData($orgDetails, $organization->id);
$user = $this->user->firstOrNew(['org_id' => $organization->id]);
$user->fill($adminData)->save();
$settingsData = $this->makeSettingsData($orgDetails, $organization->id);
$settings = $this->settings->firstOrNew(['organization_id' => $organization->id]);
$settings->fill($settingsData)->save();
$this->database->commit();
$this->logger->info($orgId ? 'Organization information Updated' : 'Organization added');
$this->dbLogger->activity($orgId ? "activity.organization_updated" : "activity.organization_added", ['user_id' => $user->id, 'organization_id' => $orgId]);
} catch (Exception $exception) {
$this->database->rollback();
$this->logger->error($exception, ['settings' => $orgDetails]);
}
}
/**
* Update Settings with segmentation changes.
* @param SettingsRequestManager $requestManager
* @return mixed
* @internal param TempRequest|Request $request
*/
public function updateSettings(SettingsRequestManager $requestManager)
{
$organizationId = session('org_id');
$settings = $requestManager->requestHandler->all();
$organization = $this->organization->findOrFail($organizationId);
if (!$organization->publishedFiles->isEmpty()) {
if ($this->settingsService->hasSegmentationChanged($organizationId, $settings)) {
$changes = $this->settingsService->getChangeLog($organizationId, $settings);
if (empty($changes['previous']) && empty($changes['changes'])) {
return redirect()->route('settings.index')->withResponse(['type' => 'warning', 'messages' => ['You do not have any files for the segmentation change to take effect on.']]);
}
return view('settings.change-log', compact('organizationId', 'changes', 'settings'));
}
}
if (!$this->settingsManager->updateSettings($settings, $this->organization, $this->settings)) {
$response = ['type' => 'danger', 'code' => ['update_failed', ['name' => 'Settings']]];
} else {
$response = ['type' => 'success', 'code' => ['updated', ['name' => 'Settings']]];
}
return redirect()->to(config('app.admin_dashboard'))->withResponse($response);
}
/**
* update organization profile
* @param $input
* @return mixed
*/
protected function updateOrganizationProfile($input)
{
$organization = $this->organization->findOrFail($this->orgId);
$file = Input::file('organization_logo');
if ($file) {
$fileUrl = url('files/logos/' . $this->orgId . '.' . $file->getClientOriginalExtension());
$fileName = $this->orgId . '.' . $file->getClientOriginalExtension();
$image = Image::make(File::get($file))->resize(150, 150)->encode();
Storage::put('logos/' . $fileName, $image);
$organization->logo_url = $fileUrl;
$organization->logo = $fileName;
}
$organization->name = $input['organization_name'];
$organization->address = $input['organization_address'];
$organization->country = $input['country'];
$organization->organization_url = $input['organization_url'];
$organization->telephone = $input['organization_telephone'];
$organization->twitter = $input['organization_twitter'];
$organization->disqus_comments = array_key_exists('disqus_comments', $input) ? $input['disqus_comments'] : null;
return $organization->save();
}
/**
* @param $input
* @param $organization
*/
public function update(array $input, Organization $organization)
{
$organization->reporting_org = $input['reporting_org'];
$organization->save();
}
/**
* @param CreateUserRequest $request
* @return mixed
*/
public function create(CreateUserRequest $request)
{
$organizations_user = Organization::get();
// dd($organization_user);
return view('backend.access.create')->withRoles($this->roles->getAllRoles('sort', 'asc', true))->withPermissions($this->permissions->getAllPermissions())->with(compact('organizations_user'));
}
/**
* Find an Organization with a specific organizationId.
* @param $organizationId
* @return mixed
*/
public function find($organizationId)
{
return $this->organization->findOrFail($organizationId);
}
/** Returns query builder of organizations having activity or organization file published.
* @return mixed
*/
public function initializeOrganizationQueryBuilder()
{
return Organization::leftJoin('activity_published', 'organizations.id', '=', 'activity_published.organization_id')->leftJoin('organization_published', 'organizations.id', '=', 'organization_published.organization_id')->where('activity_published.published_to_register', 1)->orWhere('organization_published.published_to_register', 1)->select('organizations.id', 'organizations.name', 'organizations.logo_url')->groupBy('organizations.id')->orderBy('organizations.name');
}
public function destroy($id)
{
Organization::findOrFail($id)->delete();
return redirect()->back()->withFlashSuccess('The organization was successfully deleted.');
}
/**
* 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;
}
public function getUsersOfOrganization($orgId)
{
return $this->organization->findOrfail($orgId)->users;
}
/**
* check in DB if new reporting org is already present
* @param $reportOrg
* @return mixed
*/
public function getReportingOrganizations($reportOrg)
{
$result = Organization::where('id', '<>', session('org_id'))->whereRaw("reporting_org #>> '{0, reporting_organization_identifier}' = '" . $reportOrg['reporting_organization_identifier'] . "'");
return $result->first();
}
/**
* get groups by user Id
* @param $userId
* @return mixed
*/
public function getGroupsByUserId($userId)
{
$userGroup = $this->userGroup->whereUserId($userId)->first();
return $this->organization->whereIn('id', $userGroup->assigned_organizations)->with(['settings'])->orderBy('name', 'asc')->get();
}
