portal/patient/libs/Reporter/OnsiteActivityViewReporter.php

   1 <?php
   2
   3 /**
   4  * OnsiteActivityViewReporter.php
   5  *
   6  * @package   OpenEMR
   7  * @link      https://www.open-emr.org
   8  * @author    Jerry Padgett <sjpadgett@gmail.com>
   9  * @copyright Copyright (c) 2016-2017 Jerry Padgett <sjpadgett@gmail.com>
  10  * @license   https://github.com/openemr/openemr/blob/master/LICENSE GNU General Public License 3
  11  */
  12
  13 /**
  14  * import supporting libraries
  15  */
  16 require_once("verysimple/Phreeze/Reporter.php");
  17
  18 /**
  19  * This is an example Reporter based on the OnsiteActivityView object.
  20  * The reporter object
  21  * allows you to run arbitrary queries that return data which may or may not fit within
  22  * the data access API. This can include aggregate data or subsets of data.
  23  *
  24  * Note that Reporters are read-only and cannot be used for saving data.
  25  *
  26  * @package Openemr::Model::DAO
  27  * @author ClassBuilder
  28  * @version 1.0
  29  */
  30 class OnsiteActivityViewReporter extends Reporter
  31 {
  32     // the properties in this class must match the columns returned by GetCustomQuery().
  33     // 'CustomFieldExample' is an example that is not part of the `onsite_activity_view` table
  34     public $Id;
  35     public $Date;
  36     public $PatientId;
  37     public $Activity;
  38     public $RequireAudit;
  39     public $PendingAction;
  40     public $ActionTaken;
  41     public $Status;
  42     public $Narrative;
  43     public $TableAction;
  44     public $TableArgs;
  45     public $ActionUser;
  46     public $ActionTakenTime;
  47     public $Checksum;
  48     public $Title;
  49     public $Fname;
  50     public $Lname;
  51     public $Mname;
  52     public $Dob;
  53     public $Ss;
  54     public $Street;
  55     public $PostalCode;
  56     public $City;
  57     public $State;
  58     public $Referrerid;
  59     public $Providerid;
  60     public $RefProviderid;
  61     public $Pubpid;
  62     public $CareTeam;
  63     public $Username;
  64     public $Authorized;
  65     public $Ufname;
  66     public $Umname;
  67     public $Ulname;
  68     public $Facility;
  69     public $Active;
  70     public $Utitle;
  71     public $PhysicianType;
  72
  73     /*
  74      * GetCustomQuery returns a fully formed SQL statement. The result columns
  75      * must match with the properties of this reporter object.
  76      *
  77      * @see Reporter::GetCustomQuery
  78      * @param Criteria $criteria
  79      * @return string SQL statement
  80      */
  81     static function GetCustomQuery($criteria)
  82     {
  83
  84         $sql = "select
  85                         `onsite_activity_view`.`id` as Id
  86                         ,`onsite_activity_view`.`date` as Date
  87                         ,`onsite_activity_view`.`patient_id` as PatientId
  88                         ,`onsite_activity_view`.`activity` as Activity
  89                         ,`onsite_activity_view`.`require_audit` as RequireAudit
  90                         ,`onsite_activity_view`.`pending_action` as PendingAction
  91                         ,`onsite_activity_view`.`action_taken` as ActionTaken
  92                         ,`onsite_activity_view`.`status` as Status
  93                         ,`onsite_activity_view`.`narrative` as Narrative
  94                         ,`onsite_activity_view`.`table_action` as TableAction
  95                         ,`onsite_activity_view`.`table_args` as TableArgs
  96                         ,`onsite_activity_view`.`action_user` as ActionUser
  97                         ,`onsite_activity_view`.`action_taken_time` as ActionTakenTime
  98                         ,`onsite_activity_view`.`checksum` as Checksum
  99                         ,`onsite_activity_view`.`title` as Title
 100                         ,`onsite_activity_view`.`fname` as Fname
 101                         ,`onsite_activity_view`.`lname` as Lname
 102                         ,`onsite_activity_view`.`mname` as Mname
 103                         ,`onsite_activity_view`.`DOB` as Dob
 104                         ,`onsite_activity_view`.`ss` as Ss
 105                         ,`onsite_activity_view`.`street` as Street
 106                         ,`onsite_activity_view`.`postal_code` as PostalCode
 107                         ,`onsite_activity_view`.`city` as City
 108                         ,`onsite_activity_view`.`state` as State
 109                         ,`onsite_activity_view`.`referrerID` as Referrerid
 110                         ,`onsite_activity_view`.`providerID` as Providerid
 111                         ,`onsite_activity_view`.`ref_providerID` as RefProviderid
 112                         ,`onsite_activity_view`.`pubpid` as Pubpid
 113                         ,`onsite_activity_view`.`care_team_provider` as CareTeam
 114                         ,`onsite_activity_view`.`username` as Username
 115                         ,`onsite_activity_view`.`authorized` as Authorized
 116                         ,`onsite_activity_view`.`ufname` as Ufname
 117                         ,`onsite_activity_view`.`umname` as Umname
 118                         ,`onsite_activity_view`.`ulname` as Ulname
 119                         ,`onsite_activity_view`.`facility` as Facility
 120                         ,`onsite_activity_view`.`active` as Active
 121                         ,`onsite_activity_view`.`utitle` as Utitle
 122                         ,`onsite_activity_view`.`physician_type` as PhysicianType
 123                 from `onsite_activity_view`";
 124
 125         // the criteria can be used or you can write your own custom logic.
 126         // be sure to escape any user input with $criteria->Escape()
 127         $sql .= $criteria->GetWhere();
 128         $sql .= $criteria->GetOrder();
 129
 130         return $sql;
 131     }
 132
 133     /*
 134      * GetCustomCountQuery returns a fully formed SQL statement that will count
 135      * the results. This query must return the correct number of results that
 136      * GetCustomQuery would, given the same criteria
 137      *
 138      * @see Reporter::GetCustomCountQuery
 139      * @param Criteria $criteria
 140      * @return string SQL statement
 141      */
 142     static function GetCustomCountQuery($criteria)
 143     {
 144         $sql = "select count(1) as counter from `onsite_activity_view`";
 145
 146         // the criteria can be used or you can write your own custom logic.
 147         // be sure to escape any user input with $criteria->Escape()
 148         $sql .= $criteria->GetWhere();
 149
 150         return $sql;
 151     }
 152 }