Esempio n. 1
0
 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = Document::find();
     $dataProvider = new ActiveDataProvider(['query' => $query]);
     $this->load($params);
     if (!$this->validate()) {
         // uncomment the following line if you do not want to return any records when validation fails
         // $query->where('0=1');
         return $dataProvider;
     }
     $query->andFilterWhere(['id' => $this->id]);
     $query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'content', $this->content]);
     return $dataProvider;
 }
Esempio n. 2
0
 /**
  * Upload New File and attach it to a document
  *
  * @param Int $document
  * @param Request $request
  * @return Response
  */
 public function postFileToDocument($document, Request $request)
 {
     if (!$this->appKeyAvailable($request)) {
         return $this->notAuthorized($request);
     }
     $upload = array('file' => $request->file('file'));
     $rules = array('file' => 'required');
     $validator = Validator::make($upload, $rules);
     if (!empty($document) && !$this->isDocument($document)) {
         $this->setResultError("Document not found", 404);
     } elseif ($validator->fails()) {
         $this->setResultError($validator->messages(), 400);
     } elseif (!$this->setSessionUser($request)) {
         $this->setResultError("Not logged in", 401);
     } elseif ($document !== null && Document::find($document)->user_id != $this->user->id && !$this->isModerator()) {
         $this->setResultError("Unauthorized action", 403);
     } else {
         if ($request->file('file')->isValid()) {
             $destinationPath = '../uploads';
             $extension = Input::file('file')->getClientOriginalExtension();
             $fileName = uniqid() . '.' . $extension;
             $file = new File();
             $file->user_id = $this->user->id;
             $file->document_id = $document;
             $file->name = Input::file('file')->getClientOriginalName();
             $file->mime = Input::file('file')->getMimeType();
             $file->size = Input::file('file')->getSize();
             $file->path = $destinationPath . '/' . $fileName;
             Input::file('file')->move($destinationPath, $fileName);
             $file->save();
             $this->setAllowed(null, $file->id, $this->user->id, null, 'all');
             $this->setResultOk();
             $this->setFileData($file);
         } else {
             $this->setResultError('File is not valid', 400);
         }
     }
     return $this->setResponse();
 }
Esempio n. 3
0
 /**
  * Revoke Permission on a Document for a Group
  *
  * @param String $name
  * @param Int $id
  * @param String $access
  * @param Int $group
  * @param Request $request
  * @return Response
  */
 public function deleteGroupPermission($name, $id, $access, $group, Request $request)
 {
     if (!$this->appKeyAvailable($request)) {
         return $this->notAuthorized($request);
     }
     if (!$this->setSessionUser($request)) {
         $this->setResultError("Not logged in", 401);
     } elseif (!$this->isCollection($name)) {
         $this->setResultError("Collection '{$name}' doesn't exist", 401);
     } elseif (!in_array($access, ['read', 'update', 'delete', 'all'])) {
         $this->setResultError("Unknown permission '{$access}'", 400);
     } else {
         $document = Document::find($id);
         if (!$document) {
             $this->setResultError("Document is not found", 404);
         } elseif (!$this->isAllowed($request, 'document', $id, 'update') && !$this->isModerator()) {
             $this->setResultError("Unauthorized action", 403);
         } else {
             $this->setUnAllowed($id, null, null, $group, $access);
             $this->setResultOk();
         }
     }
     return $this->setResponse();
 }
