Example #1
0
function get_services($params)
{
    if (isset($params['projectId']) == false || $params['projectId'] == null) {
        $query = json_decode(httpResponse(dbUrl() . '/services', null, null), true);
    } else {
        $query = json_decode(httpResponse(dbUrl() . '/projects/' . $params['projectId'] . '/services', null, null), true);
    }
    if (isset($params['sort'])) {
        if (isset($params['order']) == false) {
            $params['order'] = 'DESC';
        }
        if ($params['sort'] == 'name') {
            if ($params['order'] == 'DESC') {
                usort($query, 'sortByTitleDESC');
            } else {
                usort($query, 'sortByTitleASC');
            }
        } else {
            if ($params['sort'] == 'project') {
                if ($params['order'] == 'DESC') {
                    usort($query, 'sortByProjectDESC');
                } else {
                    usort($query, 'sortByProjectASC');
                }
            } else {
                if ($params['sort'] === 'status') {
                    if ($params['order'] == 'DESC') {
                        usort($query, 'sortByStatusDESC');
                    } else {
                        usort($query, 'sortByStatusASC');
                    }
                } else {
                    if ($params['sort'] === 'start') {
                        if ($params['order'] == 'DESC') {
                            usort($query, 'sortByStartDESC');
                        } else {
                            usort($query, 'sortByStartASC');
                        }
                    }
                }
            }
        }
    }
    if (isset($params['ids'])) {
        if (is_array($params['ids']) && count($params['ids']) > 0) {
            $arr = array();
            for ($i = 0; $i < count($query); ++$i) {
                if (in_array(intval($query[$i]['id']), $params['ids'])) {
                    array_push($arr, $query[$i]);
                }
            }
            $query = $arr;
        } else {
            $query = array();
        }
    }
    $query = searchByName($params["filterData"]["text"], $query, "title");
    $checkFeatures = (isset($params['checkFeatures']) and isset($params["filterData"]['companyId']) and $params['checkFeatures'] == true ? true : false);
    $features = getFeaturesIds($params["filterData"]['companyId'], $checkFeatures);
    for ($i = 0; $i < count($query); ++$i) {
        if (in_array(intval($query[$i]['id']), $features['services'])) {
            $query[$i]['inFeatured'] = true;
        }
    }
    $count = count($query);
    $countTypes = array('analytical' => 0, 'solid' => 0, 'data' => 0);
    if (isset($params["filterData"]['type']) && in_array($params["filterData"]['type'], array('analytical', 'solid', 'data'))) {
        $arr = array();
        for ($i = 0; $i < count($query); ++$i) {
            $countTypes[$query[$i]['serviceType']] += 1;
            if ($query[$i]['serviceType'] === $params["filterData"]['type']) {
                array_push($arr, $query[$i]);
            }
        }
        $query = $arr;
    } else {
        for ($i = 0; $i < count($query); ++$i) {
            $countTypes[$query[$i]['serviceType']] += 1;
        }
    }
    if (isset($params['offset']) == false) {
        $params['offset'] = 0;
    }
    if (isset($params['limit'])) {
        $query = array_slice($query, $params['offset'], $params['limit']);
    }
    for ($i = 0; $i < count($query); ++$i) {
        $query[$i]['type'] = 'service';
        $query[$i]['favorite'] = isFavoriteProduct($query[$i]['id'], $query[$i]['type'], null);
        $query[$i] = addMore($query[$i]);
    }
    $result = array('result' => $query, 'count' => $count, 'countTypes' => $countTypes);
    return json_encode($result);
}
Example #2
0
<?php

