예제 #1
0
    $app->response()->header('content-type', 'application/json');
    echo json_encode(array('brands' => $brands));
});
/* Get all colors */
$app->get('/shiningfloor/colors', function () use($app, $db) {
    $colors = array();
    foreach ($db->colors() as $color) {
        $colors[] = $color['color_name'];
    }
    $app->response()->header('content-type', 'application/json');
    echo json_encode(array('colors' => $colors));
});
$app->get('/shiningfloor/finish_types', function () use($app, $db) {
    $finish_types = array();
    // $query = $db->products()->group('product_finish_type');
    $query = $db->finishes()->order('finish_name ASC');
    foreach ($query as $finish) {
        if ($finish['finish_name'] != "") {
            $finish_types[] = $finish['finish_name'];
        }
    }
    $app->response()->header('content-type', 'application/json');
    echo json_encode(array('finish_types' => $finish_types));
});
$app->get('/shiningfloor/applications', function () use($app, $db) {
    $applications = array();
    //    $query = $db->products()->group('product_application');
    $query = $db->applications()->order('application_name ASC');
    foreach ($query as $application) {
        if ($application['application_name'] != "") {
            $applications[] = $application['application_name'];