Exemplo n.º 1
0
 /**
  * 	Sets top-level bill information.
  */
 public function createDoc()
 {
     $this->checkAttr('domdoc');
     $this->setBillTitle();
     $this->setBillSlug();
     $bill = new Doc();
     $bill->title = $this->title;
     $bill->slug = $this->slug;
     $bill->save();
     try {
         $starter = new DocContent();
         $starter->doc_id = $bill->id;
         $starter->content = $this->getBillMeta('legis-type') . ' ' . $this->getBillMeta('official-title');
         $starter->save();
         $bill->init_section = $starter->id;
         $bill->save();
         $this->bill = $bill;
         $rootElement = $this->domdoc->getElementsByTagName($this->rootTag)->item(0);
         $c = 0;
         if (!is_object($rootElement)) {
             throw new Exception("Couldn't retrieve root element");
         }
         foreach ($rootElement->childNodes as $child) {
             $this->saveChildren($child, $starter->id, $c++);
         }
     } catch (Exception $e) {
         $bill->delete();
         $starter->delete();
         throw new Exception($e->getMessage());
     }
     return true;
 }
Exemplo n.º 2
0
 public function run()
 {
     $adminEmail = Config::get('madison.seeder.admin_email');
     $adminPassword = Config::get('madison.seeder.admin_password');
     // Login as admin to create docs
     $credentials = array('email' => $adminEmail, 'password' => $adminPassword);
     Auth::attempt($credentials);
     $admin = Auth::user();
     $group = Group::where('id', '=', 1)->first();
     // Create first doc
     $docSeedPath = app_path() . '/database/seeds/example.md';
     if (file_exists($docSeedPath)) {
         $content = file_get_contents($docSeedPath);
     } else {
         $content = "New Document Content";
     }
     $docOptions = array('title' => 'Example Document', 'content' => $content, 'sponsor' => $group->id, 'publish_state' => 'published', 'sponsorType' => Doc::SPONSOR_TYPE_GROUP);
     $document = Doc::createEmptyDocument($docOptions);
     //Set first doc as featured doc
     $featuredSetting = new Setting();
     $featuredSetting->meta_key = 'featured-doc';
     $featuredSetting->meta_value = $document->id;
     $featuredSetting->save();
     // Create second doc
     $docSeedPath = app_path() . '/database/seeds/example2.md';
     if (file_exists($docSeedPath)) {
         $content = file_get_contents($docSeedPath);
     } else {
         $content = "New Document Content";
     }
     $docOptions = array('title' => 'Second Example Document', 'sponsor' => $group->id, 'publish_state' => 'published', 'sponsorType' => Doc::SPONSOR_TYPE_GROUP);
     $document = Doc::createEmptyDocument($docOptions);
 }
Exemplo n.º 3
0
 /**
  * Handle an incoming request.
  *
  * @param  \Illuminate\Http\Request  $request
  * @param  \Closure  $next
  * @return mixed
  */
 public function handle($request, Closure $next)
 {
     if (!Auth::check()) {
         return response('Unauthorized.', 403);
     }
     $user = Auth::user();
     $doc = Doc::withTrashed()->find($request->doc);
     if (!$doc->canUserEdit($user)) {
         return response('Unauthorized.', 403);
     }
     return $next($request);
 }
Exemplo n.º 4
0
 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = Doc::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, 'person_id' => $this->person_id, 'type_id' => $this->type_id, 'date' => $this->date, 'date_end' => $this->date_end, 'date_renewal' => $this->date_renewal, 'duration_months' => $this->duration_months, 'duration_days' => $this->duration_days, 'address_id' => $this->address_id, 'rec_status_id' => $this->rec_status_id, 'user_id' => $this->user_id, 'dc' => $this->dc]);
     $query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'series', $this->series])->andFilterWhere(['like', 'num', $this->num])->andFilterWhere(['like', 'who_give', $this->who_give])->andFilterWhere(['like', 'note', $this->note]);
     return $dataProvider;
 }
Exemplo n.º 5
0
 /**
  * Handle an incoming request.
  *
  * @param  \Illuminate\Http\Request  $request
  * @param  \Closure  $next
  * @return mixed
  */
 public function handle($request, Closure $next)
 {
     if ($request->doc) {
         $doc = Doc::find($request->doc);
     } else {
         $doc = Doc::findDocBySlug($request->slug);
     }
     $user = Auth::user();
     if (!$doc->canUserView($user)) {
         if ($request->ajax()) {
             return response('Unauthorized.', 403);
         } else {
             return redirect()->guest('auth/login');
         }
     }
     return $next($request);
 }
