}
if (isset($_GET['enabled'])) {
$where .= " AND " . C_PRODUCTTYPE_ENABLED . equallike($_GET['enabled'], "int");
}
//======================================================
if (isset($_GET['limit'])) {
$limit = " LIMIT " . $_GET['limit'] . " ";
}
if (isset($_GET['sortby']) && isset($_GET['sortorder'])) {
$sort = " ORDER BY " . $_GET['sortby'] . " " . $_GET['sortorder'] . " ";
}
if (isset($_GET['sortby']) && !isset($_GET['sortorder'])) {
$sort = " ORDER BY " . $_GET['sortby'] . $sortorder . " ";
}
//======================================================
$items = ProductType::get_by_sql("SELECT * FROM " . T_PRODUCTTYPES . " WHERE " . $where . $sort . $limit);
$filename = 0;
if (!isset($_GET['blob'])) {
foreach ($items as $item) {
$filename++;
$random = rand(0, 1);
file_put_contents("images/" . $filename . "x" . $random . ".jpg", base64_decode($item->picture));
$item->picture = HOST . "includes/webservices/images/" . $filename . "x" . $random . ".jpg";
}
}
echo str_replace('\\/', '/', json_encode($items));
//echo json_encode($items, JSON_UNESCAPED_SLASHES);
function equallike($field, $type)
{
$string = "";
if ($type == "string") {
