PHP Ip DbUtils Examples

Example #1

File: update_profile.php Project: satheesanpv/IP-Valuation

<?php

chdir(dirname(__DIR__));
require_once 'vendor/JWT/JWT.php';
require_once 'lib/Request.php';
require_once 'config/Config.php';
require_once 'lib/DbUtils.php';
use IP\Request;
use IP\DbUtils as DB;
$db = new DB();
$request = new Request();
error_log($request->getMethod());
$request->setAccessHeader();
if ($request->handleOptions()) {
    error_log('Option request. Exit...', 0);
    exit;
}
if (!$request->validate()) {
    error_log('Validation failed. Not authorized!!');
    exit;
}
$user = $request->getJSON();
error_log(json_encode($user));
$message = $db->updateProfile($user);
$output->message = $message;
header('Content-type: application/json');
echo json_encode($output);

Example #2

File: login.php Project: satheesanpv/IP-Valuation

<?php

//chdir(dirname(__DIR__));
//set_include_path('/var/www/valuation/ip/api/');
require_once 'vendor/JWT/JWT.php';
require_once 'lib/password.php';
require_once 'lib/Request.php';
require_once 'config/Config.php';
require_once 'lib/DbUtils.php';
use IP\Request;
use IP\Config;
use IP\DbUtils as DB;
$request = new Request();
$db = new DB();
$request->setAccessHeader();
if ($request->handleOptions()) {
    error_log('Option request. Exit...', 0);
    exit;
}
if (!$request->isPOST()) {
    error_log('Only POST method allowed', 0);
    header('HTTP/1.0 405 Method Not Allowed');
    exit;
}
$input = $request->getJSON();
/*
 * Simple sanitization
 */
//$username = filter_input(INPUT_POST, 'username', FILTER_SANITIZE_STRING);
//$password = filter_input(INPUT_POST, 'password', FILTER_SANITIZE_STRING);
$username = $input->username;

Example #3

File: update_config.php Project: satheesanpv/IP-Valuation

<?php

chdir(dirname(__DIR__));
require_once 'vendor/JWT/JWT.php';
require_once 'lib/Request.php';
require_once 'config/Config.php';
require_once 'lib/DbUtils.php';
use IP\DbUtils as DB;
$db = new DB();
use IP\Request;
$request = new Request();
$request->setAccessHeader();
if ($request->handleOptions()) {
    error_log('Option request. Exit...', 0);
    exit;
}
if (!$request->validate()) {
    error_log('Validation failed. Not authorized!!');
    exit;
}
$input = $request->getJSON();
$key = $input->key;
$value = $input->value;
if ($key) {
    $result = $db->updateConfig($key, $value);
} else {
    $result = "Missing Key!!";
}
//$output->valuation = '1000020';
//error_log(json_encode($result));
header('Content-type: application/json');

Example #4

File: get_user.php Project: satheesanpv/IP-Valuation

<?php

chdir(dirname(__DIR__));
require_once 'vendor/JWT/JWT.php';
require_once 'lib/Request.php';
require_once 'config/Config.php';
require_once 'lib/DbUtils.php';
use IP\Request;
use IP\DbUtils as DB;
$db = new DB();
$request = new Request();
error_log($request->getMethod());
$request->setAccessHeader();
if ($request->handleOptions()) {
    error_log('Option request. Exit...', 0);
    exit;
}
if (!$request->validate()) {
    error_log('Validation failed. Not authorized!!');
    exit;
}
$id = intval($_GET['id']);
error_log(json_encode($id));
$user = $db->getUser(null, $id);
error_log(json_encode($user));
header('Content-type: application/json');
echo json_encode($user);

Example #5

File: delete_user.php Project: satheesanpv/IP-Valuation

<?php

chdir(dirname(__DIR__));
require_once 'vendor/JWT/JWT.php';
require_once 'lib/Request.php';
require_once 'config/Config.php';
require_once 'lib/DbUtils.php';
use IP\DbUtils as DB;
$db = new DB();
use IP\Request;
$request = new Request();
$request->setAccessHeader();
if ($request->handleOptions()) {
    error_log('Option request. Exit...', 0);
    exit;
}
if (!$request->validate('Admin')) {
    error_log('Validation failed. Not authorized!!');
    exit;
}
$input = $request->getJSON();
$userId = $input->userId;
if ($userId) {
    $result = $db->deleteUser($userId);
} else {
    $result = "Missing userId!!";
}
//$output->valuation = '1000020';
//error_log(json_encode($result));
header('Content-type: application/json');
echo json_encode($result);

Example #6

File: get_valuation.php Project: satheesanpv/IP-Valuation

<?php

chdir(dirname(__DIR__));
require_once 'vendor/JWT/JWT.php';
require_once 'lib/Request.php';
require_once 'config/Config.php';
require_once 'lib/DbUtils.php';
use IP\DbUtils as DB;
$db = new DB();
use IP\Request;
$request = new Request();
$request->setAccessHeader();
if ($request->handleOptions()) {
    error_log('Option request. Exit...', 0);
    exit;
}
if (!$request->validate()) {
    error_log('Validation failed. Not authorized!!');
    exit;
}
$input = $request->getJSON();
$id = $input->id ? $input->id : $_GET['id'];
$userId = $input->userId ? $input->userId : $_GET['userId'];
$result = $db->getValuation($id, $userId);
//$output->valuation = '1000020';
//error_log(json_encode($result));
header('Content-type: application/json');
echo json_encode($result);