Exemplo n.º 6
0
 /**
  *	Method to handle document RSS feeds.
  *
  *	@param string $slug
  *
  * @return view $feed->render()
  */
 public function getFeed($slug)
 {
     $doc = Doc::where('slug', $slug)->with('comments', 'annotations', 'userSponsor', 'groupSponsor')->first();
     $feed = Feed::make();
     $feed->title = $doc->title;
     $feed->description = "Activity feed for '" . $doc->title . "'";
     $feed->link = URL::to('docs/' . $slug);
     $feed->pubdate = $doc->updated_at;
     $feed->lang = 'en';
     $activities = $doc->comments->merge($doc->annotations);
     $activities = $activities->sort(function ($a, $b) {
         return strtotime($a['updated_at']) > strtotime($b['updated_at']) ? -1 : 1;
     });
     foreach ($activities as $activity) {
         $item = $activity->getFeedItem();
         array_push($feed->items, $item);
     }
     return $feed->render('atom');
 }
Exemplo n.º 7
0
 /**
  * Get the validation rules that apply to the request.
  *
  * @return array
  */
 public function rules()
 {
     return ['publish_state' => 'in:' . implode(',', Doc::validPublishStates()), 'discussion_state' => 'in:' . implode(',', Doc::validDiscussionStates())];
 }
Exemplo n.º 8
0
 public function getAllSponsors()
 {
     $results = Doc::getAllValidSponsors();
     return Response::json($results);
 }
Exemplo n.º 9
0
 public function getActions($docId)
 {
     $doc = Doc::where('id', $docId)->first();
     if ($doc) {
         $skip_ids = $doc->sponsorIds;
         $actions = DocAction::where('doc_id', $docId)->whereNotIn('user_id', $skip_ids)->with('user')->orderBy('created_at')->get();
         if ($actions) {
             if (Input::get('download') === 'csv') {
                 $csv = Writer::createFromFileObject(new \SplTempFileObject());
                 $fields = array('first_name', 'last_name', 'email', 'quote', 'text', 'type', 'created_at');
                 // Headings.
                 $csv->insertOne($fields);
                 foreach ($actions as $action) {
                     $actionRow = $action->toArray();
                     $actionRow['first_name'] = $actionRow['user']['fname'];
                     $actionRow['last_name'] = $actionRow['user']['lname'];
                     $actionRow['email'] = $actionRow['user']['email'];
                     // Rearrange our columns
                     $saveRow = array();
                     foreach ($fields as $field) {
                         $saveRow[$field] = $actionRow[$field];
                     }
                     $csv->insertOne($saveRow);
                 }
                 $csv->output('actions.csv');
                 return;
             } else {
                 return Response::json($actions->toArray());
             }
         }
     }
     return Response::notFound();
 }
Exemplo n.º 10
0
 /**
  * @return \yii\db\ActiveQuery
  */
 public function getDocs()
 {
     return $this->hasMany(Doc::className(), ['address_id' => 'id']);
 }
Exemplo n.º 11
0
 public static function getActive($num, $offset)
 {
     // Defaults to limit 10 because of the expense here.
     if (!$num) {
         $num = 10;
     }
     if (!$offset) {
         $offset = 0;
     }
     $docIds = \DB::select(\DB::raw("SELECT doc_id, SUM(num) AS total FROM (\n                    SELECT doc_id, COUNT(*) AS num\n                        FROM annotations\n                        GROUP BY doc_id\n                    UNION ALL\n                    SELECT doc_id, COUNT(*) AS num\n                        FROM comments\n                        GROUP BY doc_id\n                    UNION ALL\n                    SELECT annotations.doc_id, COUNT(*) AS num\n                        FROM annotation_comments\n                        INNER JOIN annotations\n                        ON annotation_comments.annotation_id = annotations.id\n                        GROUP BY doc_id\n\n                ) total_count\n                LEFT JOIN docs on doc_id = docs.id\n                WHERE publish_state = 'published'\n                AND docs.is_template != 1\n                GROUP BY doc_id\n                ORDER BY total DESC\n                LIMIT :offset, :limit"), array(':offset' => $offset, ':limit' => $num));
     $docArray = [];
     //Create array of [id => total] for each document
     foreach ($docIds as $docId) {
         $docArray[$docId->doc_id] = $docId->total;
     }
     $docs = false;
     if (count($docArray) > 0) {
         //Grab out most active documents
         $docs = Doc::getEager()->whereIn('id', array_keys($docArray))->get();
         //Set the sort value to the total count
         foreach ($docs as $doc) {
             $doc->participationTotal = $docArray[$doc->id];
         }
         //Sort by the sort value descending
         $docs = $docs->sortByDesc('participationTotal');
     }
     return $docs;
 }
