/**
* A basic test example.
*
* @return void
*/
public function testCreateRequest()
{
//$this->assertTrue(true);
$testData = ["org_name" => "Paradise Island", "daughters" => [["org_name" => "Banana tree", "daughters" => [["org_name" => "Yellow Banana"], ["org_name" => "Brown Banana"], ["org_name" => "Green Banana"]]]]];
//making store request
$this->post('api/organizations/store', $testData)->seeJson(["success" => true]);
//chcking if they exist in DB
$this->seeInDatabase('organizations', ['org_name' => "Paradise Island"]);
$this->seeInDatabase('organizations', ['org_name' => 'Banana tree']);
$this->seeInDatabase('organizations', ['org_name' => 'Yellow Banana']);
$this->seeInDatabase('organizations', ['org_name' => 'Brown Banana']);
$this->seeInDatabase('organizations', ['org_name' => 'Green Banana']);
$org = Organization::where('org_name', "Banana tree")->first();
$org->load('parent', 'daughters');
//checking relations
$this->assertEquals("Paradise Island", $org->parent->org_name);
$this->assertEquals("Yellow Banana", $org->daughters[0]->org_name);
$this->assertEquals("Brown Banana", $org->daughters[1]->org_name);
$this->assertEquals("Green Banana", $org->daughters[2]->org_name);
//making get organization request, and expecting exact json
//I need organization details to insert correct creation time to json
$org1 = Organization::where('org_name', "Paradise Island")->first();
$org2 = Organization::where('org_name', "Banana tree")->first();
$org3 = Organization::where('org_name', "Yellow Banana")->first();
$org4 = Organization::where('org_name', "Brown Banana")->first();
$org5 = Organization::where('org_name', "Green Banana")->first();
$expected = ["success" => true, "pipedrive_format" => [["type" => "parent", "rel_owner_org_id" => ["name" => "Paradise Island", "id" => "1"], "rel_linked_org_id" => ["name" => "Banana tree", "id" => "2"], "add_time" => $org2->created_at->toDateTimeString(), "calculated_type" => "parent"], ["type" => "parent", "rel_owner_org_id" => ["name" => "Banana tree", "id" => "2"], "rel_linked_org_id" => ["name" => "Yellow Banana", "id" => "3"], "add_time" => $org3->created_at->toDateTimeString(), "calculated_type" => "daughter"], ["type" => "parent", "rel_owner_org_id" => ["name" => "Banana tree", "id" => "2"], "rel_linked_org_id" => ["name" => "Brown Banana", "id" => "4"], "add_time" => $org4->created_at->toDateTimeString(), "calculated_type" => "daughter"], ["type" => "parent", "rel_owner_org_id" => ["name" => "Banana tree", "id" => "2"], "rel_linked_org_id" => ["name" => "Green Banana", "id" => "5"], "add_time" => $org5->created_at->toDateTimeString(), "calculated_type" => "daughter"]]];
$this->get("api/organizations/" . $org->id)->seeJsonEquals($expected);
//making delete request
$this->delete('api/organizations')->seeJson(["success" => true]);
}
/**
* Удаление города
*
* @param City $city
* @return \Illuminate\Http\RedirectResponse
* @throws \Exception
*/
public function delete(City $city)
{
if (Organization::where('city_id', $city->id)->exists()) {
dd('Есть организации с таким городом');
}
$city->delete();
return redirect()->route('admin::city');
}
/**
* Удаление типа
*
* @param Type $type
* @return \Illuminate\Http\RedirectResponse
* @throws \Exception
*/
public function delete(Type $type)
{
if (Organization::where('type_id', $type->id)->exists()) {
dd('Есть организации с таким типом');
}
$type->delete();
return redirect()->route('admin::type');
}
/**
* Удаление статуса
*
* @param Status $status
* @return \Illuminate\Http\RedirectResponse
* @throws \Exception
*/
public function delete(Status $status)
{
if (Organization::where('status_id', $status->id)->exists()) {
dd('Есть организации с таким статусом');
}
$status->delete();
return redirect()->route('admin::status');
}
/**
* Удаление ОПФ
*
* @param Opf $opf
* @return \Illuminate\Http\RedirectResponse
* @throws \Exception
*/
public function delete(Opf $opf)
{
if (Organization::where('opf_id', $opf->id)->exists()) {
dd('Есть организации с таким ОПФ');
}
$opf->delete();
return redirect()->route('admin::opf');
}
protected static function updateDB($data)
{
foreach ($data as $title) {
if ($title['STUDENT ID'] != '') {
//creating or updating districts
$DDBNNN = preg_split('/(?<=[0-9])(?=[a-z]+)/i', $title['DDBNNN']);
$district = District::firstOrCreate(['code' => $DDBNNN[0], 'system_id' => 1]);
$district->code = $DDBNNN[0];
$district->system_id = 1;
$district->title = 'District ' . $DDBNNN[0];
$district->save();
$organization = Organization::where(['code' => $DDBNNN[1]])->with(array('districts' => function ($query) use($district) {
$query->where('district_id', $district->id);
}))->first();
if (is_null($organization)) {
// TODO figure out if this can be replaced with a firstOrCreate;
$organization = new Organization();
}
$organization->code = $DDBNNN[1];
$organization->title = $DDBNNN[1];
$organization->save();
if (!$organization->districts->contains($district->id)) {
$organization->districts()->attach($district->id);
}
$user = User::firstOrCreate(['student_id' => $title['STUDENT ID']]);
$user->student_id = $title['STUDENT ID'];
$user->first_name = $title['FIRST NAME'];
$user->last_name = $title['LAST NAME'];
$user->sex = $title['SEX'];
$user->dob = $title['BIRTH DT'];
$user->save();
}
}
$notifier = new Notifier();
$notifier->to = Auth::user()->email;
$notifier->subject = "Your import is completed at " . date('m-d-Y h:i:s A');
$notifier->template = "emails.import";
$notifier->attachData(['user' => Auth::user()]);
$notifier->send();
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request)
{
if ($organization = Organization::where('userId', Auth::user()->id)->first()) {
} else {
$organization = new Organization();
$organization->userId = Auth::user()->id;
}
if ($request['brochure']) {
$filepath = base_path() . "/public/uploads/" . $organization->brochure;
is_file($filepath) ? file_exists($filepath) ? unlink($filepath) : " " : " ";
$name = time() . "." . $request->file('brochure')->getClientOriginalExtension();
$dest = base_path() . "/public/uploads";
$request->file('brochure')->move($dest, $name);
$organization->brochure = $name;
}
$organization->name = $request['name'];
$organization->address = $request['address'];
$organization->description = $request['description'];
$organization->save();
\Session::flash('success_message', 'Your record has been updated');
return redirect('organization/edit');
}
/**
* @param $input
* @param $organization
* @throws GeneralException
*/
private function checkOrganizationByEmail($input, $organization)
{
//Figure out if email is not the same
if ($organization->email != $input['email']) {
//Check to see if email exists
if (Organization::where('email', '=', $input['email'])->first()) {
throw new GeneralException('That email address belongs to a different organization.');
}
}
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Organization::where('organization_name', 'Organization One')->delete();
}
public function updateOrganization($id, Request $request)
{
$this->validate($request, ['name' => 'required|unique:organizations,name,' . $id]);
Organization::where('id', $id)->update(['name' => $request->get('name')]);
return "GTG";
}
/**
* Удаление организации
* @param Organization $organization
* @return \Illuminate\Http\RedirectResponse
* @throws \Exception
*/
public function delete(Organization $organization)
{
// удаляем подразделения
Organization::where('parent_id', $organization->id)->delete();
// удаляем сотрудников
Worker::where('organization_id', $organization->id)->delete();
Snapshot::where('organization_id', $organization->id)->delete();
// удаляем саму организацию
$organization->delete();
return redirect()->route('admin::organization');
}
/**
* Счетчики огранизаций и работников
*/
protected function getCounters()
{
View::share('organizationCount', Organization::where('snapshot_id', '>', 0)->count());
View::share('workersCount', Worker::count());
}
/**
* Get the organizations by id.
*
* @param string $id
*
* @return Collection
*/
public function byId($id)
{
return Organization::where('id', $id)->first();
}
