Beispiel #1
0
 public static function register($params)
 {
     if (!isset($GLOBALS[TUNA_RW]) || !$GLOBALS[TUNA_RW] || $GLOBALS[TUNA_RW] instanceof Error) {
         $GLOBALS[TUNA_RW] = WBB_Database::load(TUNA_RW);
     }
     $clean = array();
     $clean_update = array();
     $sql = "SELECT MAX(`id`) as id FROM  `" . DB_TUNA . "`.`users` ";
     $GLOBALS[TUNA_RW]->query($sql);
     while ($row = $GLOBALS[TUNA_RW]->fetchAssoc()) {
         $next_id = $row['id'];
     }
     $params['id'] = (string) ($next_id + 1);
     /* validate values using the "forswitch" technique */
     foreach ($params as $key => $value) {
         switch ($key) {
             case 'id':
             case 'email':
                 if (!is_string($value) || strlen($value) == 0) {
                     throw new Error(400, 'Incorrect ' . $key . ' Value');
                 }
                 $clean[$key] = '`' . $key . '` = "' . $GLOBALS[TUNA_RW]->escapeString($value) . '"';
                 break;
             case 'password':
                 if (!is_string($value) || strlen($value) == 0) {
                     throw new Error(400, 'Incorrect ' . $key . ' Value');
                 }
                 $clean[$key] = '`' . $key . '` = "' . crypt($value, 'armium') . '"';
                 break;
             default:
                 throw new Error(400, 'Incorrect Param ' . $key);
                 break;
         }
     }
     if (count($clean) <= 0) {
         throw new Error(400, 'No data to save');
     }
     $sql_set = implode(',', $clean);
     $sql_update = implode(',', $clean_update);
     $sql = 'INSERT INTO `' . DB_TUNA . '`.`users` SET ' . $sql_set . ", `creation` = NOW()";
     try {
         // return true;
         $GLOBALS[TUNA_RW]->query($sql);
         $permissions[] = 'grant';
         $permissions[] = 'is_med';
         $permissions[] = $params['id'];
         $profile['id'] = $params['id'];
         $profile['name'] = 'Cambiame por tu nombre';
         User::update_permissions($permissions);
         User::update_profile($profile);
     } catch (Error $e) {
         throw new Error(409, 'El Ususario ya existe!');
     }
 }
Beispiel #2
0
 public function remove_date($params)
 {
     if (!isset($GLOBALS[TUNA_RO]) || !$GLOBALS[TUNA_RO] || $GLOBALS[TUNA_RO] instanceof Error) {
         $GLOBALS[TUNA_RO] = WBB_Database::load(TUNA_RO);
     }
     $sql = 'DELETE FROM `' . DB_TUNA . '`.`user_calendar` WHERE id = "' . $params['id'] . '" LIMIT 1';
     if ($GLOBALS[TUNA_RO]->query($sql)) {
         return true;
     }
     return false;
 }
Beispiel #3
0
 public function add_qty($params)
 {
     if (!isset($GLOBALS[TUNA_RO]) || !$GLOBALS[TUNA_RO] || $GLOBALS[TUNA_RO] instanceof Error) {
         $GLOBALS[TUNA_RO] = WBB_Database::load(TUNA_RO);
     }
     $result = array();
     $sql = 'UPDATE `' . DB_TUNA . '`.`user_' . $params['list'] . '_inv` SET `' . $params['list'] . '_qty` = (`' . $params['list'] . '_qty` + 10) WHERE `id` = ' . $params['id'] . ' LIMIT 1';
     if ($GLOBALS[TUNA_RO]->query($sql)) {
         return true;
     }
     return false;
 }
Beispiel #4
0
 public function get_list($params)
 {
     if (!isset($GLOBALS[TUNA_RO]) || !$GLOBALS[TUNA_RO] || $GLOBALS[TUNA_RO] instanceof Error) {
         $GLOBALS[TUNA_RO] = WBB_Database::load(TUNA_RO);
     }
     $condition = '';
     if (isset($params['id']) && $params['id'] != '') {
         $condition = ' AND paciente_id = ' . $params['id'];
     }
     $result = array();
     $sql = 'SELECT * FROM `' . DB_TUNA . '`.`consults` WHERE `consult_status` <> "deleted" ' . $condition;
     $GLOBALS[TUNA_RO]->query($sql);
     if ($GLOBALS[TUNA_RO]->numRows() > 0) {
         $result['data'] = $GLOBALS[TUNA_RO]->fetchAll();
     }
     return $result;
 }