Example #7

File: get_config.php Project: satheesanpv/IP-Valuation

<?php

chdir(dirname(__DIR__));
require_once 'vendor/JWT/JWT.php';
require_once 'lib/Request.php';
require_once 'config/Config.php';
require_once 'lib/DbUtils.php';
use IP\DbUtils as DB;
$db = new DB();
use IP\Request;
$request = new Request();
$request->setAccessHeader();
if ($request->handleOptions()) {
    error_log('Option request. Exit...', 0);
    exit;
}
/*if (!$request->validate()) {
  error_log('Validation failed. Not authorized!!');
    exit;
} */
$input = $request->getJSON();
$name = $input->name ? $input->name : $_GET['name'];
$result = $db->getConfig($name);
//$output->valuation = '1000020';
//error_log(json_encode($result));
header('Content-type: application/json');
echo json_encode($result);

Example #8

File: create_user.php Project: satheesanpv/IP-Valuation

<?php

//chdir(dirname(__DIR__));
require_once 'vendor/JWT/JWT.php';
require_once 'lib/Request.php';
require_once 'config/Config.php';
require_once 'lib/sendMail.php';
require_once 'lib/DbUtils.php';
use IP\Request;
use IP\DbUtils as DB;
use IP\sendMail;
$db = new DB();
$request = new Request();
error_log($request->getMethod());
$request->setAccessHeader();
if ($request->handleOptions()) {
    error_log('Option request. Exit...', 0);
    exit;
}
$user = $request->getJSON();
if (!$request->validate('Admin')) {
    $user->status = 'Pending';
} else {
    $user->status = 'Approved';
}
if (!$user->username || !$user->email || !$user->name || !$user->institute) {
    $message = "FAILED: Missing required fields!!";
} else {
    $message = $db->createUser($user);
}
$output->message = $message;

Example #9

File: valuation.php Project: satheesanpv/IP-Valuation

<?php

chdir(dirname(__DIR__));
require_once 'vendor/JWT/JWT.php';
require_once 'lib/Request.php';
require_once 'config/Config.php';
require_once 'lib/DbUtils.php';
use IP\DbUtils as DB;
$db = new DB();
use IP\Request;
$pr = [110, 105, 105, 105];
$g = [100.01, 100.01, 100.01, 100.01];
function costMethod($data)
{
    global $pr, $g;
    $data->t = $data->t > 0 ? $data->t : 1;
    $data->op = $data->op > 0 ? $data->op : 1;
    $data->d = $data->d > 0 ? $data->d : 10;
    $ip = ($data->fxa * $data->d / 100 + $data->ifc + ($data->oc + $data->s) / 12 * $data->t + $data->oh) / $data->op * (1 + $data->p / 100);
    addResult('Cost Method', $ip);
    return $ip;
}
function royaltyMethod($data)
{
    global $pr, $g;
    $data->yr = $data->yr > 0 ? $data->yr : 4;
    $ip = 0;
    $r = $data->r;
    for ($i = 0; $i < $data->yr; $i++) {
        $pbd = $r * ($data->ry / 100);
        $pad = $pbd * (1 - ($data->adc + $data->it) / 100);

Example #10

File: change_password.php Project: satheesanpv/IP-Valuation

<?php

chdir(dirname(__DIR__));
require_once 'vendor/JWT/JWT.php';
require_once 'lib/Request.php';
require_once 'config/Config.php';
require_once 'lib/DbUtils.php';
use IP\Request;
use IP\DbUtils as DB;
$db = new DB();
$request = new Request();
$request->setAccessHeader();
if ($request->handleOptions()) {
    error_log('Option request. Exit...', 0);
    exit;
}
$user = $request->getJSON();
$username = $user->username;
$password = $user->password;
if (!$request->validate(null, $username)) {
    error_log('Validation failed. Not authorized!!');
    exit;
}
try {
    $rs = $db->getUser($username);
    if ($rs) {
        if (password_verify($password, $rs['password'])) {
            $user->iduser = $rs['iduser'];
            $message = $db->updatePassword($user);
        } else {
            $message = "Current password do not match!!!";

Example #11

File: approve_user.php Project: satheesanpv/IP-Valuation

<?php

//chdir(dirname(__DIR__));
require_once 'vendor/JWT/JWT.php';
require_once 'lib/Request.php';
require_once 'config/Config.php';
require_once 'lib/DbUtils.php';
require_once 'lib/sendMail.php';
use IP\DbUtils as DB;
use IP\sendMail;
$db = new DB();
use IP\Request;
$request = new Request();
$request->setAccessHeader();
if ($request->handleOptions()) {
    error_log('Option request. Exit...', 0);
    exit;
}
if (!$request->validate('Admin')) {
    error_log('Validation failed. Not authorized!!');
    exit;
}
$input = $request->getJSON();
$userId = $input->userId;
if ($userId > 0) {
    $user = $db->getUser(null, $userId);
    if (!$user) {
        $result = "No user found with id: " . $userId;
    } else {
        $result = $db->approveUser($userId);
        if ($result == "SUCCESS") {