예제 #1
0
$app->get('/shiningfloor/shapes', function () use($app, $db) {
    $product_shapes = array();
    // $query = $db->products()->group('product_material');
    $query = $db->shapes()->order('shape_name ASC');
    foreach ($query as $shape) {
        if ($shape['shape_name'] != "") {
            $product_shapes[] = $shape['shape_name'];
        }
    }
    $app->response()->header('content-type', 'application/json');
    echo json_encode(array('shapes' => $product_shapes));
});
$app->get('/shiningfloor/usages', function () use($app, $db) {
    $product_usages = array();
    // $query = $db->products()->group('product_material');
    $query = $db->usages()->order('usage_name ASC');
    foreach ($query as $usage) {
        if ($usage['usage_name'] != "") {
            $product_usages[] = $usage['usage_name'];
        }
    }
    $app->response()->header('content-type', 'application/json');
    echo json_encode(array('usages' => $product_usages));
});
$app->get('/shiningfloor/sizes', function () use($app, $db) {
    $product_sizes = array();
    $query = $db->products()->group('product_size');
    foreach ($query as $product) {
        if ($product['product_size'] != "") {
            $product_sizes[] = $product['product_size'];
        }