Exemplo n.º 12
0
 /**
  * @param null $type_id
  * @return \yii\db\ActiveQuery
  */
 public function getDocs($type_id = null)
 {
     if ($type_id !== null) {
         return $this->hasMany(Doc::className(), ['person_id' => 'id'])->where('type_id=' . $type_id);
     }
     return $this->hasMany(Doc::className(), ['person_id' => 'id']);
 }
Exemplo n.º 13
0
 public function getAllStatuses()
 {
     $doc = Doc::with('statuses')->first();
     $statuses = $doc->statuses;
     return Response::json($statuses);
 }
Exemplo n.º 14
0
 public function getFeatured()
 {
     $featuredSetting = Setting::where('meta_key', '=', 'featured-doc')->first();
     if ($featuredSetting) {
         // Make sure our featured document can be viewed by the public.
         $featuredIds = explode(',', $featuredSetting->meta_value);
         $docs = Doc::with('categories')->with('userSponsors')->with('groupSponsors')->with('statuses')->with('dates')->whereIn('id', $featuredIds)->where('publish_state', '=', Doc::PUBLISH_STATE_PUBLISHED)->where('is_template', '!=', '1')->get();
         if ($docs) {
             // Reorder based on our previous list.
             $tempDocs = array();
             $orderList = array_flip($featuredIds);
             foreach ($docs as $key => $doc) {
                 $tempDocs[(int) $orderList[$doc->id]] = $doc;
             }
             // If you set the key of an array value as we do above,
             // PHP will internally store the object as an associative
             // array (hash), not as a list, and will return the elements
             // in the order assigned, not by the key order.
             // This means our attempt to re-order the object will fail.
             // The line below will restore the order. Ugh.
             ksort($tempDocs);
             $docs = $tempDocs;
         }
     }
     // If we don't have a document, just find anything recent.
     if (empty($docs)) {
         $docs = array(Doc::with('categories')->with('userSponsors')->with('groupSponsors')->with('statuses')->with('dates')->where('publish_state', '=', Doc::PUBLISH_STATE_PUBLISHED)->where('is_template', '!=', '1')->orderBy('created_at', 'desc')->first());
     }
     // If we still don't have a document, give up.
     if (empty($docs)) {
         return Response::make(null, 404);
     }
     $return_docs = array();
     foreach ($docs as $key => $doc) {
         $doc->enableCounts();
         $doc->enableSponsors();
         $return_doc = $doc->toArray();
         $return_doc['introtext'] = $doc->introtext()->first()['meta_value'];
         $return_doc['updated_at'] = date('c', strtotime($return_doc['updated_at']));
         $return_doc['created_at'] = date('c', strtotime($return_doc['created_at']));
         if (!$return_doc['thumbnail']) {
             $return_doc['thumbnail'] = '/img/default/default.jpg';
         }
         $return_docs[] = $return_doc;
     }
     return Response::json($return_docs);
 }
Exemplo n.º 15
0
Route::put('api/groups/verify/{groupId}', 'GroupsApiController@putVerify');
// User Login / Signup AJAX requests
Route::get('api/user/login', 'UserManageApiController@getLogin');
Route::post('api/user/login', 'UserManageApiController@postLogin');
Route::get('api/user/signup', 'UserManageApiController@getSignup');
Route::post('api/user/signup', 'UserManageApiController@postSignup');
//Auth Token Route
Route::get('/auth/token', 'AuthController@token');
Route::get('/api/user/login', 'AuthController@login');
Route::get('/api/user/logout', 'AuthController@logout');
/**
 *   RSS Feed Route.
 */
Route::get('docs/feed', function () {
    //Grab all documents
    $docs = Doc::with('sponsor', 'content')->orderBy('updated_at', 'DESC')->take(20)->get();
    $feed = Feed::make();
    $feed->title = 'Madison Documents';
    $feed->description = 'Latest 20 documents in Madison';
    $feed->link = URL::to('rss');
    $feed->pubdate = $docs->first()->updated_at;
    $feed->lang = 'en';
    foreach ($docs as $doc) {
        $sponsor = $doc->sponsor->first();
        if ($sponsor instanceof User) {
            $display_name = $sponsor->fname . ' ' . $sponsor->lname;
        } elseif ($sponsor instanceof Group) {
            $display_name = $sponsor->display_name;
        } else {
            $display_name = '';
        }
Exemplo n.º 16
0
 /**
  * Finds the Doc model based on its primary key value.
  * If the model is not found, a 404 HTTP exception will be thrown.
  * @param integer $id
  * @return Doc the loaded model
  * @throws NotFoundHttpException if the model cannot be found
  */
 protected function findModel($id)
 {
     if (($model = Doc::findOne($id)) !== null) {
         return $model;
     } else {
         throw new NotFoundHttpException('The requested page does not exist.');
     }
 }