Beispiel #5
0
 public function get_sub_account($params)
 {
     if (!isset($GLOBALS[TUNA_RO]) || !$GLOBALS[TUNA_RO] || $GLOBALS[TUNA_RO] instanceof Error) {
         $GLOBALS[TUNA_RO] = WBB_Database::load(TUNA_RO);
     }
     $result = array('data' => array(), 'totals' => 0);
     $sql = 'SELECT SQL_CALC_FOUND_ROWS * FROM `' . DB_TUNA . '`.`user_sub_accounts` WHERE `user_id` = ' . $params['user_id'];
     //$sql .= $condition;
     //$sql .= ' ORDER BY `name` LIMIT '.$offset.','.$limit;
     $GLOBALS[TUNA_RO]->query($sql);
     if ($GLOBALS[TUNA_RO]->numRows() > 0) {
         while ($row = $GLOBALS[TUNA_RO]->fetchAssoc()) {
             if ($row != null) {
                 $result['data'][] = $row;
             }
         }
         $GLOBALS[TUNA_RO]->query('SELECT FOUND_ROWS() as `total`');
         $row = $GLOBALS[TUNA_RO]->fetchAssoc();
         $result['total'] = $row['total'];
     }
     return $result;
 }
Beispiel #6
0
 public function __construct()
 {
     if (!isset($GLOBALS[DB_TUNA]) || !$GLOBALS[DB_TUNA] || $GLOBALS[DB_TUNA] instanceof Error) {
         $GLOBALS[DB_TUNA] = WBB_Database::load(DB_TUNA);
     }
 }
Beispiel #7
0
 public static function update($parameters)
 {
     $message = "";
     // $parameters['user'] = json_decode($parameters['user']);
     // foreach ($parameters['user']->permissions as $key => $value) {
     // 	$permissions[] = $value->description;
     // }
     // if(!in_array('is_shop_admin',$permissions ) && (int)($parameters['id']))
     // {
     // 	throw new Error( 400, 'You dont have the required permissions to add the Product Id');
     // }
     // if(!in_array('is_woa',$permissions ) && !(int)($parameters['id']))
     // {
     // 	throw new Error( 400, 'You dont have the required permissions to add the Gamespace');
     // }
     unset($parameters['user']);
     if (!isset($GLOBALS[TUNA_RW]) || !$GLOBALS[TUNA_RW] || $GLOBALS[TUNA_RW] instanceof Error) {
         $GLOBALS[TUNA_RW] = WBB_Database::load(TUNA_RW);
     }
     $clean = array();
     $clean_update = array();
     /* validate values using the "forswitch" technique */
     foreach ($parameters as $key => $value) {
         switch ($key) {
             case 'id':
             case 'name':
                 if (!is_string($value) || strlen($value) == 0) {
                     throw new Error(400, 'Incorrect Name Value');
                 }
                 $clean[$key] = '`' . $key . '` = "' . $GLOBALS[TUNA_RW]->escapeString($value) . '"';
                 break;
             case 'status':
                 if (!is_bool($value)) {
                     throw new Error(400, 'Incorrect Status Value');
                 }
                 $clean[$key] = '`' . $key . '` = "' . (bool) $value . '"';
                 break;
             default:
                 throw new Error(400, 'Incorrect Param ' . $key);
                 break;
         }
         /* Prepare "on duplicate key update" */
         $clean_update[$key] = '`' . $key . '` = VALUES(`' . $key . '`)';
     }
     if (count($clean) <= 0) {
         throw new Error(400, 'No data to save');
     }
     $sql = "SELECT * FROM  `%s`.`products` WHERE {$clean['name']} OR {$clean['id']}";
     $sql = sprintf($sql, DB_TUNA);
     $GLOBALS[TUNA_RW]->query($sql);
     /* name-id validation to avoid collisions on these */
     if ($var = $GLOBALS[TUNA_RW]->fetchALL()) {
         if (count($var) == 2) {
             throw new Error(409, 'One of your values (maybe both) is in use; try changing one of them.');
         }
         if (strtolower($var[0]["name"]) == strtolower($parameters["name"])) {
             if ($var[0]["status"] == "available") {
                 throw new Error(409, 'Product name already exist.');
             } else {
                 if ($var[0]["id"] == $parameters["id"]) {
                     $message .= "{$parameters['name']} rehabilitated; current status: {$var[0]['status']}.";
                     $found = true;
                 } else {
                     $message .= "id changed from {$var[0]['id']} to {$parameters['id']}; current status: {$var[0]['status']}.";
                 }
             }
         } else {
             $message .= "name changed from {$var[0]['name']} to {$parameters['name']}; current status: {$var[0]['status']}.";
         }
     }
     $sql_set = implode(',', $clean);
     $sql_update = implode(',', $clean_update);
     $sql = 'INSERT INTO `' . DB_TUNA . '`.`products` SET ' . $sql_set . ", `creation` = NOW()";
     $sql .= ' ON DUPLICATE KEY UPDATE ' . $sql_update . ", `status` = 'available'";
     if ($GLOBALS[TUNA_RW]->query($sql)) {
         if ($message) {
             $desc = array("Event" => "Product update", "Message" => $message);
             TunaLog::info_log(__CLASS__, __FUNCTION__, $_SERVER['REMOTE_USER'], $desc);
         }
         $desc = array('id' => $parameters['id'], 'name' => $parameters['name']);
     }
 }
