<?php

/**
 * ****************************************************************************************
 * Copyright (c) 2016 Christopher W.
 * Olsen <cwolsen@ubixtechnologies.com>
 * All rights reserved.
 *
 * Redistribution and use in source and binary forms, with or without modification, are
 * permitted provided that the following conditions are met:
 *
 * Redistributions of source code must retain the above copyright notice, this list of
 * conditions, the following disclaimer and the list of authors. Redistributions in binary
 * form must reproduce the above copyright notice, this list of conditions, the following
 * disclaimer and the list of authors in the documentation and/or other materials provided
 * with the distribution. Neither the name of the uBix Cube Project nor the names of its
 * contributors may be used to endorse or promote products derived from this software
 * without specific prior written permission.
 *
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY
 * EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
 * MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL
 * THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
 * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT
 * OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION)
 * HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR
 * TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
 * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 *
 * $Id: users.php 557 2016-04-04 18:48:58Z reddawg $
 *
 * ***************************************************************************************
 */

/* Main include info */
ini_set ( 'include_path', $_SERVER ['DOCUMENT_ROOT'] . "/include/" );
include ("config.php");

$ubF->session->Validate_JSON ( 'A_V_', 1 );

$ret_code = 0;
$ret_msg = "Error";
$ret_data = array ();

switch ($form_data ['req']) {
  case "users_list" :
    
    $query = "SELECT u.uid, u.account_number, a.company, u.status, u.email, u.account_type, u.created FROM users u LEFT JOIN accounts a ON u.account_number = a.account_number ORDER BY company ASC, status DESC, email ASC";
    $res = $ubF->DB ['main']->query ( $query );
    
    if ($res !== true) {
      $ret_code = 1;
      $ret_msg = "Successfully Loaded Users List";
      
      while ( $qData = $res->fetch_assoc () ) {
        if ($qData ['status'] == 0)
          $status = "Inactive";
        else
          $status = "Active";
        
        if ($qData ['account_type'] == 0)
          $aType = "Primary";
        else
          $aType = "Sub";
        
        $ret_data [] = array (
          $qData ['uid'],
          '<a href="/admin/accounts/edit_user.php?data[uid]=' . $qData ['uid'] . '">' . $qData ['email'] . '</a>',
          $qData ['company'],
          $qData ['account_number'],
          $status,
          $aType,
          date ( "m/d/Y", $qData ['created'] ) 
        );
      }
    }
    else {
      $ret_msg = "Unable To Loader Users List";
    }
    
    break;
  default :
    break;
}

$ubF->json_return ( $ret_code, $ret_msg, $ret_data );

/*
 * $query = "SELECT u.uid, u.account_number, a.company, u.status, u.email, u.account_type, u.created FROM users u LEFT JOIN accounts a ON u.account_number = a.account_number ORDER BY company ASC, status DESC, email ASC";
 * $res = $data['ubix_db']->query($query);
 *
 * $rows = "";
 *
 *
 *
 * $ubF->libs['tpl']->assign("ROWS",$rows);
 */

?>