Esempio n. 4
0
 /**
  * Show the form for editing the specified resource.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function edit($id)
 {
     $item = \App\Models\Item::find($id);
     $document = \App\Models\Document::find($item->document_id);
     $type = $document->os_type;
     switch ($type) {
         case 'movables' || 'value_movables':
             $variable = \App\Models\Item::find($id)->variable();
             return View::make('item.edit', array('item' => $item, 'document' => $document, 'variable' => $variable));
             break;
         case 'car':
             $variable = \App\Models\Item::find($id)->variable();
             $car = \App\Models\Car::find($id)->car();
             return View::make('item.edit', array('item' => $item, 'document' => $document, 'variable' => $variable, 'car' => $car));
             break;
         case 'buildings':
             $variable = \App\Models\Item::find($id)->variable();
             $building = \App\Models\Item::find($id)->building();
             $address = \App\Models\Address::find($id)->address();
             return View::make('item.edit', array('item' => $item, 'document' => $document, 'building' => $building, 'variable' => $variable, 'address' => $address));
             break;
         case 'parcels':
             $parcel = \App\Models\Item::find($id)->parcel();
             $address = \App\Models\Address::find($id)->address();
             return View::make('item.edit', array('item' => $item, 'document' => $document, 'parcel' => $parcel, 'address' => $address));
             break;
     }
 }
Esempio n. 5
0
 public function postImport($id)
 {
     $document = \App\Models\Document::find($id);
     $type = $document->os_type;
     if (Input::hasFile('file')) {
         $file = Input::file('file');
         $filename = $file->getClientOriginalName();
         $destinationPath = public_path() . '/uploads/';
         Input::file('file')->move($destinationPath, $filename);
         $handle = fopen(public_path() . '/uploads/' . $filename, "r");
         if ($handle !== FALSE) {
             if ($type == 'movables' || $type == 'value_movables') {
                 while (($data = fgetcsv($handle, 1000, ';')) !== FALSE) {
                     $item = new \App\Models\Item();
                     $name = iconv("Windows-1251", "utf-8", $data[0]);
                     $item->name = $name;
                     $item->number = $data[1];
                     $os_date = date("Y-m-d", strtotime($data[2]));
                     $item->os_date = $os_date;
                     $okof = $data[5];
                     $okof = str_replace(" ", "", $okof);
                     $item->okof = $okof;
                     $carrying_amount = $data[6];
                     $carrying_amount = str_replace(",", ".", $carrying_amount);
                     $carrying_amount = str_replace(" ", "", $carrying_amount);
                     $item->carrying_amount = $carrying_amount;
                     $item->financing_source = 1;
                     $item->document_id = $id;
                     $item->save();
                     $variable = new \App\Models\Variable();
                     $exploitation_date = date("Y-m-d", strtotime($data[3]));
                     $variable->exploitation_date = $exploitation_date;
                     $residual_value = $data[8];
                     $residual_value = str_replace(",", ".", $residual_value);
                     $residual_value = str_replace(" ", "", $residual_value);
                     $variable->residual_value = $residual_value;
                     $monthly_rate = $data[10];
                     $monthly_rate = str_replace(",", ".", $monthly_rate);
                     $variable->monthly_rate = $monthly_rate;
                     $variable->useful_life = $data[11];
                     $item->variable()->save($variable);
                 }
             }
             if ($type == 'car') {
                 while (($data = fgetcsv($handle, 2000, ';')) !== FALSE) {
                     $item = new \App\Models\Item();
                     $name = iconv("Windows-1251", "utf-8", $data[0]);
                     $item->name = $name;
                     $item->number = $data[1];
                     $os_date = date("Y-m-d", strtotime($data[2]));
                     $item->os_date = $os_date;
                     $okof = $data[5];
                     $okof = str_replace(" ", "", $okof);
                     $item->okof = $okof;
                     $carrying_amount = $data[6];
                     $carrying_amount = str_replace(",", ".", $carrying_amount);
                     $carrying_amount = str_replace(" ", "", $carrying_amount);
                     $item->carrying_amount = $carrying_amount;
                     $item->financing_source = 1;
                     $item->document_id = $id;
                     $item->save();
                     $variable = new \App\Models\Variable();
                     $exploitation_date = date("Y-m-d", strtotime($data[3]));
                     $variable->exploitation_date = $exploitation_date;
                     $residual_value = $data[8];
                     $residual_value = str_replace(",", ".", $residual_value);
                     $residual_value = str_replace(" ", "", $residual_value);
                     $variable->residual_value = $residual_value;
                     $monthly_rate = $data[10];
                     $monthly_rate = str_replace(",", ".", $monthly_rate);
                     $variable->monthly_rate = $monthly_rate;
                     $variable->useful_life = $data[11];
                     $item->variable()->save($variable);
                     $car = new \App\Models\Car();
                     $car->brand = $data[12];
                     $car->model = $data[13];
                     $manufacture_year = date("Y-m-d", strtotime($data[14]));
                     $car->manufacture_year = $manufacture_year;
                     $vin = $data[15];
                     $vin = str_replace('"', '', $vin);
                     $car->vin = $vin;
                     $car->kpp = $data[16];
                     $car->engine = $data[17];
                     $car->power = $data[18];
                     if (isset($data[19])) {
                         $car->color = $data[19];
                     }
                     $item->car()->save($car);
                 }
             }
             if ($type == 'buildings') {
                 while (($data = fgetcsv($handle, 1000, ';')) !== FALSE) {
                     $item = new \App\Models\Item();
                     $name = iconv("Windows-1251", "utf-8", $data[0]);
                     $item->name = $name;
                     $item->number = $data[1];
                     $os_date = date("Y-m-d", strtotime($data[2]));
                     $item->os_date = $os_date;
                     $okof = $data[5];
                     $okof = str_replace(" ", "", $okof);
                     $item->okof = $okof;
                     $carrying_amount = $data[6];
                     $carrying_amount = str_replace(",", ".", $carrying_amount);
                     $carrying_amount = str_replace(" ", "", $carrying_amount);
                     $item->carrying_amount = $carrying_amount;
                     $item->financing_source = 1;
                     $item->document_id = $id;
                     $item->save();
                     $variable = new \App\Models\Variable();
                     $exploitation_date = date("Y-m-d", strtotime($data[3]));
                     $variable->exploitation_date = $exploitation_date;
                     $residual_value = $data[8];
                     $residual_value = str_replace(",", ".", $residual_value);
                     $residual_value = str_replace(" ", "", $residual_value);
                     $variable->residual_value = $residual_value;
                     $monthly_rate = $data[10];
                     $monthly_rate = str_replace(",", ".", $monthly_rate);
                     $monthly_rate = str_replace(" ", "", $monthly_rate);
                     $variable->monthly_rate = $monthly_rate;
                     $variable->useful_life = $data[11];
                     $item->variable()->save($variable);
                     $building = new \App\Models\Building();
                     $appointment = iconv("Windows-1251", "utf-8", $data[12]);
                     $building->appointment = $appointment;
                     $wall_material = iconv("Windows-1251", "utf-8", $data[13]);
                     $building->wall_material = $wall_material;
                     $date_construction = date("Y-m-d", strtotime($data[14]));
                     $building->date_construction = $date_construction;
                     $building->floors = $data[15];
                     $item->building()->save($building);
                     $address = new \App\Models\Address();
                     $state = iconv("Windows-1251", "utf-8", $data[16]);
                     $address->state = $state;
                     $item->address()->save($address);
                 }
             }
             if ($type == 'parcels') {
                 while (($data = fgetcsv($handle, 1000, ';')) !== FALSE) {
                     $item = new \App\Models\Item();
                     $name = iconv("Windows-1251", "utf-8", $data[0]);
                     $item->name = $name;
                     $item->number = $data[1];
                     $os_date = date("Y-m-d", strtotime($data[2]));
                     $item->os_date = $os_date;
                     $carrying_amount = $data[3];
                     $carrying_amount = str_replace(",", ".", $carrying_amount);
                     $carrying_amount = str_replace(" ", "", $carrying_amount);
                     $item->carrying_amount = $carrying_amount;
                     $item->financing_source = 1;
                     $item->document_id = $id;
                     $item->save();
                     $parcel = new \App\Models\Parcel();
                     $parcel->cadastral = $data[5];
                     $assigning_land = iconv("Windows-1251", "utf-8", $data[6]);
                     $parcel->assigning_land = $assigning_land;
                     $parcel->area = $data[7];
                     $item->parcel()->save($parcel);
                     $address = new \App\Models\Address();
                     $state = iconv("Windows-1251", "utf-8", $data[8]);
                     $address->state = $state;
                     $state = iconv("Windows-1251", "utf-8", $data[8]);
                     $item->address()->save($address);
                 }
             }
             fclose($handle);
         }
     }
     return redirect()->back();
 }
 public function showServiceAgreementWithClient($id)
 {
     $serviceAgreement = Document::find($id);
     $file = $serviceAgreement->file_name;
     $extension = explode('.', $file);
     $extension = strtolower(end($extension));
     $contentType = 'application/pdf';
     if ($extension != 'pdf') {
         $contentType = 'image/' . $extension;
     }
     $shortFileName = explode('/', $file);
     $shortFileName = end($shortFileName);
     return Response::make(file_get_contents($file), 200, ['Content-Type' => $contentType, 'Content-Disposition' => 'inline; ' . $shortFileName]);
 }
Esempio n. 7
0
 /**
  * return document by id
  * @param $id
  * @return static
  */
 public function getDocumentById($id)
 {
     return $this->document->find($id);
 }