Subversion Repositories computer_asset_manager_v1

   /*

    * returns an SQL query to get all available devices

    */

   function getAllDevices () {

      $sql = "select distinct device_id,concat(Device, ' - ', Client, '(', Site, ')' )

              from view_client_site_device";

      $sql .= ' where ' . $_SESSION['where_clause'];

      $sql .= ' order by view_client_site_device.Device';

      return $sql;

   }

   /*

    * Simply returns an SQL with the client_id and the client

    */

   function getClients () {

      return 'select distinct client_id,Client

               from

                  view_client_site_device

                  join maintenance_schedule using ( device_id )

               where maintenance_schedule.removed_date is null 

                     and ' . $_SESSION['where_clause'] .

               ' order by Client';

   }

   /*

    * Return query selecting available sites

    */

   function getSites () {

      return 'select distinct site_id,Site from view_client_site_device where ' . $_SESSION['where_clause'] . ' order by Client,Site';

   }

   function getTechs () {

      return 'select login_id,email from login where removed_date is null order by email';

   }