session_start();
include_once $_SERVER['DOCUMENT_ROOT'] . "/app/etc/dbconfig.php";
if (isset($_GET)) {
    $term = trim(strip_tags($_GET['term']));
    $searchKey = $_GET['searchkey'];
    switch ($searchKey) {
        case 'name':
            $searchData = searchByName($term);
            echo json_encode($searchData);
            break;
        case 'email':
            $searchData = searchByEmail($term);
            echo json_encode($searchData);
            break;
        case 'role':
            $searchData = searchByUserRoleName($term);
            echo json_encode($searchData);
            break;
        case 'shop':
            $searchData = searchByShopName($term);
            echo json_encode($searchData);
            break;
        default:
            break;
    }
}
function searchByName($term)
{
    $query = "SELECT u.entity_id,u.firstname,u.lastname,u.email, s.shop_name , r.role_id, r.role_name from pos_user_entity as u, pos_shop_entity as s, pos_user_roles r where s.entity_id = u.shop_id and r.role_id = u.role_id AND ( u.lastname LIKE '%{$term}%' OR u.firstname LIKE '%{$term}%' )";
Example #3
0
                unlink($file);
            }
            if (move_uploaded_file($_FILES['profile_pic_upload']['tmp_name'], $FileDir)) {
                $connectedUser->_setPhoto(true);
            }
        }
    }
    setcookie("color", $_POST['editColor'], time() + 100000);
    setcookie("police", $_POST['editPolice'], time() + 100000);
    updateTouitos($bd, $connectedUser);
}
include 'nav.php';
?>

	<div id="pageDisplay">

	<?php 
if (isset($_GET['user'])) {
    $th = new TouitosHandler($bd);
    $usr = $th->getByAttr("pseudo", $_GET['user'], PDO::PARAM_STR);
    if ($usr != null) {
        show_profile($usr, $bd);
    }
} else {
    searchByName("", $bd);
}
?>

	</div>
</body>
</html>
Example #4
0
<?php 
require_once "config/connexion.php";
require_once 'fonctions.php';
require_once 'classes/touite.class.php';
if (isset($_GET['search']) && !isset($_GET['moreSearch'])) {
    searchByName($_GET['search'], $bd);
} else {
    if (isset($_GET['moreSearch'])) {
        moreSearchResult($_GET['search'], $bd, $_GET['offset']);
    } else {
        if (!empty($_SESSION['id']) and !empty($_GET['remove'])) {
            delete_message($_GET['id'], $_SESSION['id'], $bd);
        } else {
            if (!empty($_GET['id']) and !empty($_GET['voirMessage'])) {
                voir_message($_GET['id'], $bd);
            } else {
                if (!empty($_SESSION['id']) && !empty($_POST['discution'])) {
                    $touite = array("texte" => $_POST['message'], "idAuteur" => $_SESSION['id']);
                    envoyer_reponse($_POST['id'], new Touite($touite), $bd);
                } else {
                    if (!empty($_POST['message']) && !isset($_POST['sendDiscussion'])) {
                        $touite = array("texte" => $_POST['message'], "idAuteur" => $_SESSION['id']);
                        if (!empty($_POST['id_message'])) {
                            $touite['id_message'] = $_POST['id_message'];
                            $message = new Touite($touite);
                            //réponse
                        } else {
                            $message = new Touite($touite);
                            $message->setLadate(date("Y-m-d H:i:s"));
                            addTouite($message, $bd);
                            $th = new touitosHandler($bd);
Example #5
0
    <?php 
if (isset($_SERVER['HTTP_ORIGIN'])) {
    header("Access-Control-Allow-Origin: {$_SERVER['HTTP_ORIGIN']}");
    header('Access-Control-Allow-Credentials: true');
    header('Access-Control-Max-Age: 86400');
    // cache for 1 day
    header('Content-type: application/json');
}
$data = $_POST["data"];
$type = $_POST["type"];
switch ($type) {
    case 'name':
        searchByName($data);
        break;
    case 'type':
        searchByType($data);
        break;
    default:
        searchByID($data);
        break;
}
function searchByID($id)
{
    if ($id == "") {
        $id = 130;
    }
    $data = ["ID", "Nombre", "Tipo 1", "Tipo 2", "Generacion", "Descripcion", "Altura", "Peso", "Imagen", "Miniatura", "Sonido"];
    $con = mysqli_connect("mysql.hostinger.es", "u439733712_swiol", "17091991", "u439733712_pokem");
    // Check connection
    if (mysqli_connect_errno()) {
        echo "Failed to connect to MySQL: " . mysqli_connect_error();