Beispiel #8
0
 public function get_subaccounts($params)
 {
     $condition = ' * ';
     if (isset($params['qty']) && $params['qty']) {
         $condition = ' COUNT(id) as accounts ';
     }
     if (!isset($GLOBALS[TUNA_RW]) || !$GLOBALS[TUNA_RW] || $GLOBALS[TUNA_RW] instanceof Error) {
         $GLOBALS[TUNA_RW] = WBB_Database::load(TUNA_RW);
     }
     $result = array();
     $sql = 'SELECT ' . $condition . ' FROM `' . DB_TUNA . '`.`user_sub_accounts` WHERE user_id = ' . $params['id'];
     $GLOBALS[TUNA_RW]->query($sql);
     $result = $GLOBALS[TUNA_RW]->fetchAssoc();
     return $result['accounts'];
 }
Beispiel #9
0
 public static function check_notifications($parameters)
 {
     try {
         $client_id = $parameters['client_id'];
         if (!isset($GLOBALS[TUNA_RO]) || !$GLOBALS[TUNA_RO] || $GLOBALS[TUNA_RO] instanceof Error) {
             $GLOBALS[TUNA_RO] = WBB_Database::load(TUNA_RO);
         }
         $sql = 'SELECT * FROM `' . DB_TUNA . '`.`client_ids_monitoring` WHERE `client_id`="' . $client_id . '" LIMIT 1';
         $GLOBALS[TUNA_RO]->query($sql);
         if ($GLOBALS[TUNA_RO]->numRows() > 0) {
             $sql = 'UPDATE `' . DB_TUNA . '`.`client_ids_monitoring` SET `status`="deleted" WHERE `client_id`="' . $client_id . '" LIMIT 1';
             $GLOBALS[TUNA_RW]->query($sql);
             return true;
         }
     } catch (Event $e) {
         throw new Error(400, 'Error generating notification!');
     }
 }
Beispiel #10
0
 public function delete_registry($params)
 {
     if (!isset($GLOBALS[TUNA_RO]) || !$GLOBALS[TUNA_RO] || $GLOBALS[TUNA_RO] instanceof Error) {
         $GLOBALS[TUNA_RO] = WBB_Database::load(TUNA_RO);
     }
     $result = array();
     $sql = 'UPDATE `' . DB_TUNA . '`.`user_registry` SET `registry_status` = "deleted" WHERE `id` = ' . $params['id'] . ' LIMIT 1';
     if ($GLOBALS[TUNA_RO]->query($sql)) {
         return true;
     }
     return false;
 }