Esempio n. 1
0
        $supplierData = array();
        $query2 = $db->suppliers();
        foreach ($query2 as $p) {
            $supplierData[] = findSupplierDetails($query2);
        }
        $data = array_merge($supplierData, $productData);
        $app->response()->header('content-type', 'application/json');
        echo json_encode(array('supplier_details' => $supplierData, 'supplier_products' => $productData));
    }
});
// For finding usages of given type say tiles or marbles
$app->get('/shiningfloor/products(/:type)/usages', function ($type) use($app, $db) {
    $usages_area;
    $type_id = $db->types()->where('type_name', $type)->select('id')->fetch();
    // $query = $db->products->where('type_id',$type_id);
    $query = $db->products_usages()->where('type_id', $type_id);
    foreach ($query as $p) {
        $usages_area[] = $p->usages['usage_name'];
    }
    $app->response()->header('content-type', 'application/json');
    echo json_encode(array('products_name' => $type, 'locations' => $usages_area));
    // echo json_encode($_GET['sortkey']);
});
// --------------------------------------
$app->get('/shiningfloor/chooseproducts(/:id)', function ($id = null) use($app, $db) {
    $data = array();
    //$query = $db->products();
    global $colorFilters, $priceFilters, $brandFilters;
    global $resultPerPage, $pageNo;
    if (isset($_GET['pageNo'])) {
        $pageNo = (int) $_GET['pageNo'];