使用PHP的Shopify API，redirect_uri和应用程序url必须具有myshopify.com的匹配主机？(Shopify API using PHP, redirect_uri and app url must have matching hosts of myshopify.com?)

 解决了，我只使用原生SQL，addScalar方法和List of Object []，以及大的查询： 
 
Session session = null;
    List<Object[]> catalogStores = new ArrayList();
    try {
        session = this.sessionFactory.openSession();
        catalogStores = session.createSQLQuery("select \n" +
                "    t1.name as goodsName,\n" +
                "    t3.name as companyName,\n" +
                "    sum(t2.amount) as amountSum,\n" +
                "    t3.price as priceOneGoods,\n" +
                "    (t1.price * sum(t2.amount)) as summ \n" +
                "from\n" +
                "    store_catalog t1\n" +
                "        inner join\n" +
                "    commission t2 ON (t1.id = t2.idGoodsStore)\n" +
                "        inner join\n" +
                "    company_catalog t3 ON (t3.id = t2.idGoodsCompany)\n " +
                "       inner join\n" +
                "   store t4 ON (t1.idStore = " + idStore + ")\n " +
                "group by t1.id")
                .addScalar("goodsName", new StringType())
                .addScalar("companyName", new StringType())
                .addScalar("amountSum", new IntegerType())
                .addScalar("priceOneGoods", new DoubleType())
                .addScalar("summ", new DoubleType())
                .list();
    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        if (session != null && session.isOpen())
            session.close();
    }
    return catalogStores;
 
 在我的JSP节目中，如： 
 
<c:forEach items="${statList1}" var="stat">
  <tr class="editField">
    <td>
      <c:out value="${stat[0]}" />
    </td>
    <td>
      <c:out value="${stat[1]}" />
    </td>
    <td>
      <c:out value="${stat[2]}" />
    </td>
    <td>
      <c:out value="${stat[3]}" />
    </td>
    <td>
      <c:out value="${stat[4]}" />
    </td>
  </tr>
</c:forEach>
 
 控制器中的部件代码： 
 
modelAndView.addObject("statList1", myService.myMethod());

Solved, I just use native SQL, addScalar method, and List of Object[], and big big query:
 
Session session = null;
    List<Object[]> catalogStores = new ArrayList();
    try {
        session = this.sessionFactory.openSession();
        catalogStores = session.createSQLQuery("select \n" +
                "    t1.name as goodsName,\n" +
                "    t3.name as companyName,\n" +
                "    sum(t2.amount) as amountSum,\n" +
                "    t3.price as priceOneGoods,\n" +
                "    (t1.price * sum(t2.amount)) as summ \n" +
                "from\n" +
                "    store_catalog t1\n" +
                "        inner join\n" +
                "    commission t2 ON (t1.id = t2.idGoodsStore)\n" +
                "        inner join\n" +
                "    company_catalog t3 ON (t3.id = t2.idGoodsCompany)\n " +
                "       inner join\n" +
                "   store t4 ON (t1.idStore = " + idStore + ")\n " +
                "group by t1.id")
                .addScalar("goodsName", new StringType())
                .addScalar("companyName", new StringType())
                .addScalar("amountSum", new IntegerType())
                .addScalar("priceOneGoods", new DoubleType())
                .addScalar("summ", new DoubleType())
                .list();
    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        if (session != null && session.isOpen())
            session.close();
    }
    return catalogStores;
 
And in my JSP show, as like as:
 
<c:forEach items="${statList1}" var="stat">
  <tr class="editField">
    <td>
      <c:out value="${stat[0]}" />
    </td>
    <td>
      <c:out value="${stat[1]}" />
    </td>
    <td>
      <c:out value="${stat[2]}" />
    </td>
    <td>
      <c:out value="${stat[3]}" />
    </td>
    <td>
      <c:out value="${stat[4]}" />
    </td>
  </tr>
</c:forEach>
 
Part code in controller:
 
modelAndView.addObject("statList1", myService.myMethod());